View Full Version : Updatable & Append Query with Dialog Boxes


rahmedarain2005
04-15-2009, 12:30 PM
I have a problem; I made many updatable and append Queries, when I call any query from any Form then three dialog boxes comes for the purpose of confirmation; these are:

* Are you about to run an append query that will modify data in your table. (Y/N)
* You are about to append 63 row(s). (Y/N)
* Microsoft Access can't append all the records in the append query. (Y/N)

How to close these dialog boxes?

If any person could provide solution then I will be most appreciated to him/her.

Regards,
Raheel

KenHigg
04-15-2009, 12:41 PM
You can turn the warnings off with:

DoCmd.SetWarnings False

Then make sure to turn yhe back on with:

DoCmd.SetWarnings True

rahmedarain2005
04-15-2009, 11:22 PM
OH Yes! It's ok now; KenHigg many thanks, you solved my problem. :cool:

KenHigg
04-16-2009, 02:37 AM
Glad to help - :)