If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Change Windows XP default printer from Access
Here is a tricky: I am sending data from Access to Word template,
print and close Word template. What I need is to change default system printer, print from Word and return original default system printer. User prints cheques on specific printer and want to maintain document in Word template so they can easily make changes. Albert Kallal solution does not work on Windows XP - Word prints on the same printer, but when code finish execution there is no any default printer set in system. Macro in Word won't work either as they want to pick printer before printing, so I have build form which lists all available printers in network, but I am missing code to set printer as default. Any suggestions are appreciated. |
#2
|
|||
|
|||
Change Windows XP default printer from Access
On Jul 26, 9:32 am, wrote:
Here is a tricky: I am sending data from Access to Word template, print and close Word template. What I need is to change default system printer, print from Word and return original default system printer. User prints cheques on specific printer and want to maintain document in Word template so they can easily make changes. Albert Kallal solution does not work on Windows XP - Word prints on the same printer, but when code finish execution there is no any default printer set in system. Macro in Word won't work either as they want to pick printer before printing, so I have build form which lists all available printers in network, but I am missing code to set printer as default. Any suggestions are appreciated. Solution is to change printer in Word temporary with: objWord.Application.ActivePrinter = strPrinter objWord.Application.ActiveDocument.ActivePrinter = strPrinter objWord.ActivePrinter = strPrinter |
Thread Tools | |
Display Modes | |
|
|