(Msg. 1) Posted: Thu Jul 24, 2008 6:40 pm
Post subject: Printing Envelopes Archived from groups: microsoft>public>access>gettingstarted (more info?)
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.
(Msg. 2) Posted: Thu Jul 24, 2008 11:46 pm
Post subject: RE: Printing Envelopes [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
--
Wayne
Manchester, England.
"Richard" wrote:
> 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.
(Msg. 3) Posted: Fri Jul 25, 2008 7:18 am
Post subject: RE: Printing Envelopes [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
(Msg. 4) Posted: Fri Jul 25, 2008 8:25 am
Post subject: RE: Printing Envelopes [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
> 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
(Msg. 5) Posted: Sat Jul 26, 2008 8:31 am
Post subject: RE: Printing Envelopes [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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..
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other