Are you sure you want to delete 7 records?

[Eric D. Braden]

I'm working with a database created by someone else who appears to
have had about the same knowledge level that I do (limited, brute
force). One of the functions it serves is to create a series of
reports by pulling records from another database. She went about this
in what appears to be a rather complicated way, creating and deleting
a series of new records.

I'm hesitant to try and rewrite everything she's done, because it is
rather complicated, but I'd love to be able to suppress the Delete?
dialog. I produce the reports 3 times a week and have to 'enter'
through about 30 delete dialogs each time. Not world ending, but
extremely annoying.

So, can anyone tell me how to autoconfirm deletions?

 

[Stefan Hoffmann]

hi Eric,

So, can anyone tell me how to autoconfirm deletions?

Take a look at

DoCmd.SetWarnings False
DiCmd.Echo False



mfG
--> stefan <--

 

[Allen Browne]

See:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html

 

[Eric D. Braden]

See:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.







- Show quoted text -

Thanks!