Search results

I just entered this code (the first one you suggested minus the background change) and it worked!!! Weird things afoot, i must have made an error somewhere first time round... Thanks again Paul! Private Sub Form_Current() If Me.[E-T QualificationExpiryDate] < Date Then Me.[E-T...

it's ok you have been very helpful, and far more patient than I could have expected from anyone ;) I'll figure it out eventually

Now its saying can't find the field 'sFRM Employees-Training'... Does it think this is meant to be a field rather than a form? Unless I've got the name wrong... name seems fine :\

heres my code so far; Private Sub Form_Current() If Me!sFRM Employees-Training.Form![E-T QualificationExpiryDate] < Date Then Me!sFRM Employees-Training.Form![E-T QualificationExpiryDate].SetFocus Me!sFRM Employees-Training.Form![E-T QualificationExpiryDate].ForeColor =...

Im trying now, but when i put in my subform name I get an error 'compile error: expected: Then or GoTo. I have assumed you want me to leave the .form! part in. Thanks for being so patient btw ;)

apologies i didnt see your image (i mistook it for another ad!) the name and control source are both the same in my db. see image

ok.... i'm being a newbie again... what is the control name if not the control source?? is it the part at the very top of the property sheet? (the dropdown box with all the other parts of the form in it) :)

Strange indeed... there's no code with the OnClick, or anything else in the event tab, and the control source is 'E-T QualificationExpiryDate' as it should be... I will try remaking the form and go again. (Edit: that produced the same result :() I don't suppose you know anywhere I can find some...

Hmm Its still only working after I click... this is exactly what was in the code after the first try: Option Compare Database ______________ Private Sub Form_Current() If Me.[E-T QualificationExpiryDate] < Date Then Me.[E-T QualificationExpiryDate].SetFocus Me.[E-T...

Actually, maybe not perfectly... for some reason it only turns red after clicking on it, and then turns everything else red regardless of whether they're < today's date or not :\ Any ideas? (I'm at a loss as usual)

That works perfectly! thank you very much :)

I have a form containing qualification expiry dates for workers, is there any way to make it so the date will turn red if the due date is before the present date?(or just stand out somehow, if turning red isn't possible, I'm not fussy...) I don't need a notification like an email, because...

Just a simple query from me regarding simple database logic, because I'm still an access newbie... The setup - I have three tables containing information on ‘Employees’, ‘Job Roles’ and ‘Qualifications’. ‘Employees’ is the parent table, with many to many relationships to both of the other...

Thanks for the warm welcome Paul ;) you have a good day too!

Hi all, Just wanted to introduce myself, I've been lurking these forums for a while as a guest, so it's about time I signed up for real. My name's Alex (surprise) and I'm still pretty green when it comes to Access and databases, but I'm learning. So hello, nice to meet you, and see you around!