Customizing fields in Outlook forms

Status
Not open for further replies.
J

Jewell Dinneen

I have created a custom task form in Outlook 2003 (SP3), for work. Using given properties functionality, I have created four checkboxes that, when checked, invoke the current date in a nearby text box. This is very desirable, as it allows me to record the date through the Task Window without having to open the individual task.

The problem is that when one updates, they all update. For example, when I send a document out, I check a box and the current date fills a correlated text box. When the document comes back approved a few days later, I check a second box, and that date fills a second text box, but the first date changes, too!

I think this is happening bcause I have used the Value tab of the properties field to insert the formula, and I have set them all to "update automatically".

I have tried a lot of things, even writing code, but I really need more guidance. Can anyone help?

Get Full Name of current Thread Principal

http://www.eggheadcafe.com/tutorial...de-b06461d54654/get-full-name-of-current.aspx
 
S

Sue Mosher [MVP]

To store static dates that don't update every time the item is opened, you

can't use simple formulas. You need to put code behind the form. For your

scenario, I'd use the CustomPropertyChange event to update the date fields

whenever the check box fields change. See

http://www.outlookcode.com/article.aspx?ID=38

Sue Mosher

<Jewell Dinneen> wrote in message

news:2009121894727jewelldinneen@yahoo.com...
> I have created a custom task form in Outlook 2003 (SP3), for work. Using
> given properties functionality, I have created four checkboxes that, when
> checked, invoke the current date in a nearby text box. This is very
> desirable, as it allows me to record the date through the Task Window
> without having to open the individual task.

> The problem is that when one updates, they all update. For example, when
> I send a document out, I check a box and the current date fills a
> correlated text box. When the document comes back approved a few days
> later, I check a second box, and that date fills a second text box, but
> the first date changes, too!

> I think this is happening bcause I have used the Value tab of the
> properties field to insert the formula, and I have set them all to "update
> automatically".

> I have tried a lot of things, even writing code, but I really need more
> guidance. Can anyone help?

> Get Full Name of current Thread Principal
> http://www.eggheadcafe.com/tutorial...de-b06461d54654/get-full-name-of-current.aspx
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
T Customizing Fields in Distribution Lists Using Outlook 1
J Customizing Outlook 2010 with Email Address Using Outlook 2
H Customizing "Send to" Attachment Script Outlook VBA and Custom Forms 5
S Customizing Connected Services in Office 2013 Pro Plus (O365) Using Outlook 1
J Customizing PST error message in Outlook Using Outlook 8
N Starting out with BCM - Customizing contact records BCM (Business Contact Manager) 1
S Customizing an Outlook 2010 Email Form Exchange Server Administration 1
X BCM: Customizing Marketing Forms BCM (Business Contact Manager) 2
D Customizing Tasks form in Outlook 2007 Using Outlook 4
J Customizing Contact Form Using Outlook 6
P Customizing Business Cards in BCM BCM (Business Contact Manager) 0
R customizing bcm for Brazil... issues BCM (Business Contact Manager) 1
D Customizing BCM BCM (Business Contact Manager) 2
R Real Estate Customizing BCM (Business Contact Manager) 2
G Other users can't see P.2 with custom fields in Form Outlook VBA and Custom Forms 0
S Reference Custom Fields with VBA Outlook VBA and Custom Forms 2
J Outlook 2013 Change color of text in data fields of contacts in Outlook 2013? Using Outlook 3
S User Defined Fields adding new value (2) Using Outlook 0
M vCard does not have user-defined fields from my custom contact form (365) Using Outlook 1
T Outlook 2010 Correct way to map multiple contact fields Using Outlook 4
F Appointment Show All Fields Using Outlook 1
F MAPI, User Defined Fields and perspective after 20 years Outlook VBA and Custom Forms 0
B Outlook Business Contact Manager with SQL to Excel, User Defined Fields in BCM don't sync in SQL. Can I use VBA code to copy 1 field to another? BCM (Business Contact Manager) 0
E To convert imported data to custom fields in Task list Outlook VBA and Custom Forms 1
cimbian street address fields contain 0A0D Outlook VBA and Custom Forms 2
S Custom user fields in received messages Outlook VBA and Custom Forms 1
J Backup .OST - Custom Contact Forms, Defined Fields, Notes Using Outlook 1
P Outlook custom fields "events" Using Outlook 0
J Add Fillable Fields to Existing Template Outlook VBA and Custom Forms 1
B Customize contact record phone fields Using Outlook 2
G Addition of 2 fields based on checkboc true or false Outlook VBA and Custom Forms 2
M Multiple User Defined Fields that can be added, changed, updated using VBA and user form Outlook VBA and Custom Forms 0
R User Defined Fields adding new value Using Outlook 3
S VBA with User Defined fields Outlook VBA and Custom Forms 9
Diane Poremsky Add Attachments and Set Email Fields During a Mail Merge New Slipstick.com Articles 0
O VBA to extract email (fields and body) to Excel Outlook VBA and Custom Forms 14
H How to export *all* fields from Outlook Using Outlook 2
L Change the displayed fields in calendar view Using Outlook 1
N Export Outlook custom forms fields to excel Outlook VBA and Custom Forms 1
M Recurrence and custom fields Outlook VBA and Custom Forms 0
Diane Poremsky Hiding Global Address Book Fields New Slipstick.com Articles 0
M Map Outlook user defined fields onto a Sharepoint list ??? Outlook VBA and Custom Forms 1
L Copy email body fields to excel Using Outlook 0
Diane Poremsky Add attachments and set email fields during a mail merge to email New Slipstick.com Articles 0
H User designed fields not usable in contact folder views Using Outlook 0
L Outlook 2007 Search All Fields in Contacts Using Outlook 1
N How to retrieve user defined fields values to bcm form. Using Outlook 2
N How to disable user defined fields in BCM forms Using Outlook 2
M Adding fields to Task in Outlook Home and Business 2010 Outlook VBA and Custom Forms 7
W Meeting printing background fields Using Outlook 0
Similar threads


















































Top