Access 2003 Evnet Not Workig With Access 2007

[crhodus]

One of our clients bought new computers with Vista and Access 2007 on it. Their application is not wanting to run a certain piece of code. I can't test with this setup. (Windows activation for Vista is screwed up on the test box we setup.)

When the button is clicked, nothing happens. Has anyone experienced something like this?

Here is the code that is failing:

Private Sub cmdPrintLedgerSheet_Click()
On Error GoTo Err_cmdPrintLedgerSheet_Click

Dim stDocName As String

stDocName = "NewLedger2Cert"
DoCmd.OpenReport stDocName, acViewPreview, "test", "lgrLedger.LedgerSheetID = " & Me.LedgerSheetID
Exit_cmdPrintLedgerSheet_Click:
Exit Sub

Err_cmdPrintLedgerSheet_Click:
MsgBox Err.Description
Resume Exit_cmdPrintLedgerSheet_Click

End Sub


Thanks,
Crhodus

 

[boblarson]

When opening Access 2007 in Vista, each time you open the database you will need to enable code to be able to be run (unless you create a "trusted location" and then add that location into Access).