I've got a bit of problem, I have never used Access and our company doesn't use it, or so I thought. Part of the company does use it and a database that has been working for years all of a sudden doesn't.

I have the following code:

Option Compare Database
Option Explicit

Private Sub New_Record_Click()
On Error GoTo Err_New_Record_Click


DoCmd.GoToRecord , , acNewRec

Exit_New_Record_Click:
Exit Sub

Err_New_Record_Click:
MsgBox Err.Description
Resume Exit_New_Record_Click

End Sub

Now I assume this should run an event when the new record button is clicked, but it doesn't on the line Private Sub New_Record_Click() it goes yellow and says module not found.

Whats going on???

 

What version of Access?

From a code window, click Tools > References.

Anything marked as "MISSING" in the list?

 

2000.

nothing jumps out at me.

 

Try compacting and repairing the database under Tools > Database Utilities.

Martin.

 

nope no effect.

the fact there are no modules worries me slightly. Also, I tried creating a new macro of just one line, it still comes up with Module not found.

 

If you have a backup of the database, restore it.

Martin.

 

cheers for the help guys, I found an old version which worked, I just imported the up to date tables.

I still can't see anything wrong with the original though. Microsoft for you.

And now the compact and repair doesn't work - more like crash and reboot!

 

OH ****.

I've just deleted a table that I really didn't want to delete.

Please tell me I can recover it? And no this one wasn't backed up.