Solved

PRINT OR SEND EPL COMMAND FROM VBA ACCESS2010

Posted on 2012-03-12
7
1,001 Views
Last Modified: 2012-06-27
Hello to all developpers from an ACCESS developper. I want to send EPL command from VBA ACCESS 2010 - I found many information about other platforms that i cant make work on my VBA solution. The less i would appeciate would to be able to send a EPL command file to my usb Zebra printer. Send command directly to the printer would be better. Can someone help me. I cant think that such a simple thing seems to be so hard.
ZEBRA 2844 - USB - WINDOWS 7 64 - EPL COMMAND FILE is OK manually
Thank you .
0
Comment
Question by:Manfred35
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 58
ID: 37711321
Out on the net you'll find a bunch of free file to printer utilties out there.  I use PrintFile, written by Peter Lerup.

WIthin Access, I generate a file to disk using the correct print driver with it's output set to file.  I then take that file output and pass it to the printer using the PrintFile utility.

Not quite sure what's involved in printing directly to a port.  Years ago, I know it was as simple as a COPY using the /b switch for binary mode.  Not sure if that would work with a USB port or not.

Jim.
0
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 37711326
Here's a link BTW:

http://www.lerup.com/printfile/

Jim.
0
 
LVL 1

Author Comment

by:Manfred35
ID: 37711605
Thank you very mutch JDettman you give me one more way for searching. After dowloading printfile I am trying this line in the immediate windows but doesnt do anything. I continue testing and tell the result.
The command:
Shell "C:\0PciSvr\PrFile32.exe /q C:\0PciSvr\TLP2844a.txt"
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 58
ID: 37711651
I would test with it manually first.  It supports drag and drop.  So just with explorer open, drag your file on top of it and see if it does what you want.

If it does, then I would leave it running all the time and have it in "spool" mode, which means it's always looking at a directory and when it sees a file appear, it will print it.  Then you just need to move a file there.

If you do not want to do that, I am sure there is a way to get it to work with Shell().

Jim.
0
 
LVL 1

Author Comment

by:Manfred35
ID: 37711679
Sorry i just forgot to reset the printer, it seems to work now. I continu some test and tell you.
Thank you.
0
 
LVL 1

Author Closing Comment

by:Manfred35
ID: 37724828
Finally it was the best solution for my actual need. Thank you very much. Sorry for the little delay for my response. BY
0
 
LVL 58
ID: 37724852
Not a problem.  Just glad to hear your up and running!

Jim.
0

Featured Post

Portable, direct connect server access

The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question