|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 11th, 2009, 07:10 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Next Record IF
I'm attempting to create a Mail Merge document based on an Access query of
student data with a high level 'Parent' with one or multiple 'child' records. I've read up on the NextIF or Next Record IF function but the syntax isn't working. I'm trying to compare an ID of the current record against the ID of the next record and when they are the same, print the next 'child' record. If not, then go to the next page. Any help would be appreciated. 
|
|
#2
September 11th, 2009, 08:37 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Next Record IF
The solution Macropod just mentioned is probably also applicable to your
problem: ------------------ To see how, check out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at: http://www.wopr.com/index.php?showtopic=731107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it. ------------------ Peter Jamieson http://tips.pjmsn.me.uk Visit Londinium at http://www.ralphwatson.tv AGolden wrote: I'm attempting to create a Mail Merge document based on an Access query of student data with a high level 'Parent' with one or multiple 'child' records. I've read up on the NextIF or Next Record IF function but the syntax isn't working. I'm trying to compare an ID of the current record against the ID of the next record and when they are the same, print the next 'child' record. If not, then go to the next page. Any help would be appreciated.
|
|
#3
September 13th, 2009, 01:24 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Next Record IF
This is why I usually don't post on message boards. The tutorial wasn't
helpful since it didn't actually have an example of code that I could use and it gave my PTA laptop a virus. No such thing as an easy answer. "Peter Jamieson" wrote: The solution Macropod just mentioned is probably also applicable to your problem: ------------------ To see how, check out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at: http://www.wopr.com/index.php?showtopic=731107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it. ------------------ Peter Jamieson http://tips.pjmsn.me.uk Visit Londinium at http://www.ralphwatson.tv AGolden wrote: I'm attempting to create a Mail Merge document based on an Access query of student data with a high level 'Parent' with one or multiple 'child' records. I've read up on the NextIF or Next Record IF function but the syntax isn't working. I'm trying to compare an ID of the current record against the ID of the next record and when they are the same, print the next 'child' record. If not, then go to the next page. Any help would be appreciated.
|
|
#4
September 13th, 2009, 01:40 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Next Record IF
If you got a virus, it didn't come from this download - at least not the
copy on my site - and the tutorial includes all the example material you need - which is why the writer suggested reading the instructions first! -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org AGolden wrote: This is why I usually don't post on message boards. The tutorial wasn't helpful since it didn't actually have an example of code that I could use and it gave my PTA laptop a virus. No such thing as an easy answer. "Peter Jamieson" wrote: The solution Macropod just mentioned is probably also applicable to your problem: ------------------ To see how, check out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at: http://www.wopr.com/index.php?showtopic=731107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it. ------------------ Peter Jamieson http://tips.pjmsn.me.uk Visit Londinium at http://www.ralphwatson.tv AGolden wrote: I'm attempting to create a Mail Merge document based on an Access query of student data with a high level 'Parent' with one or multiple 'child' records. I've read up on the NextIF or Next Record IF function but the syntax isn't working. I'm trying to compare an ID of the current record against the ID of the next record and when they are the same, print the next 'child' record. If not, then go to the next page. Any help would be appreciated.
|
|
#5
September 14th, 2009, 12:52 AM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Next Record IF
Hi AGolden,
There are no viruses in the tutorial, so it didn't give your "PTA laptop a virus". Kindly get your facts right. Your claim "The tutorial wasn't helpful since it didn't actually have an example of code that I could use" suggests you either: a) didn't bother to read the tutorial; or b) quite unrealistically expected the extensive generic code there to be tailored to your particular situation. -- Regards macropod [Microsoft MVP - Word] "AGolden" wrote in message ... This is why I usually don't post on message boards. The tutorial wasn't helpful since it didn't actually have an example of code that I could use and it gave my PTA laptop a virus. No such thing as an easy answer. "Peter Jamieson" wrote: The solution Macropod just mentioned is probably also applicable to your problem: ------------------ To see how, check out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at: http://www.wopr.com/index.php?showtopic=731107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it. ------------------ Peter Jamieson http://tips.pjmsn.me.uk Visit Londinium at http://www.ralphwatson.tv AGolden wrote: I'm attempting to create a Mail Merge document based on an Access query of student data with a high level 'Parent' with one or multiple 'child' records. I've read up on the NextIF or Next Record IF function but the syntax isn't working. I'm trying to compare an ID of the current record against the ID of the next record and when they are the same, print the next 'child' record. If not, then go to the next page. Any help would be appreciated.
|
|
#6
September 14th, 2009, 08:38 AM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Next Record IF
No such thing as an easy answer.
Not really, no. In this case the "field language" does not contain the elements necessary to make this kind of thing really easy. However, I don't think you will find a better source of information and examples - if you do, perhaps you could post a link here. Peter Jamieson http://tips.pjmsn.me.uk Visit Londinium at http://www.ralphwatson.tv AGolden wrote: This is why I usually don't post on message boards. The tutorial wasn't helpful since it didn't actually have an example of code that I could use and it gave my PTA laptop a virus. No such thing as an easy answer. "Peter Jamieson" wrote: The solution Macropod just mentioned is probably also applicable to your problem: ------------------ To see how, check out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at: http://www.wopr.com/index.php?showtopic=731107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it. ------------------ Peter Jamieson http://tips.pjmsn.me.uk Visit Londinium at http://www.ralphwatson.tv AGolden wrote: I'm attempting to create a Mail Merge document based on an Access query of student data with a high level 'Parent' with one or multiple 'child' records. I've read up on the NextIF or Next Record IF function but the syntax isn't working. I'm trying to compare an ID of the current record against the ID of the next record and when they are the same, print the next 'child' record. If not, then go to the next page. Any help would be appreciated.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
