schedule task macro failes to complete due to persistent prompting

  • Thread starter Thread starter Susan
  • Start date Start date
S

Susan

To avoid being prompted when a macro runs a make table query, I have cleared
all check boxes under the "options" menu to "confirm" for record changes,
document deletions and action queries. I have clicked the "apply button" and
have restarted my computer to ensure that the problem is not momentary.

However, I am still being prompted.

Why is that and how is this corrected? If I will require hand VBA coding,
kindly bear in mind that I have never hand coded VBA so please be very
specific as to what should be done (how to view the screen for vba coding and
what code to insert)

thanks!!
 
Hi Susan,

I would leave those confirm options on. In your macro use the
SetWarnings action to turn the warning off before the make record query then
again to turn them back on afterwards.

Clifford Bass
 
Susan,

I agree with Clifford... use a SertWarnings/No action in your macro before
the OpenQuery action.

And set the global settings back to the default settings.

However, it is still puzzling why you got the confirmation message. If it
still happens after using the SetWarnings action, please let us know what
the wording of the message is.
 
Back
Top