Search results for query: *

I've inherited a db to clean with thousands of queries. I need to find what objects (tables, reports, etc) are connected to those queries so I can start deleting some of the unneccesary ones. Are there any programs that can help me do this? Thanks, Jack Walsh

I've found the culprit. I had an autoexec macro load a hidden form to detect idle time. If a user wasn't in the db for 30 minutes (I could adjust this) it would close MS Access. When I deleted this macro, the code area went back to normal. Thanks for all your suggestions. Jack

Thanks Jeremy but I don't find any version numbers. The VBAs that are listed are c:\winnt\system32\vbaen32.olb,..msvbvm50.dll,..ven2232.olb,..msvbvm60.dll,..vbaend32.olb and c:\program files\commonfiles\microsoft shared\vba\vba332. The one that is checked is c:\program...

The problem seems to be with the db. I run other db's and access is normal. I've taken this db home and used it on my home computer and the vba code is once again garbled. It must be something in the db. I've setup a new db, imported all the objects and it still acts the same way. ? Jack

When I'm in the code window and type me.(dot) it used to give me what code options I had and then sit and wait for me to choose. It now closes the options dropdown. When I start to type options or lists it types them out of order - i.e. if I want to type me.close it will type me.osecl or if I...

I am running W2K and Access2K. I see in the reference section there are at least a half a dozen VBA references I could check. I tried checking multiple ones and it gives me an error message and won't let me. Any suggestions on which to choose? Thanks, Jack Walsh

I just want to thank all of you for your great ideas. I made a batch file that downloads the frontend to the users C: drive and runs it from there and I haven't had one repair and refresh. Thanks again. Jack

Yes I do use some temp tables and global variables. But to clarify my overall db - both backend and frontend are on the network and each user has a desktop shortcut to the front end. Because we need to repair so many times daily, I just email the users and tell them that the db has been repaired...

I make them all exit the db, then I repair and compact it. They all find that quite annoying. It very rarly happens to me that I can't get in. Jack

I am running a frontend/backend db over a NT network. I have 8 users, all running Win2K and Access2K. I do my developing on a copy of the frontend on my C drive and each night copy this over the one on the network. The problem that arrises daily is first thing in the morning, lets say 5 users...

Thanks Jeff. That worked great. I appreciate the help. Jack

I have a combo box on a form that finds records in a table or query. It's a lastname, firstname lookup. It works fine except for people with an apostrophe in their name - i.e. O'Malley, George. It gives me a 3077 runtime error (Missing operator in expression). The code looks like: Dim rs As...