Some of the reports in my application (Access 97) are on legal size paper. As a work around for the problem of Access reverting back to its default page setup, I have the page setup icon on the report menu bar so users can change the paper to legal before sending the report to the printer. By the way, SR1 and SR2 fixes work for Access 2000, but not 97. All of our machines have SR-2 and they still reverting back to default page setup. When users change the paper size, print and close the report, the change they made (from letter to legal) gets saved with the report (to revert back later on!)
The problem is that when 2 or more people are running the same report, when one tries to close report, he/she gets an error message that the report cannot be save, because it is open by another user. Then the “object not valid” message comes up and then everything locks up.
Is there a way to close a report without saving it. I tried the “DoCmd.Close , "reportname”, acSaveNo in the OnClose event, but it did not work. I cannot place a command button on the report to close it. Any ideas?
Thanks.
shar
The problem is that when 2 or more people are running the same report, when one tries to close report, he/she gets an error message that the report cannot be save, because it is open by another user. Then the “object not valid” message comes up and then everything locks up.
Is there a way to close a report without saving it. I tried the “DoCmd.Close , "reportname”, acSaveNo in the OnClose event, but it did not work. I cannot place a command button on the report to close it. Any ideas?
Thanks.
shar
