Search results

I have just changed the field to date/time and it now works perfectly. Thanks so much once again.

Oh No! I have just checked through and it is turning red when the date is not greater than the other. Is this because they are not calendar fields?

Thank you Thank you Thank you.

Still no joy. I have double (and triple) checked the Names and Control Source match. I am using Office 2013 which, although I doubt will make a difference for this, just thought it worth a mention. Is the date format anything to do with it?

Thanks for the help. I filled in your code with my field names, but am not getting anything. What have I done wrong: If [Funding_End_Date] > [Project_End_Date] Then Me.Project_End_Date.ForeColor = vbRed Else Me.Project_End_Date.ForeColor = vbBlack End If

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

Please. I did say fairly proficient, so please patronise all you like. If helps, I am not proud:o I will take a look at both suggestions. Thanks for taking the time to get back.

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...

Thanks. It did what I asked, but that turned out not to be what I needed in the end. I'll keep on trying though.

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...

Thanks. That worked a treat!

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...

Thanks Galaxiom - that worked perfectly. It Does Exactly What It Says On The Tin!!!:)

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 =...