Microsoft ACCESS
#1
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???
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???
#7
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!
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!
Trending Topics
Thread
Thread Starter
Forum
Replies
Last Post