Recent content by lifeson99

Yes, well it is a big time-saver for me. Obviously there are many ways to do this. I am taking a slow-to-query gigantic DB with 2.6 million records and speeding it up dramatically by breaking the table into 26 smaller tables. One table per letter of the alphabet (all the States that start...

OIC - yes well the only reason for this was that I though I could avoid having to even go into the VBE editor to run the Subroutines and instead run them from the Access GUI. You know, if you end up with a lot of Subs and/or Functions it is difficult to poke around the VBE and find them...

Yes I am - exactly. Under the Tools/Macros menu selection. Bob said to use RunCode not RunMacro. But I do not know what either of those terms means, so I followed his two-step instructions: 1. make sure your procedures are FUNCTIONS and not SUBS. I changed it to a Public Function 2. They...

That did not work. I changed it to a Public Functions and save the file to be sure. But when I went to Run Macro, there are still no macros listed. Here is my code: Public Function AZ_Queries() With DoCmd .SetWarnings False .OpenQuery "Make A" .OpenQuery "Make B"...

I am new to doing this with Access. But with Excel I would go to the VBE, type in "Sub MySub" for example, add in the code, then go back to Excel and select Tools/Macros . . . and "MySub" is listed there for running. OK, so I did the same thing with Access so that I can run some code, and again...