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
    Posts
    10

    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.

    Thanks,

    Ira

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,836
    (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