Label from a database

[stu]

Hi,
Daft question but I can't find the solution anywhere!
How do I print a single label from an address record I've
just added to a larger database? I want to set up a
simple operation so when a customer calls I just add him
to my database, then easily print off one address label
for his single order.
THANKS!
Stu

 

[Jeff Boyce]

Stu

One approach would be to build a form with a combo box holding the
customers. After selecting a customer, the form would need a command button
that launches your "label" report to a suitable printer. So you'd also need
a "label" report.

Good luck

Jeff Boyce
<Access MVP>

 

[Liz]

You could run the Label Report off a query based on the
address records table.
Include a Date Added field to the table. When you add a
new record to the table put todays date in the Date Added
field.
In the query include the Date Added field with the
following in the criteria row: = Date()
This will give you only the records added today....so as
long as you are printing the label the same day as adding
it to the table you will get your results.

Good Luck!

 

[Tim Ferguson]

I want to set up a
simple operation so when a customer calls I just add him
to my database, then easily print off one address label

It should not be too hard to create a report, and run it with a filter of
just the one PK value, and then use a form to get the user to set the left
and top margins...

For a model, see how Word does its print-one-label wizard.

Hope that helps


Tim F