Label Wizard / Printer Problem

[fieldling]

This may take a while so please try to stay with me on this:
I have set up a query and a report (using label wizard) so that I can print a label of the current record viewed in a form. This seems to work until I get to the actual printing stage.

The printer I am using is an Epson LQ-300, printing onto a continuous sheet of labels (Avery's I think. 1 across. Dimensions 1 7/16" x 4").

When I press print I get the following code at the beginning of the label:
@EJL 1284.4
@EJL followed by endless blank labels. From what I can find on the net this is a driver problem but not sure how to fix it.

Also, in the label preview, should it be showing the single label as a full page report with the label text stuck in the top left? I have a similar report to print multiple labels and this also shows each label on a separate page. Doesn't seem right to me. Am I doing something wrong in the wizard set-up?

Any advice on this is most welcome. Thanks.

 

[KenHigg]

I fought with this a simple print app I did in Access and finally ditched the whole print report thing for labels and just sent a line of text at a time to the printer and it's been work great for several years now... If you want I can run down and get the exact code I used as I kinda forgot exactly how I did it

ken

Edit: Here it is - link

 

[fieldling]

Thanks for that. Am I able to use that code so that it prints the current record of a form?

I also have to print a number of order labels per day depending on the results of a query. Can it also be used for this purpose?

Any idea why it only shows one record per page in the report view?

So many questions.....

 

[KenHigg]

As long as you have the printer connected to parallel port (lpt1) the 'open' and 'print' command offers a lot of flexibility and you should be able to do all of what you described with some simple vba...

ken

 

[fieldling]

Hi Ken. That label programme works great! Thanks.
Two things though:
1. How to I format it so it prints in block capitals? Is it in the code?

2. How can I use it (if at all) to print the results of a query. I.e. multiple names & addresses?

 

[KenHigg]

1. I was thinking what ever character you sent was printed
2. I'm guessing you would need to loop through the recordset manually.

ken

 

[fieldling]

I thought that's what it would print too. All the data is formatted to > in the tables & forms but it's printing everything in lower-case.

I installed a new driver for the printer and it's stoppped printing that error code. I still can't get the label wizard to recognise continuous labels though. I guess I'll have to use sheet labels instead.

 

[fieldling]

I've discovered why only one label was showing per page. The bottom margin was set at 214cm. I adjusted this and the labels are now on one page.

However, it seems label wizard can't grasp the concept of continuous labels. It recognises the blank space at the end of each page which throws the labels out of alignment!

I would seriously recommend using sheet labels for multiple printing.