Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    159
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculating Age in Access 2000

    What is the best way to calculate a date in a form. I have a Date of Birth field and would like to also show the age.

    Also, I have a field that is a red flag date. If a person tries to do something before a certain date I would like a message box or warning to pop up. Any ideas? Thanks!!

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculating Age in Access 2000

    Hi Sherri,

    For calcuating age, check out this <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=acc&Number=29686&page=2&vie w=expanded&sb=5#Post29686>post</A>.

    As for flagging a field, there are several ways to go about it. You could certainly use a MsgBox. Another idea is to use a format change instead (i.e. making the offending value turn <font color=red>RED</font color=red>).
    You can use the Conditional Formatting that's built-in to Access 2000 (under the Format menu). Set the condition to:<pre>Field Value is, Greater than (or whatever), [Forms]![YourFormName]![FlagDate].Value</pre>


    Hope this helps <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

Posting Permissions

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