Anyway to eliminate error system messages? 1

[nakedbamboo]

I have a button that outputs a query to a saved file by asking the user where they would like to save it. The code is:

DoCmd.OutputTo acOutputQuery, "Search", acFormatXLS, FileName

If the user clicks cancel to saving it, a message comes back saying "Output was canceled." Is there any way to turn these types of messages off?

 

[luceze]

First, take the brackets off of your do while statement.

Your Do...While procedure will not perform if VarYN does not equal 7. Add this line right after the dim check line:
VarYN=7

I tested it on my machine and it worked as expected.

Let me know if you need more assistance.

Eric

 

[janetlyn]

Eric, you are an angel. That worked perfectly once I also took out the Exit. I put the brackets in because they were like that on an example and I was desparate to try everything. Thank you again for all your help. Pink star to ya. Janet Lyn

 

[luceze]

Your very welcome.