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?
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?