Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    16 weeks Hence (Office 97)

    Hi

    Is it possible to use formulas in word fields, I have a field in which the user enters a specific date and I have another field which must show a date 16 week later.
    Is it possible to formulate this in word.

    Thanks in advance

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 16 weeks Hence (Office 97)

    Take a look at macropod's star post <!post=Date Calculations in Word (2.25),249902>Date Calculations in Word (2.25)<!/post>

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: 16 weeks Hence (Office 97)

    Hi Phi

    Sorry it took so long to answer. I looked at the post you suggested but I could not find what I needed.
    I omitted to say that the fields in question on a form, I presume this makes a difference.

    Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 16 weeks Hence (Office 97)

    The field calculations in Macropod's document should do what you want, but they are very complicated. This is because Word is not meant for calculations the way Excel and Access are.

    Do you mean that the user enters the date in a form field that has been placed on the document from the Forms toolbar? (See screenshot)
    Attached Images Attached Images
    • File Type: png x.PNG (1.6 KB, 0 views)

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 16 weeks Hence (Office 97)

    Follow-up to my previous reply: if you do indeed have form fields, you could use an On Exit macro for the form field in which the user enters the date. See the attached demo.

    To test it, unzip and open the document, and enter a date in the first box, then press Tab.

    To see how it works, select Tools | Unprotect Document. Double click the form fields to see how they are set up, and activate the Visual Basic Editor (Alt+F11) to view the macro that sets the date 16 weeks hence.
    Attached Files Attached Files

  6. #6
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: 16 weeks Hence (Office 97)

    Hi Hans

    The attached Demo is absolutley perfect, the macro is just what I need.

    I can't help wondering how you can retain so much knowledge, however I am glad that you can.

    Sorry took so long to reply

    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •