Bypassing confirmation of 'can't be undone'

  • Thread starter Thread starter Francis Bernardi
  • Start date Start date
F

Francis Bernardi

I've been an actuary for about 18 years, and in my work I
frequently work use Access for database number crunching.
I don't do any GUI stuff or forms or reports.
Anyway, often I need to piggyback several queries in
sequence and can do this automatically with a macro.
Sometimes, though, the macro will need my interaction,
particularly to okay that what the query is doing can't be
undone (at times the databases have a million or so
records).

Is there a way to call the macro, or the queries, from an
access module and have a setting in the module so I
wouldn't get prompted? I have unchecked the confirm
statuses on the edit/find tab in Options (i.e.,
for "record changes", "document deletions", and "action
queries"), but this isn't sufficient to have the macro run
without my interaction.

Can you help me? Thank you.
 
You could try making your first Macro Action SetWarnings with the Warnings
On Property set to 'No'. After each of the actions to run your queries,
make your last Macro Action SetWarnings with the Warnings On Property set to
'Yes'.
 
Back
Top