Macro - closing a form

  • Thread starter Thread starter murfitUK
  • Start date Start date
M

murfitUK

I've created a macro that opens a form, copies some records and then closes
the form.

When the form closes I get the message "You have copied a large amount of
information...do you want to save this info?"

I would like the macro to answer this "Yes" as I need to paste this
information into a Word doc.

Can anyone let me know how the macro can answer "Yes" to this message box?

Thanks.
 
Short answer -- no, the macro cannot answer a message box.
 
You must log in or register to reply here.

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

Access Automatically Send a notification email once a record is added 0
Need help on VBA excel macro and API to close an external application 0
A2007 Macro issue 1
Access 2003 Access Error Form Name 0
Word Macros in a Protected Word Document 0
how do you close a data entry form without saving record 2
Best way to enter addresses, body of letter, closing, etc. Macros? 2
Pasting cell contents into a macro 1

Back
Top