Garbled Code

[jwjw]

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 type docmd.close "This report" it will type docmd.close"isThreport " eliminating the spaces and changing the letters around. I have tried to repair the Access installation, which it says succeeded, but to no avail. Any ideas would be helpful. Thanks,

Jack Walsh

 

[EvilCabal]

As simple as this may seems, the answer to this kind of problem is often to uninstall office and to do a clean install from scratch.

I faced many weird problems (never got one as weird as this one though ) and, as a last resort, this solution always worked for me.

 

[jwjw]

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

 

[EvilCabal]

Hey, I'm just thiking aloud here but maybe you are infected with a virus. Try importing objects one at a time to a new database and check if it acts the same after each objects, maybe one object in particular is causing the problem. Also, remove any code that run when you open the database, maybe it corrupts something and cause the database to act as it does.

These are just some ideas, I never ran across any problem similar to this one so I might be completely wrong but it won't hurt to give it a try.

Good luck!

 

[jwjw]

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