Printing Envelopes

[Richard]

Hi fourm,

I have a form/subform one to many relationships. I have setup a command
button on my form to print envelopes. If I create one record and then print
an envelope it works great, But if I create five (related) records then I
get five envelopes printed. I need one envelope per customer not one per
record. My subform is setup in datasheet view.

I hope this makes sence thank you in advance.

 

[Wayne-I-M]

Hi Richard

The address on an envelope is the same as printing the address on a bit of
paper - It's a report.

Create a report that will print the address based on a filter query - you
can use a form to provide the filter.

Use your button to print the report

You don't give enough information to give any other advice so hope this
helps. If not then you can post back with some more information - like the
code behind your button, where are the addresses coming from, etc.

Good luck

 

[Richard]

Hi Wayne,

Yes I know that a envelope is a report, and my envelope is based on a query
that I pick off the address from. That part works great. My problem is the
rows of information in the subform, each row in the subform produces an
envelope. I only want one envelope regardless of the number of rows in my
subform. I'm looking for some code that I could put behind my envelope button
that would restrict the out put to one report? I thought it could be done
with comas .
Thanks

 

[Wayne-I-M]

You don't say how you are filtering your data

If you have a query with 100 records in you need to tell "it" to filter to
only the record you want to be printed in the report. Sorry if you already
know this

This is what I "think" you want to do (tell me if I am wrong)

You have a main form with a subform - you want to print an envelope to the
person shown in the main form ???

In this case put your button in the header (or somewhere) on "main" form

DoCmd.OpenReport "ReportName", acViewNormal, , "ID = " & Me.ID

 

[Richard]

Hi Wayne,

Finally figured this one out. I built a new query based on the parent
table, which holds the data I need to print the envelope. I had a join query
before. Then with a little sorting and grouping on the report it worked out.
Sometimes it hard to see the forest from the trees..


Richard
Rookie from California