Surpress Confirmation Messages while updating records with VBA

[Rasmus]

Hi everybody,

I am updating records with a VBA skript. While the script is running access
keeps bothering me with confirmation messages. Is it possible to surpress
these messages?

Any help would be aprechiated.
thx
Rasmus

 

[Brendan Reynolds]

If you are using DoCmd methods to execute queries or SQL statements, try
using CurrentDb.Execute or CurrentProject.Connection.Execute instead. See
the help file for details.

 

[Nick Coe \(UK\)]

Look up DoCmd.SetWarnings in Access help.

Generally you turn warnings off just before your code
actually starts doing stuff to records then turn them back
on again at the end.


--
Nick Coe (UK)
Available - Will work for money
http://www.alphacos.co.uk/ AccHelp + pAnimal
http://www.pjandcoe.co.uk/ Online Store

In Rasmus typed:

 

[Guest]

If you want to remove the messages for all action queries, without using the
set
warnings, then in the menu bar select
Tools > Options > Edit/Search (Tab) > Confirm Action Queries (remove the
selection)

But you have to know that it will never prompt with the message event when
you are using the queries dirrectly