How do I disable popup messages when appending tables or updating etc...?

[Daveo123]

I keep getting pop messages when I try to append a table or delete or update a table. I'm sure its really easy but the microsoft help manual wasn't any help

[KnooKie]

have a look in the help file at SetWarnings

e.g.


DoCmd.SetWarnings False 'turn off Access warning messages

DoCmd.SetWarnings True 'turn them on again


make sure everything is working nicely before disabling the warning messages!!

[Daveo123]

Thanks for the help again. Unfortunately I still get prompted everytime I am make a change to a table using a query where it say "append 1 Row" or "Update 1 Row" etc... I would like the warning to stay on if there is something wrong but I dont need telling everytime I am running a query that its about to make a change.

Any ideas?

Regards

[KnooKie]

can you post your code.

You can turn the warnings on if an error occurs perhaps.