printing labels using table layout data

[ColinN]

I have been asked by a friend to take a look at his database and i'm quite frankly lost and would appreciate some assistance.

The database is supposed to print labels in the format predefined in the label design table. The information supposed to be contained in these labels is created through the use of a query which ask for product id and label quantity.

I am told this system for printing labels worked correctly until someone in their infinite wisdom mistakenly deleted the database (a long story!)

Is it indeed possible to format the layout of the labels through the use of the data contained in a table? How does this work and could someone point me in the right direction of a sample or tutorial perhaps?

Thanks a lot

Col

 

[Anthony George]

Hope this may be of help to you

Hi Colin

For a practice run:-

Open the database
select Reports Button
Select New Button
Select Label Wizard
Select your Table or Query from the dropdown box
Next the first label that is offered to you
Next the Font Type and size offered to you
Double click the fieldname in the left pane so it jumps onto the label on the right
By using the space bar, mouse, and enter key, arrange the layout of the label, click Next
Ignore the sort page for now
Name the report or accept the name offered by the computer
Click Finish

An error box will probably pop up saying Some Data May Be Lost, if this happens just click Ok

The report will be saved automatically in the Reports section for later use.

Hope this helps.

Tony

 

[ColinN]

Thanks for the reply Tony

What I really need to achieve is to provide a method by which the end user can enter the amount of labels required. Is there a method by which this can be done? Something like - user selects item to print> parameter box appears asking number of labels to be printed> labels print.

Just one more point (yes you're right I am an amateur at this) can the required product to be printed be selected from a drop down menu or combo box and ow would this be done?

Thanks
Col