VBA Code vanished

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was programming changes behind a form in VBA, saved code and went to test.
Code for the whole module had disappered. In Access 2003
 
Terry Beckman12 said:
I was programming changes behind a form in VBA, saved code and went to test.
Code for the whole module had disappered. In Access 2003
Click to expand...

Terry Beckman12,

If you coded everything today, ouch!

Otherwise, pull the copy from the last backup, and start working from
there.


Sincerely,

Chris O.
 
Terry,

I experienced a similar problem a few weeks ago which may or may not be the
same as yours.

In my case, I had a backup copy of my .adp on CD. Each time I copied the
file to my machine and attempted to display the code in VBA, I found that
only the declarations section would display for each module. Not one of the
procedures would display.

After further investigation, I found the source of the problem. My user
profile on that particular machine had been corrupted. My corrupted profile
somehow prevented the code from displaying in VBA. I copied the same file
to another existing (and non-corrupt) profile on the *same* machine and was
able to display and update my code.

The final solution was to create a new user profile.
 
Back
Top