Access 2010 and setwarnings

jmh547 · Nov 14, 2011

I have a access file that i am working on converting from '97 to 2007 using access 2010. Everything is working but the setwarnings action in the macros. I have it set to "No" but it still gives me the warnings. I have "enable all macros" selected and have the folder containing the file setup as a "trusted folder." Any ideas?

jmh547 · Nov 15, 2011

I pulled everything out of the macro and wrote an "event procedure" and no dice. I still get every warning message for each query. Please help

Code:

Private Sub Command5_Click()
    DoCmd.SetWarnings False
    DoCmd.OpenQuery "qryAddPSWrkCtrtoWrkCntrLst"
    fntUpdatedispatchlist
    DoCmd.OpenQuery "qryUpdate tblDispatchListOutput With Supplier"
    DoCmd.OpenQuery "qryRemove Zero Qty Remaining From tblDispatchListOutput"
    DoCmd.OpenQuery "qryNextOperation"
    DoCmd.OpenQuery "qryNextOperationAddWorkcenter"
    DoCmd.OpenQuery "qryApndDisplatchListOutputWithISR"
    DoCmd.OpenQuery "qryAddRevLetterToDispatchListOutput"
    DoCmd.OpenQuery "qryGetPrimaryLocation"
    DoCmd.OpenQuery "qryUpdatePartDescription"
    DoCmd.OpenReport "rptDispatchListOutput", acViewReport
    DoCmd.SetWarnings True
End Sub

jmh547 · Nov 15, 2011

Never mind i got it. At the end of "fntUpdatedispatchlist" it has "DoCmd.SetWarnings True" so I was getting only the warnings after the function was called.

Access 2010 and setwarnings

jmh547

Member

jmh547

Member

jmh547

Member

Similar threads