Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Frank Situmorang Frank Situmorang is offline
external usenet poster
 
Posts: 2
Default Date keep changing when opened

Hello,

I have a database that can be mereged to word, this is the VBA in my dbase
form:
Private Sub cmdMerge_Click()
Dim strMsg As String

' merge the doc
If IsNull(Me.lstFiles) = False Then

Call RidesMergeWord(strDirPath & Me.lstFiles & ".doc", strDirPath,
strOutDocName)
DoCmd.Close acForm, Me.Name

Else
' Note: This is message string #1.
strMsg = DLookup("MessageString", "[Lookup Message String_Qry]",
"[FormName] = '" & Me.Name & "' AND [StringNumber] = 1")

MsgBox [strMsg], vbExclamation, "Word Merge"

End If

End Sub

In the word template that to be merged, I put date field, so that when I
perform the merge, it has the date created.

When it performed the merge today in Oct 20, 2009, I saved the document in
other name, say " membership transfer of Mr. A", then when I opened the word
of membership transfer of MR. to morrow the date becomes Oct 21, 2009. What
should I do to keep it the same date as when the merged is performed.

I have tried to changed it to created date, but it shows the date when the
template is created although I have saved it in other name, it still shows
the old date.

Thanks for any help.

Frank
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Rich/rerat Rich/rerat is offline
external usenet poster
 
Posts: 93
Default Date keep changing when opened

Frank,
Try inserting the field for the date in the Word document:

{SAVEDATE \*Mergeformat}
OR
{SAVEDATE \@ "MMMM d, yyyy"}

--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News) message rule
Previous Text Snipped to Save Bandwidth When Appropriate


"Frank Situmorang" wrote in
message ...
Hello,

I have a database that can be mereged to word, this is the VBA in my dbase
form:
Private Sub cmdMerge_Click()
Dim strMsg As String

' merge the doc
If IsNull(Me.lstFiles) = False Then

Call RidesMergeWord(strDirPath & Me.lstFiles & ".doc", strDirPath,
strOutDocName)
DoCmd.Close acForm, Me.Name

Else
' Note: This is message string #1.
strMsg = DLookup("MessageString", "[Lookup Message String_Qry]",
"[FormName] = '" & Me.Name & "' AND [StringNumber] = 1")

MsgBox [strMsg], vbExclamation, "Word Merge"

End If

End Sub

In the word template that to be merged, I put date field, so that when I
perform the merge, it has the date created.

When it performed the merge today in Oct 20, 2009, I saved the document in
other name, say " membership transfer of Mr. A", then when I opened the word
of membership transfer of MR. to morrow the date becomes Oct 21, 2009. What
should I do to keep it the same date as when the merged is performed.

I have tried to changed it to created date, but it shows the date when the
template is created although I have saved it in other name, it still shows
the old date.

Thanks for any help.

Frank


  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Date keep changing when opened

Use a Quote field around the Date field eg
{ QUOTE { DATE \@ "d MMMM yyyy" }}
See the section Mail Merge and Date Fields at
http://www.gmayor.com/formatting_word_fields.htm for more detail.

--

Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Frank Situmorang wrote:
Hello,

I have a database that can be mereged to word, this is the VBA in my
dbase form:
Private Sub cmdMerge_Click()
Dim strMsg As String

' merge the doc
If IsNull(Me.lstFiles) = False Then

Call RidesMergeWord(strDirPath & Me.lstFiles & ".doc",
strDirPath, strOutDocName)
DoCmd.Close acForm, Me.Name

Else
' Note: This is message string #1.
strMsg = DLookup("MessageString", "[Lookup Message String_Qry]",
"[FormName] = '" & Me.Name & "' AND [StringNumber] = 1")

MsgBox [strMsg], vbExclamation, "Word Merge"

End If

End Sub

In the word template that to be merged, I put date field, so that
when I perform the merge, it has the date created.

When it performed the merge today in Oct 20, 2009, I saved the
document in other name, say " membership transfer of Mr. A", then
when I opened the word of membership transfer of MR. to morrow the
date becomes Oct 21, 2009. What should I do to keep it the same date
as when the merged is performed.

I have tried to changed it to created date, but it shows the date
when the template is created although I have saved it in other name,
it still shows the old date.

Thanks for any help.

Frank



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I prevent word from changing the date when a doc is opened. chalen Microsoft Word Help 6 August 12th 09 12:08 PM
Can I Insert a date that will automatically update when opened to 1MONTH FROM CURRENT DATE? Dori New Users 2 February 21st 08 11:22 PM
Stop changing the date of a previously saved doc to today's date! mercedesmike Microsoft Word Help 1 May 25th 06 04:27 PM
How to post a date 30 days from the "date opened" in a cell of a . D. Gilio Tables 1 March 24th 06 07:10 AM
Date on letter changes to current date when opened - how to stop. BigSkyG Microsoft Word Help 3 January 13th 05 04:13 PM


All times are GMT +1. The time now is 03:32 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"