[mso] Re: word question
- From: "All About Office" <webmaster@xxxxxxxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Fri, 28 Apr 2006 22:01:22 +0100
Thanks for that fix Linda, hopefully you will now be able to read this:
You could make a 7 page document with the same form on each page and =
then
use a form field on each page to hold the
date. Set the type for each of these form fields to Date and set the =
format
to dd/MM/yyyy. Set a different bookmark
name on each form field, e.g. date1, date2, date3, etc and use the macro
boxes on the first form field to run the
following macro on exit:
Sub dates()
'
' dates Macro
' Macro created 28/04/2006 by Andrea Jones
'
Dim start As String
start =3D ActiveDocument.FormFields("Date1").Result
ActiveDocument.FormFields("Date2").Result =3D DateAdd("d", 1, start)=20
ActiveDocument.FormFields("Date3").Result =3D DateAdd("d", 2, start)=20
ActiveDocument.FormFields("Date4").Result =3D DateAdd("d", 3, start)=20
ActiveDocument.FormFields("Date5").Result =3D DateAdd("d", 4, start)=20
ActiveDocument.FormFields("Date6").Result =3D DateAdd("d", 5, start)=20
ActiveDocument.FormFields("Date7").Result =3D DateAdd("d", 6, start)=20
End Sub
This macro picks up the date entered in the first date box and then adds =
on
the appropriate number of days and puts those values in the form fields =
on
the other pages.
Andrea Jones
www.allaboutoffice.co.uk
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On =
Behalf
Of John Walsh
Sent: 28 April 2006 01:25
To: mso@xxxxxxxxxxxxx
Subject: [mso] word question
Hi I would like to have a word form up the date the date by 1 each time =
I
printed it.
EXAMPLE:
Date: Monday 4/1/2006
Please check on John Doe every hour and sign the form.
This is in a table.
Time Gomments Sign
8PM
9PM
10PN
The next time I print this form I want it to update the date to read
4/2/2006. I print about 7 days at a time on the previous friday . I =
hope I
made what I want clear.
Win XP pro word 2003. TIA jonleo
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx =
or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to=20
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the =
quotes)
in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will =
also
allow you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, =
send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an =
invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files: http://www.smartgroups.com/vault/msofiles
*************************************************************
--=20
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.5.1/326 - Release Date: =
27/04/2006
=20
--=20
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.5.1/326 - Release Date: =
27/04/2006
=20
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
- Follow-Ups:
- [mso] Re: word question
- From: Linda F. Johnson
- References:
- [mso] word question
- From: John Walsh
Other related posts:
- » [mso] word question
- » [mso] Re: word question
- » [mso] Re: word question
- » [mso] Re: word question
- » [mso] Re: word question
- » [mso] Re: word question
- [mso] Re: word question
- From: Linda F. Johnson
- [mso] word question
- From: John Walsh