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
|
|||
|
|||
field errors
I have a database that has several felds within it with the Date/Time Format.
the format in the database for all these fields are set to Short date. In the table the data is shown as 13/08/2009 I've created a letter in word and is using the database as the datasource. When I merge the document with my data from the database all the Date/Time fields in the letter show the date as 13/08/09 00:00:00. Please help as I've tried everything to get it to show correctly. |
#2
|
|||
|
|||
field errors
"Twb" wrote: I have a database that has several felds within it with the Date/Time Format. the format in the database for all these fields are set to Short date. In the table the data is shown as 13/08/2009 I've created a letter in word and is using the database as the datasource. When I merge the document with my data from the database all the Date/Time fields in the letter show the date as 13/08/09 00:00:00. Please help as I've tried everything to get it to show correctly. i'm using office 2003 sorry forgot to say. |
#3
|
|||
|
|||
field errors
See the "Date-Time Picture (\@) field switch" section of the "Formatting
Word fields with switches" article on fellow MVP Graham Mayor's website at : http://www.gmayor.com/formatting_word_fields.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Twb" wrote in message ... I have a database that has several felds within it with the Date/Time Format. the format in the database for all these fields are set to Short date. In the table the data is shown as 13/08/2009 I've created a letter in word and is using the database as the datasource. When I merge the document with my data from the database all the Date/Time fields in the letter show the date as 13/08/09 00:00:00. Please help as I've tried everything to get it to show correctly. |
#4
|
|||
|
|||
field errors
Hi Dough,
i tried this but no joy.....on further investgation i've viewed the Mail merge Recipients window in word and it shows all the Date fields entry as 19/07/1965 00:00:00. however in access where the data comes from it is formated as a date field and the only entry in the field is 19/07/1965. "Doug Robbins - Word MVP" wrote: See the "Date-Time Picture (\@) field switch" section of the "Formatting Word fields with switches" article on fellow MVP Graham Mayor's website at : http://www.gmayor.com/formatting_word_fields.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Twb" wrote in message ... I have a database that has several felds within it with the Date/Time Format. the format in the database for all these fields are set to Short date. In the table the data is shown as 13/08/2009 I've created a letter in word and is using the database as the datasource. When I merge the document with my data from the database all the Date/Time fields in the letter show the date as 13/08/09 00:00:00. Please help as I've tried everything to get it to show correctly. |
#5
|
|||
|
|||
field errors
You could use the Format() function in a Query in Access to convert the date
to text, or set the option to Confirm file conversion at open (via ToolsOptions in versions before 2007 or via the Office ButtonWord OptionsAdvanced in 2007) and then when you connect the data source to the mail merge main document, select the DDE option. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Twb" wrote in message ... Hi Dough, i tried this but no joy.....on further investgation i've viewed the Mail merge Recipients window in word and it shows all the Date fields entry as 19/07/1965 00:00:00. however in access where the data comes from it is formated as a date field and the only entry in the field is 19/07/1965. "Doug Robbins - Word MVP" wrote: See the "Date-Time Picture (\@) field switch" section of the "Formatting Word fields with switches" article on fellow MVP Graham Mayor's website at : http://www.gmayor.com/formatting_word_fields.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Twb" wrote in message ... I have a database that has several felds within it with the Date/Time Format. the format in the database for all these fields are set to Short date. In the table the data is shown as 13/08/2009 I've created a letter in word and is using the database as the datasource. When I merge the document with my data from the database all the Date/Time fields in the letter show the date as 13/08/09 00:00:00. Please help as I've tried everything to get it to show correctly. |
Thread Tools | |
Display Modes | |
|
|