Today I tried to test the project I worked on few days ago, everytime when I tried to click commands, "Module not found" error message was poped up. I checked the event procedure under the commands, I didn'd see any error in there. I have no idea about this message at all. Any suggestions?

flyfish

__________________
flyfish

Sounds like a corrupt database or previous compile information hanging out where it shouldn't. Yes, Access does compile your VBA.

Start by taking a back up of the database and putting it in a safe place.

A couple of directions to take.

Perhaps the easiest is to start Access with the /decompile parameter then open your database. This clears any previous compiles of modules you might have renamed along the way, etc. To do this, click Start, then Run... and specify

"C:\Program Files\...path to your MS Office...\MSACCESS.EXE" /decompile

If that doesn't work, create a new database and import everything from the corrupt database.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org