Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBA Access Change Printer

Status
Not open for further replies.

killercelery

Programmer
May 29, 2003
4
CA
Hi,
I'm currently trying to change the printer on witch a report is to be printed in Access 2000 (no printers collection) depending on multiple variables. The printer has to be selected in the code.
I use the following APIs: -OpenPrinter
-StartDocPrinter
-StartPagePrinter
-WritePrinter
-EndPagePrinter
-EndDocPrinter
-ClosePrinter
As you know, their is no pointer in VBA so i use some methods to get "pointer".

OpenPrinter returns a "pointer" to a printer that I use with all other APIs.

The problem:
I can't find a method of a API that returns a pointer to the report I must print nor one that returns a pointer to the data to be printed.
If you have any idea what I should use or of an even better way to solve the printer selection process... help me plz, my mind is about to crack!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top