Flag up a warning

[bl0u2011]

Hey there

there is a function that I wanted to do on my form but can't think of a way
what I want to do is to show up a flag after 14 days and 28 days of a date with missed appointment being ticked
say there are two fields in the section

AppointmentDate
Missed

Will I be able to do this in access?

Please advice
Cheers
Si

 

[llkhoutx]

Place the follwing code on some event, maybe the OnCurrent or FormOpen
'change missed backcolor on appointdate age
'test oldest date first
if me!appointmentdate >= date() + 28 then
me!missed.backcolor=vbred
elseif nme!appointmentdate >= date() + 14 then
me!missed.backcolor = vbyellow
end if

 

[llkhoutx]

See the attached zipped A2K mdb for a better solution.

 

[bl0u2011]

Version

What version is this access file please?
Si

 

[llkhoutx]

It's Access 2000.

 

[bl0u2011]

I can't open the file as I am using 97 unfortunately,
Any how can I get this done on Access 97?

 

[llkhoutx]

I posted to a similar question here.