Surpress Confirmation Messages while updating records with VBA

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

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.

--
Brendan Reynolds

"Rasmus" wrote in message
...
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

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:
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

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
--
I hope that helped
Good Luck


"Rasmus" wrote:

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