Disable Access error messages ??

  • Thread starter Thread starter Fie
  • Start date Start date
F

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.
--
Click to expand...

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

Fie
 
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
 
Back
Top