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 FCUK.
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. |
All times are GMT +1. The time now is 08:18 AM. |
© 2024 MH Sub I, LLC dba Internet Brands