Results 1 to 2 of 2
  1. #1
    GodBlessNY is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2016
    Posts
    9

    A question on printing fields from a query to the printer


    Hello there
    I have Access 2010. What are the commands to print certain records from a query to the printer or a text file? Does VBA have an actual "write" or "print" command? thanks!

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    The commands I use the most are
    Docmd.OutputTo
    Docmd.TransferSpreadsheet
    Docmd.TransferText

    And you can use VBA to create text files (.txt or .csv) and print/write whatever you want.

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

Similar Threads

  1. Thermal printer Slow printing
    By Nasir Ali in forum Programming
    Replies: 2
    Last Post: 05-28-2014, 08:13 AM
  2. Replies: 5
    Last Post: 01-27-2014, 07:50 AM
  3. Replies: 0
    Last Post: 11-07-2010, 01:28 PM
  4. Setting Printer when Printing Report
    By russ0670 in forum Reports
    Replies: 3
    Last Post: 05-12-2010, 09:45 AM
  5. Printing to an intermec printer from access
    By dkalsow in forum Programming
    Replies: 3
    Last Post: 12-16-2009, 06:11 PM

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