Access report with multiple subreports, displays about 15 pages of data. Customers usually print the first 2 pages and the other 13 pages are thrown away. My customers do not want the report changed, they like to see the information displayed on screen but are printing out the whole report.(instead of using the print dialog and selecting page 1 to 2)
To save paper I want to only print out page 1 & page 2 when the user prints the report. Is there a way to control this via a vba onprint statement? Please post the code?
"Is there a way to control this via a vba onprint statement?"
"How can I capture the print command instead of creating a button."
If you click on the MS-supplied printer icon button on a toolbar/ribbon,
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…