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!

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

change spesific printer from VBA code

Status
Not open for further replies.
JimYellow

JimYellow

Programmer
Nov 3, 2003
13
AU
I want to change the printer that a report prints to as it prints or just before.

depending on the user that is logged in at the time.

I can copy the report and print the required version but it would be much nicer if I could just change the printer from code.
 
Sort by date Sort by votes
Depending of your version of access you may take a look at the Application.Printer property and Application.Printers collection.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Filter vba problem
Replies
1
Views
719
Andrzejek
Andrzejek
Omarahmed22
  • Locked
  • Question
VBA Formating
Replies
1
Views
642
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Vba code I can call from a query to reformat text
Replies
8
Views
608
Moss100
Moss100
TheAceMan1
  • Locked
  • Question
Delete from listi n XL open tab with VBA
Replies
2
Views
522
TheAceMan1
TheAceMan1
M
  • Locked
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
4K
SoftwareRT
SoftwareRT

Part and Inventory Search

Sponsor

Back
Top