Suppress System Message

[McCloud77]

Hi Folks,

I invoke this sub from a form to append a record into a table. This table is the data source of a subform on my form. I prepare the data in the form and then pass it to the subform through updating its source then refresh the whole thing.

Private Sub btnAddToInvoice_Click()
DoCmd.RunSQL "INSERT INTO tblSalesDetails (SInvoiceID, ItemNumber, Qty, Warranty) " & _
"VALUES (SInvoiceID, tbxBrand, tbxQty, chkWarranty);"
Me.Refresh
End Sub

The problem is that each time I want to append a record a system message pops up to confirm the action. How can I suppress this message or at least customize it.

Thanks

 

[tlbroadbent]

docmd.setwarnings (false) Terry

http://members.home.net/tlbroadbent/prog.htm

------------------------------------
Experience is the hardest kind of teacher. It gives you the test first, and the lesson afterward.

 

[balor]

Turn warnings of.

Example:


Private Sub btnAddToInvoice_Click()

DoCmd.SetWarnings False

DoCmd.RunSQL "INSERT INTO tblSalesDetails (SInvoiceID, ItemNumber, Qty, Warranty) " & _
"VALUES (SInvoiceID, tbxBrand, tbxQty, chkWarranty);"

DoCmd.SetWarnings True

Me.Refresh
End Sub

 

[JoeMiller]

Make sure that you put that when you turn the messages off like Terry and Balor suggested that you turn them back on as in Balor's code. SetWarnings is a global command and turns it off throughout all of Access!

[tt]
DoCmd.SetWarnings False

Run My Code here...

DoCmd.SetWarnings True
[/tt]

Joe Miller
joe.miller@flotech.net

 

[McCloud77]

Thank you all. It worked very good. I did it as balor suggested; Off then On again. Do you think another type of warning (beside the confirmation message) may be suppressed? i.e. is it a safe practice to do the thing this way.

Thanks again,