OOPS! How to restore a module after removing it?

[THDWWSIJQUOK@spammotel.com]

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

[Ken Ismert]

Re: OOPS! How to restore a module after removing it?

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


THDWWSIJQUOK@sp ammotel.com wrote:[color=blue]
> 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[/color]
and[color=blue]
> instead wound up removing the darn thing.
>
> It's been a long time since I've lost any work because I normally[/color]
make[color=blue]
> backups and have the experience not to make stupid mistakes like[/color]
this.[color=blue]
>
> I'm still shocked how quickly it happened...[/color]