A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Zebra label printer



 
 
Thread Tools Display Modes
  #1  
Old November 13th, 2007, 07:10 PM posted to microsoft.public.access.gettingstarted
mcnews
external usenet poster
 
Posts: 231
Default Zebra label printer

anybody create any MS Access apps that print labels to a Zebra TLP
3842 thermal label printer via the USB port.
my app allows port selection and works fine with parallel or serial
ports.
when USB001 is selected with the same code nothing happens.
the printer works with notepad and the Zebra selected as the default
windows printer.
tia,
mcnewsxp

  #2  
Old November 13th, 2007, 11:46 PM posted to microsoft.public.access.gettingstarted
Tony Toews [MVP]
external usenet poster
 
Posts: 3,776
Default Zebra label printer

mcnews wrote:

anybody create any MS Access apps that print labels to a Zebra TLP
3842 thermal label printer via the USB port.
my app allows port selection and works fine with parallel or serial
ports.
when USB001 is selected with the same code nothing happens.
the printer works with notepad and the Zebra selected as the default
windows printer.


Interesting. How does your app do the port selection? Do you have
some code?

When I setup such a printer we had only one and it was a custom app.
So I just set that report to print on that printer while in design
view and it worked. We had to create a custom paper size on the
printer server though.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
  #3  
Old November 15th, 2007, 02:05 PM posted to microsoft.public.access.gettingstarted
mcnews
external usenet poster
 
Posts: 231
Default Zebra label printer

On Nov 13, 6:46 pm, "Tony Toews [MVP]" wrote:
mcnews wrote:
anybody create any MS Access apps that print labels to aZebraTLP
3842thermal label printer via theUSBport.
my app allows port selection and works fine with parallel or serial
ports.
when USB001 is selected with the same code nothing happens.
the printer works with notepad and theZebraselected as the default
windows printer.


Interesting. How does your app do the port selection? Do you have
some code?

When I setup such a printer we had only one and it was a custom app.
So I just set that report to print on that printer while in design
view and it worked. We had to create a custom paper size on the
printer server though.


i let them choose the port from a combo then open a print buffer and
write directly to the printer.
again, this works fine for LPTX: and COMX:
but not for USB001
  #4  
Old November 16th, 2007, 05:20 AM posted to microsoft.public.access.gettingstarted
Tony Toews [MVP]
external usenet poster
 
Posts: 3,776
Default Zebra label printer

mcnews wrote:

i let them choose the port from a combo then open a print buffer and
write directly to the printer.
again, this works fine for LPTX: and COMX:
but not for USB001


Ah, gotcha. Your problem makes sense but I doubt it can be fixed.
Access/VBA knows about LPT1-3 and COM1-4 and maybe more. However
Access/VBA doesn't know anything about USB ports. I think you'd need
to install some kind of low level device driver of some sort but I
have no idea what kind or how that would work.

I'd suggest visiting http://groups.google.com/ and search on visual
basic USB port printer. Most VB code works well inside basic. I
spent five minutes poking about but didn't see anything useful. You
may find something there though.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
  #5  
Old November 16th, 2007, 05:24 AM posted to microsoft.public.access.gettingstarted
Tony Toews [MVP]
external usenet poster
 
Posts: 3,776
Default Zebra label printer

"Tony Toews [MVP]" wrote:

I'd suggest visiting http://groups.google.com/ and search on visual
basic USB port printer. Most VB code works well inside basic.


Note that VB .NET code won't work in Access VBA.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
  #6  
Old November 20th, 2007, 06:22 PM posted to microsoft.public.access.gettingstarted
mcnews
external usenet poster
 
Posts: 231
Default Zebra label printer

On Nov 13, 2:10 pm, mcnews wrote:
anybody create any MS Access apps that print labels to a Zebra TLP
3842 thermal label printer via the USB port.
my app allows port selection and works fine with parallel or serial
ports.
when USB001 is selected with the same code nothing happens.
the printer works with notepad and the Zebra selected as the default
windows printer.



this works:

Share the USB printer, then run:

NET USE LPT1: \\127.0.0.1\mysharedprintername /PERSISTENT:YES

http://www.techspot.com/vb/topic42727.html
http://geekswithblogs.net/dtotzke/articles/26204.aspx
http://support.microsoft.com/kb/314499/en-us


  #7  
Old September 18th, 2009, 04:28 PM posted to microsoft.public.access.gettingstarted
lawrence jernigan
external usenet poster
 
Posts: 1
Default your MS ACCess app

Hi there...

I have a MS Access 2003 app that is now gonna print ID cards useing the Zebra p120i card printer...

Do you have an examples i could work from...

Sincerely and Respectfully;

Lawrence JErnigan



Posted as a reply to:

Zebra label printer

anybody create any MS Access apps that print labels to a Zebra TLP
3842 thermal label printer via the USB port.
my app allows port selection and works fine with parallel or serial
ports.
when USB001 is selected with the same code nothing happens.
the printer works with notepad and the Zebra selected as the default
windows printer.
tia,
mcnewsxp

EggHeadCafe - Software Developer Portal of Choice
WCF Workflow Services Using External Data Exchange
http://www.eggheadcafe.com/tutorials...vices-usi.aspx
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:10 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.