By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,779 Members | 1,309 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,779 IT Pros & Developers. It's quick & easy.

OOPS! How to restore a module after removing it?

P: n/a
I have (or should I say "had") a module which I invested quite a few
hours of work into. I was poking around trying to rename the module and
instead wound up removing the darn thing.

It's been a long time since I've lost any work because I normally make
backups and have the experience not to make stupid mistakes like this.

I'm still shocked how quickly it happened...

I noticed the module was called "module1" so I went to give it a
meaningful name. I tried single clicking the module name in the project
explorer trying to rename it. When that didn't work, I clicked the file
menu and thought I saw "rename module1". So I clicked that, but the
moment I clicked it and saw a dialog box, I knew something had gone
wrong. Seeing what appeared to be the "are you sure you want to delete
this?" prompt, I hastily clicked NO!

Without going to Visual Basic to see what I'm talking about, I will
explain:

"Rename Module1..." was actually "Remove Module1..."

"Are you sure?" was actually "Do you want to export Module1 before
removing it?"

Ok. Go ahead and roll your eyes now. Nobody else would do anything that
stupid, I know!

So I was wondering, does anyone know a way to restore the contents of a
module before the database has been compiled or compacted?

In case anyone was wondering: The properties box that normally appears
below the project explorer on the left side of the VB editor lets you
rename the module. My. How convenient!!

New Years Resolution #1: Make frequent backups, you idiot
New Years Resolution #2: Make an appointment for an eye exam
New Years Resolution #3: Cut out the caffeine

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
THDWWSIJQUOK:

Doh! Unfortunately, I have heard of no method for retrieving a deleted
module.

Two more tips:

1. Right click on the module in the Project Explorer and select Export
to export your module as a text file. I have found this to be the
safest form of backup.

2. Office Developer includes the Multi-code Import and Export add-ins
which automate importing and exporting multiple modules at a time. One
of the better features of the developer edition.

-Ken
TH**********@spammotel.com wrote:
I have (or should I say "had") a module which I invested quite a few
hours of work into. I was poking around trying to rename the module and instead wound up removing the darn thing.

It's been a long time since I've lost any work because I normally make backups and have the experience not to make stupid mistakes like this.
I'm still shocked how quickly it happened...


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.