T
teddysnips
I have a new client who has an Access 2000 database that used to run
under Windows 2000 Pro. They have just "upgraded" to Access 2007
under Vista, and the old database stopped working - buttons on forms
did nothing.
When I first looked at it the problem seemed to be the change to the
signature of Docmd.Requery (fewer arguments) so I made the necessary
changes and the database compiled. I compiled and tested it on my
work system (also Vista, A2k7) and it worked fine.
When I copied the db onto the client's machine, it didn't work. I
checked that it compiled correctly (it did) but when I hit the
buttons, nothing happened. I put a breakpoint in the code and it
never hit. An example of the code (by the way, I didn't write the
code, and I don't know who did - I was just called in to help):
Private Sub Command171_Click()
On Error GoTo Err_Command171_Click
Dim strReportName As String
Dim strFilter As String
Me.Refresh
strReportName = "rptEstimate"
strFilter = "EstimateID = Forms!frmestimate!EstimateID"
DoCmd.OpenReport strReportName, acViewPreview, , strFilter
Exit_Command171_Click:
Exit Sub
Err_Command171_Click:
MsgBox Err.Description
Resume Exit_Command171_Click
End Sub
A breakpoint on any of the lines is just not hit. In other words, it
looks like the code isn't running. I've tried creating a brand new
2007 database and importing all the objects - exactly the same
result. The code compiles, but doesn't run.
Any thoughts?
Thanks
Edward
under Windows 2000 Pro. They have just "upgraded" to Access 2007
under Vista, and the old database stopped working - buttons on forms
did nothing.
When I first looked at it the problem seemed to be the change to the
signature of Docmd.Requery (fewer arguments) so I made the necessary
changes and the database compiled. I compiled and tested it on my
work system (also Vista, A2k7) and it worked fine.
When I copied the db onto the client's machine, it didn't work. I
checked that it compiled correctly (it did) but when I hit the
buttons, nothing happened. I put a breakpoint in the code and it
never hit. An example of the code (by the way, I didn't write the
code, and I don't know who did - I was just called in to help):
Private Sub Command171_Click()
On Error GoTo Err_Command171_Click
Dim strReportName As String
Dim strFilter As String
Me.Refresh
strReportName = "rptEstimate"
strFilter = "EstimateID = Forms!frmestimate!EstimateID"
DoCmd.OpenReport strReportName, acViewPreview, , strFilter
Exit_Command171_Click:
Exit Sub
Err_Command171_Click:
MsgBox Err.Description
Resume Exit_Command171_Click
End Sub
A breakpoint on any of the lines is just not hit. In other words, it
looks like the code isn't running. I've tried creating a brand new
2007 database and importing all the objects - exactly the same
result. The code compiles, but doesn't run.
Any thoughts?
Thanks
Edward