Hello,
I recently developed an Access application for a client. I tested everything on my pc, and it all worked fine... now the client is using the application on their machine, which has Access 2003 installed. When you try to close a report, Access pops up a dialog box asking whether you want to save changes to the report... it doesn't seem to matter whether you say yes or no - the same thing happens the next time you close out of the report. I even tried adding a

command to the OnClose event. The prompt still comes up. Does anyone know of a way to eliminate/suppress these messages?

Thanks

What is probably happening is that the user's PC is reformatting the report for their default printer when they open it, which "changes" the report, and Access is asking if they want to save those changes. This should only happen the first time they open and close the report. You might try this on the On Close event of the reports:

DoCmd.SetWarnings False

This will suppress the save dialog, but it will also suppress all other similar warnings.

Did that help?




mmcdonal

Look it up at: http://wrox.books24x7.com

That makes sense... i'll try it out. it'll be a while before i can test it to find out whether that resolves the issue or not, though. Thanks very much for the insight.

How about if you put the

DoCmd.SetWarnings False

on the ON OPEN event of the report and put the

DoCmd.SetWarnings True

on the ON CLOSE event instead? Perhaps the save report trigger will happen BEFORE the DoCmd and your warning settings will be reset to normal when you're shot back to the form.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division