Results 1 to 2 of 2

Thread: How to calculate the age in a particular month?

  1. #1

    How to calculate the age in a particular month?

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi, I am making a project using access and I have these problems:

    1) When the birthday entered I want it to show the age (years and months) at the beginning of Fepurary and May.
    And then how to display the age in the form.

    2) I created a combo box that contain other, how to allow the user to edit other when chosen.

    3) I created a multiple forms that are connected to each other, so when filling the first form the user have to assign a unique ID for the person, and proceed to the next form to fill it for the same ID, how to make access display this ID automatically when going to the next form instead of writing it again.

    Thanks in advance

  2. #2
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Excel Version
    Office 365
    1) use date difference to 1 Feb and 1 May
    2) set a text box visible = (Combo1.text = "Other")
    3) relational sub form with a 1:1 relationship

Posting Permissions

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