Prevent CANCEL option in query variable msgbox???

R

Rebecca

I have a query that prompts for 2 variables. The msgbox
that does this allows CANCEL to be hit.
The query results are sent to an Excel spreadsheet via a
macro containing the 'TransferSpreadsheet' command.
If a user hits CANCEL, my spreadsheet gets blanked out.

Is there any way to prevent the msgbox having the CANCEL
option (remember I dont display this myself, the query
does it automatically). Or if this is not posssible, how
do I prevent the 'TransferSpreadsheet' command in my macro
from writing out a blank spreadsheet?
 

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

Form Passing parameters to query 0
Deleting & Re-querying From A Union Query 11
NO Transferspreadsheet option in 2007? 1
Cant get Parameter Query to work even witht the help of Martin Gre 0
Problems enabling a drop down on a query 1
Use of Cancel In Unload Event 2
Prevent users from saving if cells are blank 13
Update query with if else condition (need to refer to cell indexes 2

Top