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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: wildcanada1
- Order by date
-
And Template For Clearing all FIELDS in a Recordset?
If you get the error "ITEM IS NOT FOUND IN THIS COLLECTION", does this not mean that the fields that you are trying to edit are NOT in the recordset?? What are the names of your fields? Just field1, field2, etc?? Mike- wildcanada1
- Post #8
- Forum: Microsoft: Access Modules (VBA Coding)
-
Compacting Database
Jim, But lets say this database is on the network available to 10 users. The method that I posted to have it compact and startup automatically would be the right way to go I assume? I suppose you could have the Startup database automatically run instead of having the user click the button ...- wildcanada1
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
What's a good way to learn VBA?
The way that I learnt was by opening up Access and just trying different things. Try little things like displaying message boxes, printing to the debug window, closing forms, etc .. the help files in access are not that bad. And of course the best way to learn is to grab other people's code...- wildcanada1
- Post #12
- Forum: Microsoft: Access Modules (VBA Coding)
-
Compacting Database
Hi all For awhile now I've been looking over the ways to compact a database in Access '97 and I finally found a solution that I like. -- Create a new database called "startup.mdb". -- Create a form with one button with the following code behind it: Private Sub cmdCOMPACT_Click()...- wildcanada1
- Thread
- Replies: 7
- Forum: Microsoft: Access Modules (VBA Coding)
