John Bartow
john at winhaven.net
Fri Feb 4 10:31:59 CST 2005
Hi Steve, Since this is urgent I'm typing while thinking (which is dangerous) IIRC when deleting an object it is marked for deletion but not deleted. I forget the way it is done exactly but I think it is by putting a "~" character in front of the name. Once compacted the object go away. John B. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Erbach Sent: Friday, February 04, 2005 10:18 AM To: Access Developers discussion and problem solving Subject: [AccessD] A2K: Oh, BROTHER! Have I screwed up or not? 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com