Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook - Using Forms (http://www.outlookbanter.com/outlook-using-forms/)
-   -   Outlook form (http://www.outlookbanter.com/outlook-using-forms/5636-outlook-form.html)

Mike February 20th 06 05:35 PM

Outlook form
 
I am using the "NOW" function in a form that automatically dates a form when
posted.
This has worked fine for years but in Outlook 2003 when you view the posted
form it changes the stored value on the form to the current date and time,
basically it is recalculating the form. What can be done to prevent this
filed from changing.

Sue Mosher [MVP-Outlook] February 20th 06 07:34 PM

Outlook form
 
Show how you're using the Now() function in your form.

--
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


"Mike" wrote in message ...
I am using the "NOW" function in a form that automatically dates a form when
posted.
This has worked fine for years but in Outlook 2003 when you view the posted
form it changes the stored value on the form to the current date and time,
basically it is recalculating the form. What can be done to prevent this
filed from changing.


Mike February 20th 06 07:49 PM

Outlook form
 
Using a label on the form, label contents are populated when new form is
created.

Set the Intial value of this field to: Now()
Calculate this formula when I compose a new form





"Sue Mosher [MVP-Outlook]" wrote:

Show how you're using the Now() function in your form.

--
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


"Mike" wrote in message ...
I am using the "NOW" function in a form that automatically dates a form when
posted.
This has worked fine for years but in Outlook 2003 when you view the posted
form it changes the stored value on the form to the current date and time,
basically it is recalculating the form. What can be done to prevent this
filed from changing.



Sue Mosher [MVP-Outlook] February 20th 06 08:22 PM

Outlook form
 
Check the other setting you didn't mention -- whether it's set to calculate the formula automatically or only when you create a new form [item].

--
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


"Mike" wrote in message ...
Using a label on the form, label contents are populated when new form is
created.

Set the Intial value of this field to: Now()
Calculate this formula when I compose a new form


"Sue Mosher [MVP-Outlook]" wrote:

Show how you're using the Now() function in your form.



"Mike" wrote in message ...
I am using the "NOW" function in a form that automatically dates a form when
posted.
This has worked fine for years but in Outlook 2003 when you view the posted
form it changes the stored value on the form to the current date and time,
basically it is recalculating the form. What can be done to prevent this
filed from changing.



Mike February 20th 06 09:04 PM

Outlook form
 
Only when I create a new form.
I emailed you a screenshot

"Sue Mosher [MVP-Outlook]" wrote:

Check the other setting you didn't mention -- whether it's set to calculate the formula automatically or only when you create a new form [item].

--
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


"Mike" wrote in message ...
Using a label on the form, label contents are populated when new form is
created.

Set the Intial value of this field to: Now()
Calculate this formula when I compose a new form


"Sue Mosher [MVP-Outlook]" wrote:

Show how you're using the Now() function in your form.



"Mike" wrote in message ...
I am using the "NOW" function in a form that automatically dates a form when
posted.
This has worked fine for years but in Outlook 2003 when you view the posted
form it changes the stored value on the form to the current date and time,
basically it is recalculating the form. What can be done to prevent this
filed from changing.



Sue Mosher [MVP-Outlook] March 7th 06 02:33 PM

Outlook form
 
Could you post your screenshot on a web site somewhere please?

--
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


"Mike" wrote in message ...
Only when I create a new form.
I emailed you a screenshot

"Sue Mosher [MVP-Outlook]" wrote:

Check the other setting you didn't mention -- whether it's set to calculate the formula automatically or only when you create a new form [item].

"Mike" wrote in message ...
Using a label on the form, label contents are populated when new form is
created.

Set the Intial value of this field to: Now()
Calculate this formula when I compose a new form


"Sue Mosher [MVP-Outlook]" wrote:

Show how you're using the Now() function in your form.



"Mike" wrote in message ...
I am using the "NOW" function in a form that automatically dates a form when
posted.
This has worked fine for years but in Outlook 2003 when you view the posted
form it changes the stored value on the form to the current date and time,
basically it is recalculating the form. What can be done to prevent this
filed from changing.




All times are GMT +1. The time now is 07:12 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com