PDA

View Full Version : How to calculate the age in a particular month?



azmen
2014-04-26, 12:52 PM
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

WizzardOfOz
2014-10-14, 07:43 AM
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