Using Access 2003, in default 2000 file mode.
I built a database for a friend's Kiwanis club, the main user of which will be my friend, Larry.
Larry has run into a very strange problem. There is a form in which he can select names and print #10 envelopes, but the envelope report persists in showing up in Letter mode. There are some reports that persist in showing up in #10 envelope mode rather than Letter mode.
What makes this weird is that I have a code module which sets those reports to the proper printer setting upon startup of the database. So I never run into a problem.
What makes it doubly weird is that he put the program on his 3 year old laptop and even when hooked up to the same printer it runs without any problem whatsoever.
The error that he gets when he attempts to change the Page Setup in a report is "out of memory." But his computer is only a year old and he has 2 meg of RAM.
This is Larry's e-mail message to me. It's a Canon printer, 2 years old. "Everything goes well until I attempt to save the printer settings. An error box flashes up and then disappears again, covered by another saying "There is not enough memory. Close unneeded programs". Bunk I say. Nothing but the database is running, and Task manager says I'm using about 650 mb of 2 Gigs of RAM. I have rebooted and tried again, with the same result. Microsoft's error reporting routine tells me I should upgrade from Access 2000.
I have had him reinstall the printer driver, defrag, uninstall, use Windows Install Clean-up to make sure things are gone, also then put a small file on so there is no imprinting on the same sectors when he reinstalls Office. But none of this has made any difference.
Here's another message from Larry: I copied the front and back ends to the laptop, expecting to have to reconfigure the printer settings. Not so. All the reports were properly formatted. When I copied the files back to the desktop and ran it, the reports all came up with an envelope setting so I checked the default printer setting. Sure enough, it was overriding the database settings. I have reset the printer to letter several times now after running the database, and still can't figure out why it is changing.
Any ideas?
Tom
I built a database for a friend's Kiwanis club, the main user of which will be my friend, Larry.
Larry has run into a very strange problem. There is a form in which he can select names and print #10 envelopes, but the envelope report persists in showing up in Letter mode. There are some reports that persist in showing up in #10 envelope mode rather than Letter mode.
What makes this weird is that I have a code module which sets those reports to the proper printer setting upon startup of the database. So I never run into a problem.
What makes it doubly weird is that he put the program on his 3 year old laptop and even when hooked up to the same printer it runs without any problem whatsoever.
The error that he gets when he attempts to change the Page Setup in a report is "out of memory." But his computer is only a year old and he has 2 meg of RAM.
This is Larry's e-mail message to me. It's a Canon printer, 2 years old. "Everything goes well until I attempt to save the printer settings. An error box flashes up and then disappears again, covered by another saying "There is not enough memory. Close unneeded programs". Bunk I say. Nothing but the database is running, and Task manager says I'm using about 650 mb of 2 Gigs of RAM. I have rebooted and tried again, with the same result. Microsoft's error reporting routine tells me I should upgrade from Access 2000.
I have had him reinstall the printer driver, defrag, uninstall, use Windows Install Clean-up to make sure things are gone, also then put a small file on so there is no imprinting on the same sectors when he reinstalls Office. But none of this has made any difference.
Here's another message from Larry: I copied the front and back ends to the laptop, expecting to have to reconfigure the printer settings. Not so. All the reports were properly formatted. When I copied the files back to the desktop and ran it, the reports all came up with an envelope setting so I checked the default printer setting. Sure enough, it was overriding the database settings. I have reset the printer to letter several times now after running the database, and still can't figure out why it is changing.
Any ideas?
Tom
