Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Module works fine in 97 but not in 2000; I'm Desperate!
Bob: Thanks for the advice. Unfortunately it doesn't seem to be the answer. After making the changes you suggested, the code ran a bit faster (45 secs). The file size still grew the same amount. Compacting on close doesn't help in my situation. My code example is only a small portion of...- dowally
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Module works fine in 97 but not in 2000; I'm Desperate!
When I run the code below in Access 97, it loops thru 16,000+ records and takes about 4 seconds. The mdb file size changes from 1788KB to 1872KB. When I run the exact same code in Access 2000, it takes 60 seconds and the file size balloons from 2364KB to 69,932KB. After compacting, file size...- dowally
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Type Mismatch?
Access may be asking what type of recordset you are trying to open, for instance, dbOpenTable. Not sure, just a thought.- dowally
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Changing Background style of a form in Access 97
With the form open in design view, open the properties box. You should find a picture property within the format tab. Type in the complete path to the location of your bitmap file. If this works, you may want to have the picture type property set to embedded ( I believe this saves the...- dowally
- Post #4
- Forum: Microsoft: Access Other topics
