Results 1 to 2 of 2

Send file to Zebra Printer ZP 505

  1. #1
    Ira is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2011

    Send file to Zebra Printer ZP 505

    Hi All,

    I am using Access 2013 with Windows 8.1.

    I have a Zebra 505 label printer installed and it is working properly. I can print to it from Word or NotePad etc.

    Ultimately, I will be trying to send a file (FedEx.zpl) to the printer from VBA. The file is a response from the FedEx Ship Services Shipment routine and is the label format that the Zebra recognizes.

    But first, I am try to get something (anything) to print from the printer in code directly.

    I have tried numerous methods with no luck.

    I wrote a piece of code to enumerate through the all the installed printers and it does indeed find ZebraZP on port USB001.

    I have tried different snippets of code to try and get it to work with no luck.

    I don't get errors, but nothing happens. Below is just a simple example where I am just trying to get something to print.
    You will see from some of the code commented out, where I have tried different things with no luck.

    Dim ItemName, ItemNum, ClassID
    ItemName = "Expresso"
    ItemNum = 142222

    ClassID = "Coffee"
    'Open "\\IraDellLaptop\ZebraZP" For Output As #1 'try to print to it using network name, no luck
    Open "USB1" For Output As #1
    Print #1, ItemName & " " & ItemNum & " " & ClassID 'try some random text, no luck
    Print #1, "C:\Users\ISaunders\Documents\Quality Chemical\RateResponse.txt" 'try a text file, no luck
    Close #1

    Any help would be greatly appreciated.



  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    8300' in the Colorado Rocky Mountains
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

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

Similar Threads

  1. Replies: 2
    Last Post: 03-16-2014, 01:12 PM
  2. Replies: 3
    Last Post: 02-25-2014, 10:46 AM
  3. Replies: 8
    Last Post: 12-08-2013, 01:07 AM
  4. Send Report to a NEW file
    By alyon in forum Access
    Replies: 9
    Last Post: 12-06-2011, 11:57 AM
  5. Help Send Report to File.
    By alyon in forum Access
    Replies: 4
    Last Post: 08-22-2011, 09:37 AM

Tags for this Thread

Posting Permissions

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