Access 2003 Invoice

[Greg R]

I am asking this on behalf on someone else.

They need to make invoices from access. This person would like to
know how even the boss does not know how. However, they will be
manually changing the name and address of each invoice.

Would Microsoft Word be better for this? Where are the sample invoices
for both Microsoft Access and Microsoft Word?

Greg R

 

[Allen Browne]

Presumably you have tables for:
- Customer: CustomerID, CustomerName, Address, City, ...
- Invoice: InvoiceID, CustomerID (who the invoice is for), InvoiceDate,
....
- InvoiceDetail: InvoiceID (which invoice this line belongs to),
Quantity, ...

Now you want the invoice to default to the customer's name and address, but
to be able to change the address for individual invoices. Presumably you
want Access to remember which address it was actually sent to.

That's quite simple. In the Invoice table, include the name and address
fields. You can still tie the invoice to a particular customer (CustomerID),
but specify a particular address for that invoice.

You can even have Access fill in the usual address for the customer for you,
and then you overtype it if necessary. To see how to do that, open the
Northwind sample database, the Orders form, and follow their example.

 

[John Vinson]

I am asking this on behalf on someone else.

They need to make invoices from access. This person would like to
know how even the boss does not know how. However, they will be
manually changing the name and address of each invoice.

Would Microsoft Word be better for this? Where are the sample invoices
for both Microsoft Access and Microsoft Word?

Greg R

I have no idea how your tables are structured; typically you would
have a Customer table containing the names and addresses, related one
to many to an Invoices table. The printed invoice would be a Report
based on a query joining these two tables (or perhaps three or more
tables, depending on your table design).

I don't know of any "sample invoices" in Access; they'd tend to be
pretty particular to a given business. There is an Invoice report in
the Northwind sample database which you could use as an example,
though.

John W. Vinson[MVP]