Label printing.

[ALui]

Does anyone know of a label printer with software that prints directly from Access?
Right now I'm thinking of using the [FONT=&quot]DYMO Label Writer 400 Turbo, [/FONT] [FONT=&quot]Brother P-Touch QL-500 or [/FONT] [FONT=&quot]Brother P-Touch QL-57. These only support word and excel though, so what I was thinking was to OutputTo a .rtf file and just printing from there. Is there an easier solution?
Attached is a sample label, which is 8 cm x 4 cm.
[/FONT]

 

[Mr. B]

Why not just print the label from Access?

You would create a report that would print the label(s). The Record Source for the report can restrict the list from which the labels will be printed. You can then use regular Label sheets like Avery to print on for your labels. You would use code to specify the starting position on the sheet where the labels are to start printing.

I just completed an application that prints labels at the close of each day for mailing catalogs based on new requests recieved each day. This application uses exactly the kind of label printing that I tied to describe above.

If you need additional assistance please post back.

HTH

 

[Kiwiman]

Howzit

Check this post out - KenHiggs' sample databases. I haven't tried it myself, but could be worth a look. Post 13 is the one you want.

http://www.access-programmers.co.uk/forums/showthread.php?t=99777

 

[ALui]

I was going for a thermal label printer, not with the avery sheets because there only needs to be only 1 label each time, and it's a bit of a pain to feed the sheet back into the printer everytime.
I have the label recordsource restricting which patient label I want to print, but the problem is I am wondering if printing straight from access would work with a thermal label printer (the small ones like brother and DYMO)

 

[Mr. B]

I have never tried to print to one of those, howeveer, if you design the report to fit the "page" that the printer is looking for, it should work.

Good luck.