If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sendobject Question
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 |
#2
|
|||
|
|||
Sendobject Question
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 |
Thread Tools | |
Display Modes | |
|
|