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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by scamquist58
-
Change Access Default Printer
Combo, Thank you for the assistance. This is the line that worked for me Set Application.Printer = Application.Printers(("\\PP-FP01\Office Canon iR-ADV C3230i UFR II"))- scamquist58
- Post #9
- Forum: Microsoft: Access Modules (VBA Coding)
-
Change Access Default Printer
From immediate window Debug.Print Application.Printers(7).DeviceName \\PP-FP01\Office Canon iR-ADV C3230i UFR II full code that works Private Sub Form_Load() Dim prtDefault As Printer Set Application.Printer = Application.Printers(7) Set prtDefault = Application.Printer End Sub code below...- scamquist58
- Post #7
- Forum: Microsoft: Access Modules (VBA Coding)
-
Change Access Default Printer
I tried Set Application.Printer = Application.Printers(i)."192.168.0.25" Set Application.Printer = Application.Printers(i)."\\PP-FP01\Office Cannon iR-ADV C3230i UFR II" Set Application.Printer = Application.Printers(i)."\\PP-FP01\Office Cannon iR-ADV C3230i UFR II" Returns Complie error...- scamquist58
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Change Access Default Printer
If I use any of the following statements: Set Application.Printer = Application.Printers("\\PP-FP01\Office Cannon iR-ADV C3230i UFR II") Set Application.Printer = Application.Printers("Office Cannon iR-ADV C3230i UFR II") Set Application.Printer = Application.Printers("192.168.0.25") I the the...- scamquist58
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Change Access Default Printer
I am trying to change the default printer when an Access form loads. The following code works: Private Sub Form_Load() Dim prtDefault As Printer Set Application.Printer = Application.Printers(7) Set prtDefault = Application.Printer End Sub However, I want to specify the printer name. DEVICE...- scamquist58
- Thread
- Replies: 8
- Forum: Microsoft: Access Modules (VBA Coding)
-
VB Change Default Printer - Access
I am trying to change the default printer when an Access form loads. The following code works: Private Sub Form_Load() Dim prtDefault As Printer Set Application.Printer = Application.Printers(7) Set prtDefault = Application.Printer End Sub However, I want to specify the printer name. DEVICE...- scamquist58
- Thread
- Replies: 1
- Forum: Microsoft: Access Project (ADP)
