Warning every 45days

[jamesmooredabest]

I have a program, where, it checks for poeple that haven't visited the tyre factory in oneyear and oneyear and 45 days. So new people come into this catoerory every 45 days. So I need a warning to come with the reminder every 45 days. I have created the reminder, and it works. all I need it to know how to do 45 days.

I have tried using a timer, but not sure how to change the time from millli seconds to day, etc.

I just don't know

Thanks

James

 

[phuque2]

If I understand your question.

I think what you need to do is calculate the total mills in 45 days then do the math... Something like 3,888,000,000 ms per 45 days

HTH

 

[johnwm]

I'm sure you haven't forgotten that maximum duration for a timer control is 65535 mS or about 1 minute. Do a search for Timer in this forum and you'll come up with several alternative options.

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

 

[shannanl]

You could just write the date they came into the shop as a field in the database and check it every day. You could use something like:

If Date_field <= date - 410 then
msgbox("This person is over 1 year and 45 days!")
end if

Shannan