How to change default printer in office 2013

#How to change default printer in office 2013 how to#
#How to change default printer in office 2013 code#
#How to change default printer in office 2013 series#
#How to change default printer in office 2013 windows#

#How to change default printer in office 2013 series#

вЂApplication.Printer = Printers(вЂњHP LaserJet 3200 Series PCLвЂќ) вЂCan hard-code the default printer name if desired вЂSet printer back to former default printer

вЂSelect a specific printer as new default printerДЄpplication.Printer = Printers(вЂњHP Deskjet 9670вЂќ) This function can be run from the mcrAssignPrinter macro.Дebug.Print вЂњCurrent default printer: вЂќ & prt.DeviceName

#How to change default printer in office 2013 code#

You can assure that a specific report will be printed to a specific printer by using code like the following procedure, which hard-codes both the report name and the printer name.

The numbers prefacing the printer names are needed to reference a printer in VBA code, but you donвЂ™t need to display them in the combo box drop-down list. I have only one HP Deskjet 9670 printer вЂ“ the HP Deskjet 9670 Duplex printer item represents the printer in Duplex mode, for printing with ClickBook, so there are only two physical printers. Note that only some of the entries represent actual printers вЂ“ on the first computer, there one entry for my HP 3200 and two for my HP 9670, and on the second computer, there are two entries for the HP 3200 and four entries for the HP 9670. On the other computer (where the same printers are accessed via my home network) the list is as follows:ДЎ вЂ“ DELL_DIMEN_8300HP Deskjet 9670 DuplexДў вЂ“ DELL_DIMEN_8300HP LaserJet 3200 Series PCLДЈ вЂ“ Microsoft Office Document Image WriterДҐ вЂ“ Auto HP LaserJet 3200 Series PCL on DELL_DIMEN_8300Д¦ вЂ“ Auto HP Deskjet 9670 Duplex on DELL_DIMEN_830 On one of my computers (the one to which the printers are attached), the ListPrinters procedure yields the following list:Дў вЂ“ Microsoft Office Document Image Writer вЂThe printer number is listed for referencing the printer in code The following procedure lists the names for all printers installed in Windows, and their numbers as well (you will need the numbers when referencing a specific printer in code, or assigning printers in a value list for a combo box):

#How to change default printer in office 2013 windows#

To do this, first you need to know what the printerвЂ™s name is вЂ“ the name it has in the Windows Registry, which may not be the name you call it. To print a report to a specific printer (in VBA code), you need to change the default application printer you can set it back to its previous value after printing the report, if desired. But this is not (as you might think) the printer selected for this report, but the current default printer for Access as a whole. If you look at the properties of an Access 2002 or 2003 report in the Object Browser, you will see a Printer property. Access 2002 (Office XP) added a new feature, the Printer object, that has changed the way printers are assigned to reports, making it much easier to programmatically assign a printer to a report (no more messing with the obscure PrtDevNames and PrtDevMode properties).

In older versions of Access (prior to Access 2000), you could select a specific printer for a report, and then the report would automatically print to that printer in future вЂ“ convenient if you never changed the printer, but problematic if you got a new printer, or sent the database to someone else who had a different printer. IsnвЂ™t this possible any more? How can I specify that a particular printer must be used for certain reports?вЂќ The report was saved so that every time I printed the report, it would go to the appropriate printer (the downside being that if that printer wasnвЂ™t available, I would get an error message). writes: вЂњUnless my mind is starting to go, I remember being able to select a specific printer for a report in past versions of Access.

#How to change default printer in office 2013 how to#

How to print a report to a specific printer using the Printer Object.