MS Access remains not user friendly for printing
November 7, 2012 8:44 AM Subscribe
I've switched my Access 2010 database from using Switchboard to using a Navigation Form. It's prettier and faster and it makes it impossible to print reports properly.
posted by jeather to Computers & Internet (6 answers total) 1 user marked this as a favorite
If I select reportPrintable from my Navigation form, I get to put in my parameter(s). Then I can view it. If I try to print, I print the navigation form around it, too. This happens if I add the print button that Access so kindly provides to the form.
What I have, that sort of works, is a button on the report itself. On Click, I run the macro as follows:
Private Sub Command102_Click()
DoCmd.SelectObject acReport, "reportPrintable", True
This selects the report and prints the current report without the navigation form, but I have to reenter the parameters I used. This isn't reasonable for the long term. There are about a half dozen reports that have to be printed, and each report has either one or two parameters. (Either an ID number, a year, or a year and a month.)
Is there any way to fix this so it works more like the Switchboard used to work, or do I have to go back to it?