Search results for query: *

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...

Been messing with this for days now. Have two groups: inside group has a next page after which works fine. The outside group needs to print an additional page 'This page intentionally left blank' when the data for that group ends on a even page number. In other words, report must always end on...

I'm trying to place either a '$' sign or append a '%' sign to numbers in a row base on the value of another field. I can conditionally get the '$' to display correctly using a formula, but have not found any way to conditionally append the '%' sign.

I have a procedure that needs to select/sort through a table 10 times. The only thing different in each select is the 'where' and 'order by' clauses. I need to use a cursor to process but don't want to duplicate processing code for each cursor ten times since the routine is the same for each...

SqlServer 2000. Is there a method to declare a variable of the name and datatype of each column in a cursor, like %rowtype or %type in Oracle? Can table variables be mapped automatically to cursors?

Getting 'Workgroup file is missing or opened exclusively by another user' error when trying to use dts on access db. I can open the mdb just fine through access. It is on my machine so no one else could have it open. I close it before attempting the import. Any ideas?