lwarren1968
Registered User.
- Local time
- Today, 06:46
- Joined
- Jan 18, 2013
- Messages
- 77
I'm not sure what I'm missing here? I have a macro that should run 3 queries upon opening the database and all warning have gone away accept the Violation error. How can I get this warning to stop as well?
Option Compare Database
'------------------------------------------------------------
' AutoExec
'
'------------------------------------------------------------
Function AutoExec()
On Error GoTo AutoExec_Err
DoCmd.OpenQuery "MASTER VENDOR LIST_QRY", acViewNormal, acReadOnly
DoCmd.OpenQuery "MASTER INVOICE LIST_QRY", acViewNormal, acReadOnly
DoCmd.OpenQuery "INVOICE RECONCILATION_QRY", acViewNormal, acReadOnly
AutoExec_Exit:
Exit Function
AutoExec_Err:
MsgBox Error$
Resume AutoExec_Exit
End Function
Option Compare Database
'------------------------------------------------------------
' AutoExec
'
'------------------------------------------------------------
Function AutoExec()
On Error GoTo AutoExec_Err
DoCmd.OpenQuery "MASTER VENDOR LIST_QRY", acViewNormal, acReadOnly
DoCmd.OpenQuery "MASTER INVOICE LIST_QRY", acViewNormal, acReadOnly
DoCmd.OpenQuery "INVOICE RECONCILATION_QRY", acViewNormal, acReadOnly
AutoExec_Exit:
Exit Function
AutoExec_Err:
MsgBox Error$
Resume AutoExec_Exit
End Function