Results 1 to 6 of 6
  1. #1
    Middlemarch is offline Competent Performer
    Windows 10 Access 2019
    Join Date
    Mar 2015
    Posts
    365

    Print Macro Single sided


    Apologies if this is more an Office question than Access. I couldn't find an Office forum and being VBA may be applicable here.
    Code:
    Sub PrintCurrentPage()
        Application.PrintOut FileName:="", Range:=wdPrintCurrentPage, Item:= _
            wdPrintDocumentWithMarkup, Copies:=1, Pages:="", PageType:= _
            wdPrintAllPages, Collate:=True, Background:=True, PrintToFile:=False, _
            PrintZoomColumn:=0, PrintZoomRow:=0, PrintZoomPaperWidth:=0, _
            PrintZoomPaperHeight:=0
    End Sub
    Is there any way to add a single-sided instruction to this?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Is this code in Access VBA? Does it actually work? Does not look valid to me. I don't see an Application.PrintOut method.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Middlemarch is offline Competent Performer
    Windows 10 Access 2019
    Join Date
    Mar 2015
    Posts
    365
    It's MSWord VBA. Yes it works but an enhancement to print s/sided is sought.
    Not Access but someone here may know as it's all part of Office.

  4. #4
    Join Date
    Apr 2017
    Posts
    1,680
    Quote Originally Posted by Middlemarch View Post
    I couldn't find an Office forum and being VBA may be applicable here.
    At bottom of forums main page, the last link is to Microsoft Office forum

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Apparently not with parameters of PrintOut method. Document.PrintOut method (Word) | Microsoft Learn

    I have done this in Access VBA. Example:
    Code:
    'open report in preview mode because is only way to change bin and/or printer destinations without changing report saved setup
    DoCmd.OpenReport "SampleLabels", IIf(Application.Printer.DeviceName Like "*Konica*", acViewPreview, acViewNormal)
    If Application.Printer.DeviceName Like "*Konica*" Then
           Reports("SampleLabels").Printer.Duplex = acPRDPSimplex
           DoCmd.PrintOut
    End If
    Maybe the solution you need for Word is in this thread https://answers.microsoft.com/en-us/...d-27332b826a12
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    Middlemarch is offline Competent Performer
    Windows 10 Access 2019
    Join Date
    Mar 2015
    Posts
    365
    Many thanks for the replies and help. Am investigating.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Print a report with a single record
    By TOPSie in forum Access
    Replies: 3
    Last Post: 03-17-2021, 02:48 PM
  2. Print out single record onto a report
    By CQCDave in forum Access
    Replies: 2
    Last Post: 04-23-2015, 06:54 AM
  3. Print single label
    By Voodeux2014 in forum Access
    Replies: 2
    Last Post: 11-12-2014, 01:52 PM
  4. Print Single Record
    By stattech in forum Reports
    Replies: 5
    Last Post: 10-05-2010, 03:38 AM
  5. Print Single Report
    By emkwan in forum Access
    Replies: 1
    Last Post: 01-29-2010, 11:19 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums