1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Pick a specific printer

Discussion in 'Business Applications' started by ACMINC, Apr 17, 2008.

Thread Status:
Not open for further replies.

    ACMINC Thread Starter

    Mar 26, 2008
    I already know how to make a report pick a specific printer from within DESIGN mode.

    And if you set your reports to open in Print Preview mode within the program(mdb) users can select the printer they require from the standard print dialogue box when they print the previewed report

    But the problem is when I then turned that same .mdb into a .mde that Print Preview mode method stops working. Is there another method for a .mde? Thanks -Ken.
  2. Keebellah

    Keebellah Trusted Advisor

    Mar 27, 2008
    First Name:
    have some code (found in MSAccess the Help

    Function SelePrn()
    Dim prtDefault As Printer
    ' the number between the ( ) is the printer.
    Set Application.Printer = Application.Printers(1)

    Set prtDefault = Application.Printer

    With prtDefault
    MsgBox "Device name: " & .DeviceName & vbCr _
    & "Driver name: " & .DriverName & vbCr _
    & "Port: " & .Port
    End With

    End Function

    Function ShowPrinters()
    Dim prtLoop As Printer

    For Each prtLoop In Application.Printers
    With prtLoop
    MsgBox "Device name: " & .DeviceName & vbCr _
    & "Driver name: " & .DriverName & vbCr _
    & "Port: " & .Port
    End With
    Next prtLoop
    End Function

    Create a module and past it and see the results, you will have to put some code to offer the user a choice.
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Similar Threads - Pick specific printer
  1. Battlesoaked
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/704620

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice