Prev: Requery Combo box in popup form
Next: Opening a sub-form from a command button
From: golfinray on 27 May 2010 17:00
I am trying to use a datepicker to set number of days until an email reminder
is sent. I am a little over my head. I am trying to use something like:
If me.date_picker.value <> now() then
dateadd("d"(me.datepicker.value ?????
docmd.sendobject .......
I don't know how to set this up with dateadd or something else if the user
wants an email reminder, say, 30 days from now and they select that date on
the datepicker. Am I just way off track? Thanks so much!!!
--
Milton Purdy
ACCESS
State of Arkansas
From: Lord Kelvan on 27 May 2010 21:56
Ok first point date time pickers can be hard to control, as they are
activex controls

I would ask yourself if you need to use it or will a text box suffice.

Anyways if a user needs to select the date of their reminder then why
would you need to use dateadd(). Or does the user say I want a
reminder in 30 days. Cannot they just select the value then you save
that value in the database to be use at the later date.

As a note I have found the Microsoft datetimepicker control doesn’t
work being bound. I have found if you bind it when you open the form
again it resets the value in the database to when you created the
control rather than displaying the value in the database so just take
note and be careful.

If I have got the wrong end of the stick please explain again.

Regards
Kelvan
 | 
Pages: 1
Prev: Requery Combo box in popup form
Next: Opening a sub-form from a command button