In the code below I perform a save to a file name as well as appending one table to another table for history reasons. I don't want the end user to be confronted with pop up questions about are you sure you want to run this query and son on.
How can I turn off those types of questions in VBA like you can in a macro with the SetWarnings command?


Private Sub cmdSaveConsumable_Click()
DoCmd.TransferText acExportDelim, , "qryExportConsumables", "T:\Consumables.prn", True
 Dim stDocName As String
    stDocName = "qryAppend to Consumable History"
    DoCmd.OpenQuery stDocName, acNormal, acEdit
lblSavemsg.Visible = True
End Sub

I did some searching in some of the past posts and found the answer on 3/4/04

DoCmd.SetWarnings False

True, Brian, but remember to set it to TRUE right after your code block to make sure you turn warnings back on. You want to be alerted of problems in other parts of your database if they arise.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division