Disable Access error messages ??

[Fie]

Hi,

With a database open fo to Tools ... Options, then then Edit/Find tab.
Look
for the checkboxes to Confirm Document Deletions, Action Queries, Record
Changes, and make sure they are checked. Close and re-open Access.
--

I don't what them turned off all the time however, just when executing
certain parts of coding ...

Fie

 

[Arni Laugdal]

Fie,

Before the action can you add following to you code
DoCdm.SetWarnings False
Then you turn Warnings on again later in the code
DoCdm.SetWarnings True

Enjoy,
Arni Laugdal
www.til.is/msaccess