Report to print one address label

[Guest]

Ok, at it's most basic, I have a database with a list of people in it and a
form to display this info. I would like to place a button on the form that
would print the address (shown on the form), and not all the addresses in the
database.

Do I need to create a query first? and if so, how do i get the query
criteria to update automatically? Or can the report generation simply "lift"
the data from the form?

I'm sure this is an easy one, but not knowing too much about Access and
after trying for a good few hours, i thought it time to ask the experts

What do you think?

 

[Joseph Meehan]

Ok, at it's most basic, I have a database with a list of people in it
and a form to display this info. I would like to place a button on
the form that would print the address (shown on the form), and not
all the addresses in the database.

Do I need to create a query first? and if so, how do i get the query
criteria to update automatically? Or can the report generation simply
"lift" the data from the form?

I'm sure this is an easy one, but not knowing too much about Access
and after trying for a good few hours, i thought it time to ask the
experts

What do you think?

There are several possible answers. The way I have usually done it is
to add a binary field to the table. Your button could select and change
that field, or you could just let the user select that field and change it.
You might then allow the user to select more than one record so that the
labels could all be printed at the same time using a filter on that binary
field somewhere and make sure that they are all rest to the default state
when done.

 

[Guest]

Hmmm, i don't think that's what i'm after. The person's name is in a txt box
and the address is in a memo field (with carriage returns). I basically just
want to pipe the text from those two controls to a blank report for printing
(or bypass the report entirely if possible)

The "print" button should only ever print the address of the person whose
record is being viewed.

What do you think?

 

[Guest]

this works for me to print a single record. with your form on the screen, go
to view, select design view, then select toolbox, select command button on
the toolbox, drag the command button to where you want it on your form and
release. i think you can find your way from that point.

 

[Guest]

Hmm, printing a record is fiine. the trouble is, i only want to print two
fields from a record...

 

[Guest]

okay, i've been playing around with the DoCmd, hoping i'm in the right area.
This kinda works, but i can't work out how to filter the output to just the
UserName variable

Thoughts?

UserName = [RepName] & vbCrLf & [RepAddress]

stDocName = "006 - Print Address"
DoCmd.OutputTo acReport, stDocName