VBA for Print and delete command

N

Nick

I want to delete data with the criteria of using "Year" and "Quarter"
[OTDLTable] but before that happens. I would like a message box to appear
asking "Do you want to print data before deletion. with a "Yes" or "No"
buttons. If "Yes" display
the criteria for query QTquery, open and print "QuarterReport" then delete
said
data. If "No" display message "Data will be deleted" .
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word 2007 flash screen upside down and Word2007 cannot be used 0
Not familuar with code 0
Do I use Macro or Code 2
Getting Radio Buttons to work, that are inserted via AutoText 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Run query in another database 5
No Records Deleted Message 2
"Specify the table containg the records you want to delete" messag 3

Top