how turn off confirmation messaged for document deletions?

  • Thread starter Thread starter Ian Elliott
  • Start date Start date
I

Ian Elliott

Thanks for all previous and future help.btw I got Access
2002
I have a macro for a button on a form, and it deletes and
copies a few tables. Enough so that clicking OK for
confirmation 3-4 times every time I run it is bothersome,
for me, and probably the user also. I typed in:
With Assistant
.AssistWithAlerts = False
End With

But all that does is just cause the confirmation message
to be by a plain box, not the cutesy-wutesy paperclip or
whatever.

I clicked on Help when it popped up next, and it says go to
Tools>options>edit/find tab and click off document
deletions.
I went to tools>options> but I can't find edit/find.
I am assuming this is faulty documentation.
Does anyone know how I can turn off the confirmation (then
back on, in VBA) so I won't be bothered when I run:
DoCmd.DeleteObject,DoCmd.CopyObject,DoCmd.OpenQuery
(delete and append)?
Thanks again.
PS-In Access, it's not possible to record macros like
Excel, is it?
 
Although this is an Excel group...

I do not use the office-assistant and I don't use Access 2002, that said you
might want to try the following line of code instead of the Assistant code
you have:

DoCmd.SetWarnings False

If you want to turn them back on again, use:

DoCmd.SetWarnings True

Post back to let us know if it works please.

And: No, you cannot record macros in Access like you can in Excel.

P
 
Back
Top