Confirming changes

[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

 

[chas]

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

 

[Allen Browne]

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

Use False for the other database.