I have an Access XP application that has a number of reports; all of which are run from command buttons on forms.
The majority of these reports are previewed before printing and that gives the users an opportunity to select an alternative printer for the actual printed pages.
However, there are two reports that are NOT previewed before printing; these are to be directed to SPECIFIC printers that vary from workstation to workstation.
In the MDB version of the application this is not too difficult a problem to overcome; the reports can be opened in design mode and a specific printer can be selected using the page setup option on the file menu.
In the MDE (runtime) version, however, the problem does not seem to be quite as easy to solve; the report settings may not be amendable because the reports themselves cannot be opened in design view.
Is there any way, using Visual Basic code associated with the command buttons to run the reports, that these reports can be directed to SPECIFIC printers based on parameters held for each workstation on which the (runtime) application has been installed?
For example: users of workstations OFFICE and SHOP want these reports to go directly to a printer called SHOWROOM; whereas users of the STORES machine want the same reports to be automatically printed a local printer!
The majority of these reports are previewed before printing and that gives the users an opportunity to select an alternative printer for the actual printed pages.
However, there are two reports that are NOT previewed before printing; these are to be directed to SPECIFIC printers that vary from workstation to workstation.
In the MDB version of the application this is not too difficult a problem to overcome; the reports can be opened in design mode and a specific printer can be selected using the page setup option on the file menu.
In the MDE (runtime) version, however, the problem does not seem to be quite as easy to solve; the report settings may not be amendable because the reports themselves cannot be opened in design view.
Is there any way, using Visual Basic code associated with the command buttons to run the reports, that these reports can be directed to SPECIFIC printers based on parameters held for each workstation on which the (runtime) application has been installed?
For example: users of workstations OFFICE and SHOP want these reports to go directly to a printer called SHOWROOM; whereas users of the STORES machine want the same reports to be automatically printed a local printer!
