Recent content by Mayanja_N

I am just too new to coding access, but where excatly do I insert the code to calculate the age if I have DOB column and a new and empty column of age Thanks

@harrison, i used yo code and i was not successful. it says 'compile error : method or data member not found' Private Sub combo_priorart_AfterUpdate() Select Case Me.priorART Case "No" Me.PEP.Enabled = False Me.PMTCT.Enabled = False Case "Yes" Me.PEP.Enabled = True Me.PMTCT.Enabled = True...

Thanks John, it worked for the text box 'age', but i also have a combo box Prior ART which has values 'Yes, No and unknown'. When either No or Unknown is selected, the next fields are supposed to be grayed i.e PMTCT and PEP which are also combo boxes with the same 3 options. This is the error...

Am using access 2007 to develop a database. I need to gray out fields in the same form and in different forms depending on the registration form First, on the registration form, i have a field 'age', if age is less than 5 years, i have to gray out fields like 'occupation', 'martial status' and...

Am building a clinic database using access 2007 which will be used in 5 different centers, on the registration form, there is a field that caputers the name of the health center first, then the patient ID comes next. Is it possible to select a name of the health center and an input mask...