 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / August 2005Inserting a MS Access Query as a field using Office 2002
I'm trying to insert an MS Access query into MS Word. The data updates ok and the link works, however the date changes from UK format to US when the merge takes place and I cannot seem to change this. As its coming as an entire query rather than individual fields, there isn't a specific date field within the code that I can amend. All language/version settings etc for Word and Access are for UK and I've tried changing the default version of Access from 2000 to 2002, however this still does not work. In the database itself the data type for the field is set to date and the format is short date (changing the format doesn't make a difference.) It does work when I change the data type to text, however can anyone tell me what I can do to make it work with the data type as date. This is driving me up the wall!! What you describe is a problem in the original release of Word/Office 2002. It was rectified in a Service Pack (SP), at least to the extent that it won't switch your month and day values. What won't happen, however, is getting the dates to come across in any other format than a default short format. The new connection method precludes picking up any formatting from the data base. There are a number of possible approaches (once the SP has been installed). One is to change the connection method back to DDE. Another is to add formatting switches to the merge fields in the Word document. A third would be to set up your query to do the transformation to text on the fly. All these are discussed in the Word 2002/2003 section of my website's mail merge FAQ. -- Cindy > I'm trying to insert an MS Access query into MS Word. The data updates ok and > the link works, however the date changes from UK format to US when the merge [quoted text clipped - 7 lines] > the data type to text, however can anyone tell me what I can do to make it > work with the data type as date. This is driving me up the wall!! |
Reply to this Message |
 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.