L
Lungta
Hi, I need to either build a better Access rpt or find out a solution to my
Word merge - hope somebody here can help.
Main data entry form "frmCase1" has info about case (open date, situation,
etc.).
1st subform "sfCaseAppl" has detail records for each kid involved in this
case.
Another separate subform "sfAppt" has the name(s) of each specialist
assigned to this case.
Case to Kid is many-many, and concatenation is working great with D.
Hookom's Generic Concatenate solution.
I want cmd buttons to merge to 3 standard reports about this case. Every
case has to get 2 letters, fax cover for each, plus the existing 1-page
Access rpt mentioned below.
Letter 1 goes to the kids' coach saying a specialist has been assigned.
This is one page for each kid record and includes kid/case/specialist detail.
The fax page displays a concatenated list of kids & total page count, plus
however many merge records of Letter 1 are needed. So a case with 4 kids
would have 4 pages of Letter1 plus fax cover saying "5 pages incl. cover".
Letter 2a or 2b, three pg. plus fax cover sim. to above, goes to the
specialist (different types of specialist get a different letter). It has
one concatenated string of kids' names and locations, then standard text with
specialist contact info, etc. (no further kid info).
Specialist also gets an Access report with the detailed kid info for all
kids on the case (2 kids per page).
So a case with 4 kids would get one letter (3 pg.) plus Access rpt (2 pg. in
this situation) plus fax cover saying "6 pages incl. cover".
Questions:
(1) Setup sounded perfect for Access rpts, but some text needs italic font
mixed with plain font within 1 textbox and that doesn't look possible in
Access. In addition, I'm not sure if the section sizes can be adjusted to
really turn out like letters & fax covers. Any suggestions here would be
welcome.
(2) If not, A. Kallal's word merge with bookmarks looks great. But it seems
to be bookmarked to controls on an open form - my letters are based on one
humongous query and the Case1 form doesn't have anywhere near all those
controls. I'm also not too clear on how to properly reference multiple
records off subforms like that.
Is there a way within that Word Merge sample to set the recordsource on the
query instead, filtered by the current CaseID on the open frmCase1? Found an
example by Andy Baron on the mvps.org/access site - is this appropriate for
what I'm trying or is it something totally different?
(3) Anybody have a clue how I could get the page count automated (taking
into account the one Access rpt as well? It isn't the end of the world if
folks have to write it in, but there must be a way...
any ideas would be enormously appreciated!!
thanks - this is an amazing forum!
Word merge - hope somebody here can help.
Main data entry form "frmCase1" has info about case (open date, situation,
etc.).
1st subform "sfCaseAppl" has detail records for each kid involved in this
case.
Another separate subform "sfAppt" has the name(s) of each specialist
assigned to this case.
Case to Kid is many-many, and concatenation is working great with D.
Hookom's Generic Concatenate solution.
I want cmd buttons to merge to 3 standard reports about this case. Every
case has to get 2 letters, fax cover for each, plus the existing 1-page
Access rpt mentioned below.
Letter 1 goes to the kids' coach saying a specialist has been assigned.
This is one page for each kid record and includes kid/case/specialist detail.
The fax page displays a concatenated list of kids & total page count, plus
however many merge records of Letter 1 are needed. So a case with 4 kids
would have 4 pages of Letter1 plus fax cover saying "5 pages incl. cover".
Letter 2a or 2b, three pg. plus fax cover sim. to above, goes to the
specialist (different types of specialist get a different letter). It has
one concatenated string of kids' names and locations, then standard text with
specialist contact info, etc. (no further kid info).
Specialist also gets an Access report with the detailed kid info for all
kids on the case (2 kids per page).
So a case with 4 kids would get one letter (3 pg.) plus Access rpt (2 pg. in
this situation) plus fax cover saying "6 pages incl. cover".
Questions:
(1) Setup sounded perfect for Access rpts, but some text needs italic font
mixed with plain font within 1 textbox and that doesn't look possible in
Access. In addition, I'm not sure if the section sizes can be adjusted to
really turn out like letters & fax covers. Any suggestions here would be
welcome.
(2) If not, A. Kallal's word merge with bookmarks looks great. But it seems
to be bookmarked to controls on an open form - my letters are based on one
humongous query and the Case1 form doesn't have anywhere near all those
controls. I'm also not too clear on how to properly reference multiple
records off subforms like that.
Is there a way within that Word Merge sample to set the recordsource on the
query instead, filtered by the current CaseID on the open frmCase1? Found an
example by Andy Baron on the mvps.org/access site - is this appropriate for
what I'm trying or is it something totally different?
(3) Anybody have a clue how I could get the page count automated (taking
into account the one Access rpt as well? It isn't the end of the world if
folks have to write it in, but there must be a way...
any ideas would be enormously appreciated!!
thanks - this is an amazing forum!