nightflight
Registered User.
- Local time
- Today, 19:34
- Joined
- Mar 15, 2011
- Messages
- 24
So i've got some nice buttons that when clicked take the results of qry_certissued and drop them into the appropriate word document,
GroupRecord.doc works fine, because it's just a table, and each new row has a <<next record>> at the start so Word knows to take the next record from Access and it's all OK.
But Certificate.doc is a single page, and with the old (but not so nice as my new database) method, it would use a table in another word document as the merge source, and for each record it found, it would create a new page with each individual person named on the certificate.
With my new database, it's only creating one page, with the first matching record on.
Similarly,
Pocket.doc has 8 small certificates on, each with a <<next record>> at the start of them, and this works fine, unless there are more than 8 people matching. Again, old system it would just create a new page and put the remaining people into the first couple of pocket certificates on the new page. New system just puts the first 8 matching records on and forgets about the remaining ones.
The OnClick() code on the buttons is
(the difference in each case is the last bit before the .doc. the me.cbo_certdatechoose.column(1) picks up the prefix from the combo box and uses it as part of the filename)
On opening the word document, it looks for the merge source qry_certissued (which itself is specified by cbo_certdatechoose)
I don't really understand why GroupRecord.doc finds all (upto) 12 matching records, but certificate.doc and pocket.doc only bother with the first 1 or 8 respectively when the mail merge has been set up the same in each case.
Could someone shine some light on this?
Thanks
GroupRecord.doc works fine, because it's just a table, and each new row has a <<next record>> at the start so Word knows to take the next record from Access and it's all OK.
But Certificate.doc is a single page, and with the old (but not so nice as my new database) method, it would use a table in another word document as the merge source, and for each record it found, it would create a new page with each individual person named on the certificate.
With my new database, it's only creating one page, with the first matching record on.
Similarly,
Pocket.doc has 8 small certificates on, each with a <<next record>> at the start of them, and this works fine, unless there are more than 8 people matching. Again, old system it would just create a new page and put the remaining people into the first couple of pocket certificates on the new page. New system just puts the first 8 matching records on and forgets about the remaining ones.
The OnClick() code on the buttons is
Code:
Private Sub btn_certificate_Click()
Application.FollowHyperlink "<filepath>\" & Me.cbo_certdatechoose.Column(1) & " Certificate.doc"
End Sub
On opening the word document, it looks for the merge source qry_certissued (which itself is specified by cbo_certdatechoose)
I don't really understand why GroupRecord.doc finds all (upto) 12 matching records, but certificate.doc and pocket.doc only bother with the first 1 or 8 respectively when the mail merge has been set up the same in each case.
Could someone shine some light on this?
Thanks