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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change printer driver in Access 2000

Status
Not open for further replies.

gundie

Programmer
Feb 5, 2004
69
US
I'm writing a program in Access 2000 that will send out faxes to customers. What I want to do is:

1. Start program
2. Change default printer driver to Winfax
3. Fax documents
4. Restore default printer driver to original

I've looked into ActivePrinter, but Access is giving me a

"Compile Error: Method or data member not found" on ActivePrinter.

What am I doing wrong?
 
This may help
Access 2000 Set Printer
thread705-858851
 
For the changing and restoring printer bit...
Code:
'Decalre a printer variable
Dim prt As Printer
'Set it to the current default printer
Set prt = Application.Printer
'Change printer to your other queue
Application.Printer = Application.Printers("YourPrinterPathHere")
'Do your faxing code here
'Set printer back to original default
Application.Printer = prt

[pc2]
 
mp9
Application.Printer is not available in my version of Access 2000, which, I think, gundie is using.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top