Results 1 to 14 of 14

Thread: [Resolved] Change printer in Access 2000

Threaded View

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Oct 2001
    Location
    Indiana
    Posts
    612

    [Resolved] Change printer in Access 2000

    I am using the following code on a command button in an Access 2000 program.

    Code:
    Dim x As Printer
    
    For Each x In Printers
        If x.DeviceName = "Acrobat Distiller" Then
            Set Printer = x
            Exit For
        End If
    Next
    
    DoCmd.OpenReport "Prop_Invoice_Email", acViewPreview, , "Month(Inv_Statement_Date) = " _
    & Format(Month(dteStatementDate), "00") & " And Year(Inv_Statement_Date) = " & _
    Format(Year(dteStatementDate), "00")
    
    DoCmd.PrintOut acPrintAll, , , acHigh
    I want this report to print out to my Acrobat Distiller printout but it is printing to my system default printer.

    Anyone have any ideas why this is happening?

    Thanks
    Last edited by indydavid32; Jun 30th, 2003 at 11:56 AM.
    David Wilhelm

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width