Solved

PRINT OR SEND EPL COMMAND FROM VBA ACCESS2010

Posted on 2012-03-12
7
969 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
  • 4
  • 3
7 Comments
 
LVL 57

Expert Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility
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 57

Accepted Solution

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

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

Jim.
0
 
LVL 1

Author Comment

by:Manfred35
Comment Utility
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
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 
LVL 57

Expert Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility
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
Comment Utility
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
Comment Utility
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 57

Expert Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility
Not a problem.  Just glad to hear your up and running!

Jim.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Sum Max help (Add 1 Month) 3 18
MS Access Bound Objects. 6 28
Problems with GPO Printer Deployment 19 23
Access MDB/PDF 21 28
In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now