Recent content by chelandrew

Thanks folks. Just so I get this right, I can begin performing all the steps necessary to setup a domain without affecting current users using workgroups?

Our LAN is currently setup using workgroups and we need to change to a domain configuration. I've looked extensively throught the MS site and can't seem to find any articles addressing this issue. Any articles available as to what steps are required to accomplish this? Also, can workgroups and...

Thanks, this helped a lot. After more investigation, it appears that the component refs are stored in the HKEY_LOCAL_MACHINE registry and are global to all projects. Is this right? Is there a way to keep the references at the project level?

Yes, this will work if I knew which files to copy since there are multiple versions available. I'd just like to understand what happened and why so I can prevent this from happening again. Thanks for the reply.

I'm an experienced programmer but new to VB. I inherited a project that I modified and have successfully compiled. I had to reboot my machine, now when I open the project it can't find references to ocx, dll etc. The directories it is trying to find them in are not what it previously looked in...

Thanks for the response. I've looked there, and there is no help file listed. Is it possible that it is set at runtime somewhere?

I've inherited a VB app that opens a .hlp file when a user presses a 'Help' button. I need to change the name of the .hlp file but can not figure out where/how in the code this file is being opened. Code for button pressed just does a sendkeys {F1}. How are actions assigned to function keys?

I have a form based VB app that includes a VBA form in Access 2000 to run reports. Whenever I go to the reports form and then return to the VB app and try to open a form I get a Runtime Error 3163 - Field too small... This only happens when I return from the VBA report form and only seems to...

Is there a method that can be called that can change column names in access2000? Problem relates to the length of some column names that cause big problems via ODBC.

Try using the Virtual Tables feature in sql server 2000. They act like temp tables but are faster and more efficient.

MS Sql uses the CASE statement, not IF..THEN..ELSE

Get a 'General OLE Error 16386' when trying to connect to remote sqlserver 2000 from enterprise manager client. Yet I can connect just fine with utilities like osql or query analyzer. I've checked connect properties and they are correct. Worked fine up until a few days ago. Reboot didn't help.

Finally got it working with variable and a few other formulas. Thanks for your help. If you'd like to see solution, let me know.

Not sure how to use a variable. Can't seem to reference it from other formulas unless I put it in a field. Actually, everything works ok except one condition. When the last record is the first detail line on the page then the conditional page header can't distinguish whether it was the last...

Ok, I got that working. The part I'm really having trouble with is printing the special 'This page intentionally left blank' page. Can't seem to trap what caused the new page, the formula or just normal report processing. If I can determine that, I think I could create another page header...