Results 1 to 2 of 2
  1. #1
    chromachem is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    49

    Print Labels Without field name.

    I know this should be easy. tblLabels has 1 label to print.


    LabID
    602001


    The code we run to print a label is as follows:

    Code:
    Public Function PrintSave()
    Dim strDefaultPrinter As String
    strDefaultPrinter = Application.Printer.DeviceName
    Set Application.Printer = Application.Printers("Brother QL-570 LE")
    DoCmd.PrintOut
    Set Application.Printer = Application.Printers(strDefaultPrinter)
    End Function

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I'm not sure what you need. Does the code you have work? Why can't you use a Report?

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

Similar Threads

  1. Replies: 10
    Last Post: 12-13-2015, 07:23 AM
  2. How to print custom-sized labels
    By jdorin in forum Access
    Replies: 1
    Last Post: 03-01-2013, 12:40 PM
  3. develope a gui to print labels
    By mfran2002 in forum Access
    Replies: 1
    Last Post: 02-22-2013, 10:40 PM
  4. Replies: 10
    Last Post: 11-23-2010, 10:16 PM
  5. cannot print labels
    By Diane in forum Database Design
    Replies: 4
    Last Post: 12-29-2005, 08: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