PRINT OR SEND EPL COMMAND FROM VBA ACCESS2010

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 .
LVL 1
Manfred35Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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.
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Here's a link BTW:

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

Jim.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Manfred35Author Commented:
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"
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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.
Manfred35Author Commented:
Sorry i just forgot to reset the printer, it seems to work now. I continu some test and tell you.
Thank you.
Manfred35Author Commented:
Finally it was the best solution for my actual need. Thank you very much. Sorry for the little delay for my response. BY
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Not a problem.  Just glad to hear your up and running!

Jim.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.