Confirming changes

  • Thread starter Thread starter Emmy
  • Start date Start date
E

Emmy

If you go under Tools-Options-Edit/Find and remove all 3
checks under Confirm, it won't show messages when you run
a query or macro. Is there a way to always turn the
messages off for one database? When another database is
opened, I want the messages back on without having to
remember to check the 3 boxes.

Thanks!!
Emmy
 
Hi Emmy,

I think you'll find that these particular options
are 'Access wide' so turning them on/off will affect all
databases opened in Access.

An alternative would be to create an autoexec macro and
use the SetWarnings macro action set to 'No' for the
particular database that does not require the warnings.

hth

chas
 
In the Open event of your startup form:
Application.SetOption ("Confirm Record Changes"), True

Use False for the other database.
 
Back
Top