Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Access checkboxes to Word merge not working
I have an Access 2000 database that is the source for Word 2000 mailmerge.
Recently my computer was upgraded to Windows XP, running Office 2003. Most everything appears to still work (shock and awe), except for the checkboxes. I have a bunch of if/then/else statements that put statements into my document when the box is checked. One reads: { IF { MERGEFIELD Option1 ] 0 "30/60 Rating Plan with the Ultra Preferred discount." "" }{ IF { MERGEFIELD Option2] 0 "30/60 Rating Plan with the Conviction Free discount. " "" }{ IF { MERGEFIELD Option3] 0 "30/60 Rating Plan." "" } So this worked just fine, in that the statements in quotes would show up in my document if and only if the corresponding checkbox in Access was checked. Now, running under Offices 2003, the above statements give me what is in the quotes, whether or not the checkboxes in Access are checked. I've attempted to change the to greater than, less than, equal to, etc., while changing the 0 to 0 or -1 in various combinations, but either I get always get the sentences in quotes, or never do. A solution would be wonderful, as would any other tips at moving this stuff from Word and Access 2000 to 2003. Thanks |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Access checkboxes to Word merge not working
In Word XP/2003 the default connection method for connecting to Access
changed from DDE to OLEDB. If you use the default method, YesNo fields return "True" and "False" rather than numeric results. You rally have two options: either change your IF fields to correspond to the new values, or change the connection method by checking Word Tools|Options|General|Confirm conversions at open and going through the connection process again. The full table of YesNo results for each connection method is: Method Yes value No value DDE 0 -1 ODBC 0 1 OLEDB True False Peter Jamieson "leeann" u23960@uwe wrote in message news:630d701c8a3f7@uwe... I have an Access 2000 database that is the source for Word 2000 mailmerge. Recently my computer was upgraded to Windows XP, running Office 2003. Most everything appears to still work (shock and awe), except for the checkboxes. I have a bunch of if/then/else statements that put statements into my document when the box is checked. One reads: { IF { MERGEFIELD Option1 ] 0 "30/60 Rating Plan with the Ultra Preferred discount." "" }{ IF { MERGEFIELD Option2] 0 "30/60 Rating Plan with the Conviction Free discount. " "" }{ IF { MERGEFIELD Option3] 0 "30/60 Rating Plan." "" } So this worked just fine, in that the statements in quotes would show up in my document if and only if the corresponding checkbox in Access was checked. Now, running under Offices 2003, the above statements give me what is in the quotes, whether or not the checkboxes in Access are checked. I've attempted to change the to greater than, less than, equal to, etc., while changing the 0 to 0 or -1 in various combinations, but either I get always get the sentences in quotes, or never do. A solution would be wonderful, as would any other tips at moving this stuff from Word and Access 2000 to 2003. Thanks |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 97 in Windows XP to maintain formatting | Microsoft Word Help | |||
Change paper size; Word changes to invalid margins | New Users | |||
After merge I need to see the letters under the prompt box to edit | Mailmerge | |||
glossary macro in Word? | Microsoft Word Help | |||
In Word, how can I see all files (*.*) in "save as"? | New Users |