![]() |
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 | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
Hi, I've got a problem with my form auto complete textbox. I've got a textbox
named "FinishDate" and On the load of my form I want to put the initial value of this field with date of today + 14 days. I try it with DateAdd function but I'm not sure it is working well or I think I don't write the good parameters on it. Thanks for your help! -- Josianne |
Ads |
#2
|
|||
|
|||
![]()
DateAdd("d", 14, Date)
-- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Josianne" wrote in message ... Hi, I've got a problem with my form auto complete textbox. I've got a textbox named "FinishDate" and On the load of my form I want to put the initial value of this field with date of today + 14 days. I try it with DateAdd function but I'm not sure it is working well or I think I don't write the good parameters on it. Thanks for your help! -- Josianne |
#3
|
|||
|
|||
![]()
What is the meaning of the "d" the 14 and the date
because I try dateadd("d",14,date) and dateadd("d",14,TODAY) and my fiel on startup is "Néant". -- Josianne "Sue Mosher [MVP-Outlook]" wrote: DateAdd("d", 14, Date) -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Josianne" wrote in message ... Hi, I've got a problem with my form auto complete textbox. I've got a textbox named "FinishDate" and On the load of my form I want to put the initial value of this field with date of today + 14 days. I try it with DateAdd function but I'm not sure it is working well or I think I don't write the good parameters on it. Thanks for your help! -- Josianne |
#4
|
|||
|
|||
![]()
"d" is the unit of time measurement being added.
Date() is a function that returns today's date. You can learn all about the DateAdd or Date function by typing it into any VBA window, selecting that text and pressing F1. Is your textbox bound to an Outlook date/time property? -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Josianne" wrote in message ... What is the meaning of the "d" the 14 and the date because I try dateadd("d",14,date) and dateadd("d",14,TODAY) and my fiel on startup is "Néant". -- Josianne "Sue Mosher [MVP-Outlook]" wrote: DateAdd("d", 14, Date) -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Josianne" wrote in message ... Hi, I've got a problem with my form auto complete textbox. I've got a textbox named "FinishDate" and On the load of my form I want to put the initial value of this field with date of today + 14 days. I try it with DateAdd function but I'm not sure it is working well or I think I don't write the good parameters on it. Thanks for your help! -- Josianne |
#5
|
|||
|
|||
![]()
Is your textbox bound to an Outlook date/time property?
Yes, I already do it -- Josianne "Sue Mosher [MVP-Outlook]" wrote: "d" is the unit of time measurement being added. Date() is a function that returns today's date. You can learn all about the DateAdd or Date function by typing it into any VBA window, selecting that text and pressing F1. Is your textbox bound to an Outlook date/time property? -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Josianne" wrote in message ... What is the meaning of the "d" the 14 and the date because I try dateadd("d",14,date) and dateadd("d",14,TODAY) and my fiel on startup is "Néant". -- Josianne "Sue Mosher [MVP-Outlook]" wrote: DateAdd("d", 14, Date) -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Josianne" wrote in message ... Hi, I've got a problem with my form auto complete textbox. I've got a textbox named "FinishDate" and On the load of my form I want to put the initial value of this field with date of today + 14 days. I try it with DateAdd function but I'm not sure it is working well or I think I don't write the good parameters on it. Thanks for your help! -- Josianne |
#6
|
|||
|
|||
![]()
Thanks a lot, I've found dateadd("d",14,NOW).
I try it before with TODAY or DATE and it don't work because I've got a french version of outlook on this computer. Thanks again problem resolve! -- Josianne "Josianne" wrote: Hi, I've got a problem with my form auto complete textbox. I've got a textbox named "FinishDate" and On the load of my form I want to put the initial value of this field with date of today + 14 days. I try it with DateAdd function but I'm not sure it is working well or I think I don't write the good parameters on it. Thanks for your help! -- Josianne |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copy 1 Text Field into another on Form, DateAdd and macros | Michael Anderson | Outlook and VBA | 9 | January 18th 06 11:37 PM |
CustomPropertyChange, DateAdd and Click_event trouble | Michael Anderson | Outlook and VBA | 1 | January 18th 06 05:18 PM |