![]() |
| 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. |
|
|||||||
| Tags: company, date, default, end, fields, start, wrong |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
I have created a custom Journal Form - Page 2. I have added the field End
Date - but it defaults to the date the form was created - as does the start date. I have also added the field "company" from the journal field picker - it also defaults to the date the field was added to the form,,,,,,why is this. (I know that this field is not related to contacts-I need to it record which Group did the work - and I'd like it to default to a particular text) The form was designed to be just like the default main page - but to include the end date so that the duration would be calculated. Thank you! |
| Ads |
|
#2
|
|||
|
|||
|
You can put code in the form's Item_Open event handler to set start to right now:
Function Item_Open() If Item.Size = 0 Then Item.Start = Now() Item.End = Now() End If End Function You also could use a formula on each date field's control to accomplish the same thing. I don't know why the Company field would be playing games, but make sure you haven't set an initial value for it. -- 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 "JRO Mtn Group" wrote in message ... I have created a custom Journal Form - Page 2. I have added the field End Date - but it defaults to the date the form was created - as does the start date. I have also added the field "company" from the journal field picker - it also defaults to the date the field was added to the form,,,,,,why is this. (I know that this field is not related to contacts-I need to it record which Group did the work - and I'd like it to default to a particular text) The form was designed to be just like the default main page - but to include the end date so that the duration would be calculated. Thank you! |
|
#3
|
|||
|
|||
|
I'm not very experienced - how do I put a formula in the control- for the
date fields? I tried assigning the company field to a default text value but that didn't work either. I appreciate your help "Sue Mosher [MVP-Outlook]" wrote: You can put code in the form's Item_Open event handler to set start to right now: Function Item_Open() If Item.Size = 0 Then Item.Start = Now() Item.End = Now() End If End Function You also could use a formula on each date field's control to accomplish the same thing. I don't know why the Company field would be playing games, but make sure you haven't set an initial value for it. -- 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 "JRO Mtn Group" wrote in message ... I have created a custom Journal Form - Page 2. I have added the field End Date - but it defaults to the date the form was created - as does the start date. I have also added the field "company" from the journal field picker - it also defaults to the date the field was added to the form,,,,,,why is this. (I know that this field is not related to contacts-I need to it record which Group did the work - and I'd like it to default to a particular text) The form was designed to be just like the default main page - but to include the end date so that the duration would be calculated. Thank you! |
|
#4
|
|||
|
|||
|
Open the form in design mode. Drag the desired field to a custom page. Bring up the PRoperties dialog for the field and switch to the Value tab. Under "Initial Value," enter Now as the formula.
-- 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 "JRO Mtn Group" wrote in message ... I'm not very experienced - how do I put a formula in the control- for the date fields? I tried assigning the company field to a default text value but that didn't work either. I appreciate your help "Sue Mosher [MVP-Outlook]" wrote: You can put code in the form's Item_Open event handler to set start to right now: Function Item_Open() If Item.Size = 0 Then Item.Start = Now() Item.End = Now() End If End Function You also could use a formula on each date field's control to accomplish the same thing. I don't know why the Company field would be playing games, but make sure you haven't set an initial value for it. "JRO Mtn Group" wrote in message ... I have created a custom Journal Form - Page 2. I have added the field End Date - but it defaults to the date the form was created - as does the start date. I have also added the field "company" from the journal field picker - it also defaults to the date the field was added to the form,,,,,,why is this. (I know that this field is not related to contacts-I need to it record which Group did the work - and I'd like it to default to a particular text) The form was designed to be just like the default main page - but to include the end date so that the duration would be calculated. Thank you! |
|
#5
|
|||
|
|||
|
I Got it!! - Thanks. I got the initial value in the company field to work by
putting quotes around it - yippee "Sue Mosher [MVP-Outlook]" wrote: Open the form in design mode. Drag the desired field to a custom page. Bring up the PRoperties dialog for the field and switch to the Value tab. Under "Initial Value," enter Now as the formula. -- 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 "JRO Mtn Group" wrote in message ... I'm not very experienced - how do I put a formula in the control- for the date fields? I tried assigning the company field to a default text value but that didn't work either. I appreciate your help "Sue Mosher [MVP-Outlook]" wrote: You can put code in the form's Item_Open event handler to set start to right now: Function Item_Open() If Item.Size = 0 Then Item.Start = Now() Item.End = Now() End If End Function You also could use a formula on each date field's control to accomplish the same thing. I don't know why the Company field would be playing games, but make sure you haven't set an initial value for it. "JRO Mtn Group" wrote in message ... I have created a custom Journal Form - Page 2. I have added the field End Date - but it defaults to the date the form was created - as does the start date. I have also added the field "company" from the journal field picker - it also defaults to the date the field was added to the form,,,,,,why is this. (I know that this field is not related to contacts-I need to it record which Group did the work - and I'd like it to default to a particular text) The form was designed to be just like the default main page - but to include the end date so that the duration would be calculated. Thank you! |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Resend: wrong default date when creating appointment | Xavier | Outlook - Calandaring | 6 | July 18th 06 05:21 PM |
| Calendar appointments have no start and end time | Dean | Outlook - Calandaring | 0 | June 30th 06 11:58 AM |
| Outlook task start/end date should be viewable on Calendar | Dsadam | Outlook - Calandaring | 1 | April 29th 06 02:38 AM |
| wrong default date when creating meeting in shared calendar | Xavier | Outlook - Calandaring | 1 | April 11th 06 06:58 PM |
| date fields - link the calander pop-up to a custom date field | Tom | Outlook - Using Forms | 0 | January 23rd 06 10:13 PM |