Sequence of Dates

  • Thread starter Thread starter Lee C. Wertheimer
  • Start date Start date
L

Lee C. Wertheimer

I have a row of three small text boxes. I want to enter the date in the
first box and then in the next two boxes have it advance. So I get Tuesday,
September x... then Wednesday, September x+1 etc...

How can I do that in Word 2002?
 
Hi Lee,
I have a row of three small text boxes. I want to enter the date in the
first box and then in the next two boxes have it advance. So I get Tuesday,
September x... then Wednesday, September x+1 etc...

How can I do that in Word 2002?
Click to expand...
Assuming your "text boxes" are form fields:

You'd basically have two approaches. One is to insert, then modify, a very
complex set of fields in order to do the date calculation. The tool to create
the field set can be downloaded here:

http://www.chriswoodman.co.uk/Delayed Dates.htm

The other option you have would be to use VBA to do the calculation and
insert the value.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan 24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
 
No, they are just text boxes. I suppose I could put form field into the
boxes but is there a way to do that without a Macro? Perhaps I am too old
school, but I tend to think 'virus' whenever I hear 'Macro'

LCW
 
Hi Lee,

That's not old school, it's just false. Thinking 'virus' whenever
you hear 'macro' is like thinking 'imminent death' just because
you drive past a cemetery. This shouldn't even need explaining,
but you can't get a virus from a macro you write yourself, any
more than you can infect yourself with the flu. Whoever placed
that idea in your head is, pardon my fumes, a Grade A moron.

That said, the only ordinary way to cause the contents of one
textbox to affect the contents of another is with a macro.
By far the most logical setup for what you describe is indeed
formfields. Are you leaving out some key point here? Have you
actually seen what you're describing?

--
Mark Tangard <[email protected]>, Microsoft Word MVP
Please reply only to the newsgroup, not by private email.
Note well: MVPs do not work for Microsoft.
"Life is nothing if you're not obsessed." --John Waters
 
Hi Lee,
No, they are just text boxes. I suppose I could put form field into the
boxes but is there a way to do that without a Macro? Perhaps I am too old
school, but I tend to think 'virus' whenever I hear 'Macro'
Click to expand...
I'm VERY old school, from before anyone ever thought about macro viruses
:-)

You shouldn't use text boxes, then. A table would be better, or perhaps
frames (or a combination of both). Fields don't work well in text boxes...

And then you need to BOOKMARK the information and refer to the bookmark in
the complex set of fields the tool I pointed you at generates. You'll have
to use this macro, but you only need to run it once for each date you want
to calculate - it generates the complex field code.

Once you've inserted the field codes that increment the date, you
substitute a REF field to the bookmark with the "base date" in the field
codes, so that the calculation is done on it. Alt+F9 toggles field codes /
field result display.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan 24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
 
Back
Top