suppressing dialog boxes - on append SQL

[battenberg]

I have just created an append SQL string that adds a new record,

sql = "INSERT INTO tblAncilleries ( ProductID, PartNumber, ProductDescription ) VALUES ( " & strProductID & "," & strPartNumber & ", " & strDescription & " );"

DoCmd.RunSQL sql

How do I suppres the dialog box - see jpg?

Thanks

 

[KenHigg]

I think it's something like:

docmd.setwarnings = false

 

[battenberg]

thankyou for the hint:

syntax is : DoCmd.SetWarnings (off)

thanks again...

 

[boblarson]

DoCmd.SetWarnings(False)

...put your other code here

DoCmd.SetWarnings(True)

I would also put the DoCmd.SetWarnings(True) as the very first thing in your error handler for the event, as if you don't you may find yourself without any warnings at all if something fails and it never gets to the DoCmd.SetWarnings(True) in the main code. And, that is bad.

 

[KenHigg]

DoCmd.SetWarnings(False)

...put your other code here

DoCmd.SetWarnings(True)

I would also put the DoCmd.SetWarnings(True) as the very first thing in your error handler for the event, as if you don't you may find yourself without any warnings at all if something fails and it never gets to the DoCmd.SetWarnings(True) in the main code. And, that is bad.

For sure - Turn 'em back on -

 

[battenberg]

thanks Bob... will do!