Search results

I would like to change the colour of field on a form if the date in that field is later than the date in another field. Any ideas? Thanks :confused:

I have a split data base and want the front ends to close after a period of time (I think you can undetstand why). Any help on this would be really apprecited; Thanks :D

I am a fairly proficient user of MS Access, but am having trouble creating a one to many relationship between two tables, which I thought would be straight forward. I want a table listing members of staff with their ID number. The next table will have an entry for each time they take sick leave...

Basically I am working my through my data base trying to enter as little data manually where possible. I now want to update one field (what I type into it is irrelevant) but if this field is updated, it means quite a few others become Not Applicable and I would like that to be populated once I...

I have added the following to the control source in an unbound text box on a form to bring up a persons age: =DateDiff("yyyy",[Date_of_Birth],Date()) However what it brings up is the current year of age, in other words if the date of birth field showed 01/12/2012, then i get a return of 1...

I recently posted a question which was answered wonderfully. I wanted to update FieldA and then have FieldB autofill with a specific phrase. This was the result: Private Sub FieldA_AfterUpdate() Select Case Me.FieldA Case Is = "Astro" Me.FieldB = "06" Case Is = "EPP" Me.FieldB = "17" Case Is =...