printing individual label from a form?

I

Ivan

I sought a solution in Access 2003 for dummies, 7 in 1 with no help.

I have an order entry form with Ship to address stored in Orders table that
is different from Customer address in Customer table.

I have used report Label Wizard to design a label. I used an Orders Query
(which is also the source of data for the orders form) as the source for
data. When I preview the report, it shows all customers.

I would like to add a command buttom on the form. If all the data is
inputed, will the label report wizard know to print the data in the current
record only?

Is the solution in query setup or the report?

THANK YOU in advance!!!
 
P

PC Datasheet

To start, Ship Address is in the wrong table. If all customers have only one
Customer Address and one Ship Address, both need to be in TblCustomer. If
amy customer can have more than one Customer Address and/or more than one
Ship Address, you need an address table that looks like:
TblAddress
AddressID
CustomerID
AddressTypeID
Address
City
State
Zip

and an address type table like:
TblAddressType
AddressTypeID
AddressType 'Customer Address/Ship Address


In query setup!

Create a query that has CustomerID and all the data you want on the label.
The data you want on the label must come from the correct table to give you
the Ship Address. Set the criteria for CustomerID to:
Forms!NameOfOrderEntryForm!CustomerID

If you're printing one label at a time, you're probably wasting many labels
because each time the report tries to print to the same label on the sheet
of labels. I can add functionality that will allow you to select the label
you want to print to. If you want my help, contact me at my email address
below.
 
I

Ivan

Thank You, PC Datasheet!

Please forgive me if I sound as if I am questioning your knowledge, because
I am not.

My Customer table has a one to many relationship with the orders table.
After reading over my response to you, I deleted it because I read MANY
Orders have MANY ship to addresses. I will separate the tables. Then I will
look into a mail merge, or your suggestion!

Thanks,
Ivan.
 
P

PC Datasheet

In regards to where the address fields are recorded, the relationship
between the customers table and orders table is irrelevant! Your tables
should look like:

TblCustomer
CustomerID
CustomerName

TblOrder
OrderID
CustomerID
OrderDate
<Other fields pertaining to the whole of the order>

Customer addresses should either be in TblCustomer or in an address table as
described in previous response.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com
 
Top