Mereging with word data from Form and subform

[Frank Situmorang]

Helo,

I have Minutes of meeting database and this is my table:

Main form
tblMeeting date
1.Meeting_ID
2. Meeting date

Sub form (having Master and child link)
1. Decision_ID
2. Decision_NO
3. Subject
4. Decisions

I have a query to combine this 2 table
When I merge it to word taking data from the query, it only shows 1 line of
the chilld data while there are many decicions per 1 meeting date.

Besides creating a report and subreport to accomodate this requirement, Is
there any way to merge it into word.

I f more than 1 page, will it bring the closing sentence into the final page?

I have problem conditional page footer in the report and subreport style

Thanks for any help provided

 

[Albert D. Kallal]

The built in word merge only allows one record.

So, you are 100% correct that you can join the sub-form record in a query,
but you still only get ONE record (one line) of the sub-form record into the
word merge.

Hence, you have to write code to do this.....

There are samples and ideas on how to do this at:

http://homepage.swissonline.ch/cindymeister/MergFram.htm

look on the left side for speical merges. The one you want is

Multiple items per condition

I would suggest you simply build a nice report, and then convert that report
to a pdf and send that.

 

[Frank Situmorang]

Dear Albert:

I have done your suggestion, but why every time I run the report ( main &
sub report) the subreport is printed twice.

Can you help me why this happenned?.

I also want to make besided dates of meeting in the page header also normaly
we have list of attendance and on non attendance. If every time user should
revise the header is not practical more over they are not programmer.

In the page footer, I want to make the closing senctence. How can I make it
if the decisions ( sub report more than 1 page), it goes to the next page and
the closing sentence will be print in the page footer of the last page.

I appreciate your help.

 

[Albert D. Kallal]

Dear Albert:

I have done your suggestion, but why every time I run the report ( main &
sub report) the subreport is printed twice.

There is no reason the sub-report should print two times. Try deleting the
sub-report, and perhaps use the wizard to add the sub-report.

The other important thing to check here is ensure the link master/child
setting for the sub-report is correctly done.

I also want to make besided dates of meeting in the page header also
normaly
we have list of attendance and on non attendance. If every time user
should
revise the header is not practical more over they are not programmer.

You can use bound, or un-bound fields in the current form you are using to
launch the report.

In the report, you can place text boxes that pull values from that form

eg:

=("Total Tour Revenue collected from " & [Forms]![GuiDefRev].[Fromdatet] & "
to " & [Forms]![GuiDefRev].[ToDatet])

or

=([Forms]![GuiDefRev].[Fromdatet])

So, you can use fields and expressions in the report that pull values from
the
form. (and, that can be user text boxes in which they type anything they
want).

You can also place sub-reports in the heading/footing of the report also,
and that might be better depending on how you make/get/set the besided dates
for a meeting (I don't know where this stuff/data comes from, but the above
should give you some ideas here).

In the page footer, I want to make the closing senctence. How can I make
it
if the decisions ( sub report more than 1 page), it goes to the next page
and
the closing sentence will be print in the page footer of the last page.

Simply use the reports footer area in place of the page footing. Use the
above expression idea for a text box, or you can even build a seperate
report that displays this sentence text, and again place it in the reports
footing.