Steve Erbach
erbachs at gmail.com
Fri Feb 4 10:18:17 CST 2005
Dear Group, I've been working on a complicated module over the past three days in Access 2000. I was working in the VBA IDE and I had two module windows open as well as the Project Explorer. There was a bit of code that I wanted to delete in one of the modules, so I highlighted it with my mouse and pressed the Delete key. Instead of the bit of code being deleted, the other module that was open in the IDE was deleted! It no longer appears in the list of modules in the Access Database window. I checked the Options and, sure enough, I had un-checked the option for warning of Document deletions...but Jeez! How can a document be deleted if it isn't active?!?! This, of course, blows maybe a day-and-a-half of work out the window. I have a backup from Wednesday night. I have not yet closed Access. I am contemplating turning off my computer without closing Access in the hopes that the module will re-appear. Is this an option or am I facing re-doing the work? Egad! I have NEVER done this before. Is there something goofy about the Access 2000 Project Explorer that I don't know about? When I selected the code to delete with the mouse and then released the mouse to press the Delete key, did I then somehow push the mouse over to the Project Explorer and phantom-click on the other active module before I hit the Delete key? This is creeping me out, besides the fact that this is all under deadline. Should I try turning off my system? Regards, Steve Erbach Scientific Marketing Neenah, WI www.swerbach.com Security Page: www.swerbach.com/security