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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Converting Word Perfect forms to Word forms | Charles Kenyon | General Discussion | 0 | February 15th, 2006 08:17 PM |
Word 97 in Windows XP to maintain formatting | Charlie''s Word VBA questions | General Discussion | 21 | October 24th, 2005 09:49 PM |
How do I create a Word form like corel WP merge documents? | dlee_at_mmsgov | General Discussion | 2 | October 8th, 2005 06:29 AM |
WORD XP mail-merge FAILS using ACCESS Query | SueMackay | Mailmerge | 1 | November 23rd, 2004 01:03 PM |
Word 2000/2002 - Proper Mail Merge steps for ODBC? | Tony_VBACoder | Mailmerge | 7 | September 2nd, 2004 09:21 PM |