Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Future Date/Print Date Fields
I'm using Word and Access 2003. I'm trying to replicate an appeal letter. The
reason for mentioning Access 2003 is because I included a Word document as part of an Access report. I do not know to what extent the capabilities of Word may be diminished when using Access 2003. That said I have 2 problems. The first is trying to include in this letter a future date based on the current date. For example current date + 7= 9/13/07. This appears to be a very complicated procedure to implement into Word. So, I thought I would create a control [LastDayStepAMeetingP3] in Access that would give me that information and then insert it into the Word document. I'm having a problem doing that. If it means anything the control course is: =DateAdd("d",+7,[DateAppealedFormalStepAP1]) The next problem I'm having is using the PrintDate field in the same document. When I tested it I got an August 14 date instead of the current date, September 5. I do not want this date to be updated when someone tries to print it again. If for some reason we need to print that specific document again we need it to be the date it was actually printed. Thanks for the help. -- Bob |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Future Date/Print Date Fields
Hi rd
.(donotspam) wrote: I'm using Word and Access 2003. I'm trying to replicate an appeal letter. The reason for mentioning Access 2003 is because I included a Word document as part of an Access report. I do not know to what extent the capabilities of Word may be diminished when using Access 2003. That said I have 2 problems. I'm sure using Access, the capabilities are enhanced instead! :-) The first is trying to include in this letter a future date based on the current date. For example current date + 7= 9/13/07. This appears to be a very complicated procedure to implement into Word. So, I thought I would create a control [LastDayStepAMeetingP3] in Access that would give me that information and then insert it into the Word document. I'm having a problem doing that. If it means anything the control course is: =DateAdd("d",+7,[DateAppealedFormalStepAP1]) You are perfectly right: Word is, after all, a text processor. You can calculate dates in VBA, and you can even do pretty complicated field-based constructs without it. But these are pretty complex. Chris Woodman is the "guru" when it comes to such calculations: Delayed Dates (by Chris Woodman) http://www.chriswoodman.co.uk/Delayed%20Dates.htm But whenever you are controling Word from another application like Access or even Excel, in a mailmerge type situation or not: by all means use the other app to do date calculations! :-) The next problem I'm having is using the PrintDate field in the same document. When I tested it I got an August 14 date instead of the current date, September 5. I do not want this date to be updated when someone tries to print it again. If for some reason we need to print that specific document again we need it to be the date it was actually printed. Well, the PRINTDATE field does just that: after updating, shows you the date of the last printing of this document. If you don't want this, you could lock the field (though that's kind of tricky, because you need to do it after the original print run). Maybe it's safer to create a document variable and put the date in it, then reference the variable in the document. If you don't refer to the date as "print date" in your document, you might as well insert the current days date as normal text during creation of the document (no field -- no need to lock it). HTH Robert -- /"\ ASCII Ribbon Campaign | MS \ / | MVP X Against HTML | for / \ in e-mail & news | Word |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autoformat for future date? Not current date | Microsoft Word Help | |||
Display a future date calculated from todays date | Microsoft Word Help | |||
How to get a date merge field to show a date 60 days in the future | Mailmerge | |||
How to insert future date based on current date plus 14 days | Microsoft Word Help | |||
How do i update a word document date field with a future date | Microsoft Word Help |