Web Development

Ask something
Discussion Locked

Printing Individaul Address From Access

0 helpful
4 replies

by d_irvine

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have created a database in Access 2000 for new orders received daily. We import this file into our United Parcel shipping computer. Some the new orders are mailed because the cost of the shipping can be greater than the cost of the product. Would I do a report or a form in Access to print an individual shipping label? If the shipping label is say 2" x 4" can I make the printer stop at the bottom of the label so the next label can be printed without have to be reset on a label by label basis? I want to use a dot matrix printer for this label, because I can buy stock blank labels. I am fairly new to Access, but truly enjoy working with it. Please keep this in mind when answer this question. When I do print the label will the field names print, ie. Address1, Address2 etc. I only with the information contained in the fields to be printed.
Thank you very much for any help you can give me.
D_Irvine@sympatico.ca

4 replies

by sl-campbell

When you go to the Reports window/tab and click on "New" you will see several Wizards/Assistants to help in creating a report. One of them is an assistant to help in creating mailing lables. Select the d?tabase table where your data is and start theassistant and go through the steps, selecting the lable sizes, database fields, etc. Once the report is generated you can then go into the design mode and fine tune the lable. Also, as far as the printer is concerned, click on the menu item FILE|PRINT SETUP to fine tune the page settings and then FILE|PRINT - properties to select the printer that you want to use for this report.

by sl-campbell

PS.
You can print a single lable for a certain customer by doing the following:

Open the report in Design view.
You will see on the toolbar a small drop-down window - make sure REPORT is selected. Then slect the menu item VIEW|PROPERTIES. A small properties window will open.
Selected the Data tab. Click in the FILTER field. Enter the name of the field that you enter your criteria for which customer is the label to be printed for:

CustomerID=[Enter Customer ID]
CustomerID being the name of the field for the customer id, name or whatever.

The next line "Filter On" select yes.

Now save you report. When you open it up a box will come up asking for the ID/Name of a customer - enter it as it is found in the database table. The report will open with this customer only.

If you ever want to print all labels the just turn the Filter off (Filter on = no)

by d_irvine

Thank you very much for your help. I appreciate you taking the time to answer my question.

This discussion is closed to new replies.