 |
 | 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 / January 2008Access Query to mailmerge US Date
Mailmerge to Access brings US date format but I have got the format showing In UK format in Word using the field switch however when I run a query the date still has to be entered in US format. Is there any way to change this so that my clients can enter the date in UK dd/MM/yyyy format -- Thanks in advance for your time > when I run a query the > date still has to be entered in US format Do you mean that a. you are connecting to an Access parameter query, and the users are typing a date into the box that Access pops up? or b. they are specifying out query options in Word's Mail Merge Recipients dialog box, or the query options dialog box? or c. something else? (And which version of Word/Access?) (I'm not sure it makes any difference whether it's (a) or (b) but it would be helpful to know for the purposes of investigation)  SignaturePeter Jamieson http://tips.pjmsn.me.uk > Mailmerge to Access brings US date format but I have got the format > showing [quoted text clipped - 4 lines] > -- > Thanks in advance for your time Sorry for not clarifying the issue, I had an update from my client. They are using Mail Merge Recipient button, find "in this field" - a date field. Although the dates appear in UK form in the column, they have to type the US version for it to find records containing the correct dates. SignatureThanks for replying so quick. ______ > > when I run a query the > > date still has to be entered in US format [quoted text clipped - 18 lines] > > -- > > Thanks in advance for your time I am reasonably sure that you can only do that if the date is coming from the Access database in UK format - Word is trying to match the text it sees before it applies any formatting. You can /probably/ achieve that by using an Access query that does something like SELECT *, format(mydate,'DD/MM/YYYY') As [mynewdate] FROM mytable in Access, if you are in a position to add queries to their database. If not, you could consider issuing the query from VBA or creating a query in your own MDB that links to their table/query. SignaturePeter Jamieson http://tips.pjmsn.me.uk > Sorry for not clarifying the issue, I had an update from my client. They > are [quoted text clipped - 28 lines] >> > -- >> > Thanks in advance for your time Thanks I'll try that SignatureHope this helps :-) > I am reasonably sure that you can only do that if the date is coming from > the Access database in UK format - Word is trying to match the text it sees [quoted text clipped - 39 lines] > >> > -- > >> > Thanks in advance for your time Just in case it isn't obvious: Since the match is a text match, the users will need to know the specific format to type - if you use DD/MM/YYYY, they need to use 01/02/2008, not 1/2/2008, and so on. SignaturePeter Jamieson http://tips.pjmsn.me.uk > Thanks I'll try that > [quoted text clipped - 48 lines] >> >> > -- >> >> > Thanks in advance for your time
|
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.