R
rdufour
My code has been working for several years now. All of a sudden, after
reinstalling Office 2003 on my computer (cause of a disk problem, had to
reinstall windows 2000 server sp4 and Office 2003) whenever my application
executes code for instance in snippet below. I get error message Can not
find vb6a.dll and the app goes into debug mode. How can I correct this
problem. This occurs whether I am accessing the mdb directly on the
reinstalled server or if I open the mdb from another computer with an Access
2003 that has been installed on the othermachine years ago.
Any help would be greatly appreciated.
Bob
This is a typical snippet of code that exhibits the problem. As you can see,
nothing special.
Private Sub Timesheet_Click()
On Error GoTo Err_Timesheet_Click
Dim DocName As String
DocName = "Timesheet"
DoCmd.OpenReport DocName, A_PREVIEW
Exit_Timesheet_Click:
Exit Sub
Err_Timesheet_Click:
MsgBox Error$
Resume Exit_Timesheet_Click
End Sub
reinstalling Office 2003 on my computer (cause of a disk problem, had to
reinstall windows 2000 server sp4 and Office 2003) whenever my application
executes code for instance in snippet below. I get error message Can not
find vb6a.dll and the app goes into debug mode. How can I correct this
problem. This occurs whether I am accessing the mdb directly on the
reinstalled server or if I open the mdb from another computer with an Access
2003 that has been installed on the othermachine years ago.
Any help would be greatly appreciated.
Bob
This is a typical snippet of code that exhibits the problem. As you can see,
nothing special.
Private Sub Timesheet_Click()
On Error GoTo Err_Timesheet_Click
Dim DocName As String
DocName = "Timesheet"
DoCmd.OpenReport DocName, A_PREVIEW
Exit_Timesheet_Click:
Exit Sub
Err_Timesheet_Click:
MsgBox Error$
Resume Exit_Timesheet_Click
End Sub