A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Sendobject Question

Thread Tools Display Modes
Old May 27th, 2010, 10:00 PM posted to microsoft.public.access.forms
external usenet poster
Posts: 1,597
Default 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
State of Arkansas
Old May 28th, 2010, 02:56 AM posted to microsoft.public.access.forms
Lord Kelvan
external usenet poster
Posts: 637
Default 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.


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

All times are GMT +1. The time now is 11:50 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright ©2004-2020 OfficeFrustration.
The comments are property of their posters.