How to avoid confirmation messages?

[Svein Petter]

I am having a look at MS Access 2000 at the moment, meaning I am a newbie in
many aspects. Apart from the speed and lack of DB trigger options the jet
database engine keeps suprising me when it comes to functionality and
scripting language performance. Mostly when I ask a question in newsgroups
it is because I have overlooked something obvious.

Can anyone tell me how to avoid confirmation messages when running DML
scripts?

I have a sequence of scripts I want running, I keep getting confirmation
requests when I delete or update records via SQL. If I am running a sequence
of scripts, maybe separately deleting 10.000 records, i need those message
requests gone.

Example:

DELETE from Customer where CustomerID = 2

Works fine and I get a confirmation request. However, if I need to do many
calls like this sequence, or do calls like that which are meant to run in
the background in an automatic process then the requests cannot be there.
How do I avoid them?

I also need a link to a "working with jet database engine procedures" if
possible.

Any good ideas?

Thank you in advance!!!!
Best regards,
Svein

 

[Svein Petter]

I knew it, should've parsed the DoCmd calls before asking... easier when you
know where to start looking though

Thank you, Phobos!!!

 

[Phobos]

To stop the messages from displaying:

DoCmd.SetWarnings False

To turn them back on again use "True".

P