Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / July 2006

Tip: Looking for answers? Try searching our database.

Access checkboxes to Word merge not working

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
leeann - 10 Jul 2006 21:09 GMT
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
Peter Jamieson - 11 Jul 2006 09:34 GMT
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

>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.
[quoted text clipped - 23 lines]
> stuff
> from Word and Access 2000 to 2003.  Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.