Search results for query: *

There are often threads started by members looking how to use JET SQL and the JET VBA functions. I just want to point out two often overlooked help files which you should find on your hard drive if anyone has installed VB6 SP5 JETSQL35.HLP JETSQL40.CHM These help files, especially the...

Anyone know how can I remove the icon overlay, (which identifies the icon is a shortcut), from a desktop shortcut icon, but for a single Shortcut item (instead of all)?

We have another system set up with W2000 Server SP3. This one is set up using the German version. The system was initially installed about 2 months ago with W2000 and, nothing done with it since. Then last month with SP3, and some other programs. No problem. Last week I decided put this system...

Normally, when using a DataGrid, or any other complex data bound object with an ADO recordset created using the JET OLEDB Data provider, you needed to use a Client Side Cursor in order for data to be displayed in the grid. This is because the JET OLEDB provider does not support the...

"Get in...and Get right back Out" Does anyone have any input/comments, pros/cons, concerning the use of the following With/New methods: With New SomeObject 'Some code End With Or: With CreateObject("SomeLibrary.SomeObject") 'Some code End With As in: 'conn is an...

I guess I'm a little exhasted from testing. I cannot seem to figure something out. I am trying to find the fastest method for finding and replacing text using VB methods. I am using the below ReplaceX function which is a (partial)substitue for the VB Replace function. Now, the ReplaceX...

I have gotten into a debate concerning the use of constants for numbers: The question was raised: Which of the following: 1. is more/less efficient 2. how much more/less effiecient 3. and if more efficient, when should it be used, and not used? 4. Solid arguments for the pros and cons (no...