I am looking to find out if there is a vbyes/no response to the SetOptions "Confirm Action Query" ?
I have a form that users can run their own sql queries from and it sends the results to excel. I often run delete statements from this form and would like my message label on the form to show that I've confirmed or cancelled the
I just don't if or how you can incorporate a vbyes/no into this. Any ideas?
I really don't want to go to another type of delete confirmation, since it confirms how many records I am going to delete.
If vbyes then message_lbl.caption = "Delete Complete."
I did search the forum, but didn't find anything close to what I'm trying to do.