Update field values

[James Dingwall]

Hi,

I have an Outlook Form with two tabs, the first is a summary page of the
second which holds more detailed information. Depending on the name of
the user that opens the form, some of the fields on the detailed tab can
be updated. (vbscript to set locked=false and enabled=true) However,
these updates are not replicated to the first tab despite using the same
custom field for the controls. Am I missing something obvious? The
only thing I did notice was that once the controls are enabled the
automatic formatting of dates, numbers etc is not applied to any
adjusted values.

Thanks,
James

 

[Sue Mosher [MVP-Outlook]]

What are the settings on the matching controls on the summary page?

 

[James Dingwall]

What are the settings on the matching controls on the summary page?

On the summary page:

Control->Properties

Settings:

Visible: Yes Resize: No
Enabled: Yes Sunken: Yes
Readonly: Yes Multi-line: No

I did try with readonly = no but this didn't seem to have the necessary
effect.

Thanks,
James

 

[Sue Mosher [MVP-Outlook]]

I can't duplicate the problem here at all using a contact form with Outlook
2003. Maybe you could post the form as an .oft file somewhere.

Also note: The newsgroup interface you are using apparently does not quote
earlier messages in the thread, making your latest message so short on
detail that you risk not getting the answer you're looking for. Please take
the time to quote the original message.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[James Dingwall]

I have an Outlook Form with two tabs, the first is a summary page
of >>>>the second which holds more detailed information. Depending on
the >>>>name of the user that opens the form, some of the fields on the

I can't duplicate the problem here at all using a contact form with
Outlook 2003. Maybe you could post the form as an .oft file somewhere.

Hi Sue,

Thanks for your time. I have posted my form at
http://mercury.cramer.co.uk/oft/Travel Request.oft. I designed it on
Outlook 2003 and we use Exchange 5.5 if this is significant. It may be
helpful if I give a bit more detail on what this form is doing. We have
a Travel Request procedure within our company, and for most people our
travel co-ordinator will decide flights, hotels etc. If that is the
case a previous form will provide the values to populate all the fields
on this form. However in some cases people should be allowed to decide
their own travel details in which case they can unlock the controls on
this form and enter the details on the second tab. I thought that once
the field had been edited on the second tab any changes would
automatically be shown in the first page providing the summary.

Thanks,
James

 

[Sue Mosher [MVP-Outlook]]

So I don't have to deconstruct all the code, is there a shortcut to forcing
the form to unlock?

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[James Dingwall]

 >>>>I have an Outlook Form with two tabs, the first is a summary page

 >>>>of the second which holds more detailed information.  Depending on the 
 >>>>name of the user that opens the form, some of the fields on the
 >>>>detailed tab can be updated.  (vbscript to set locked=false and 
 >>>>enabled=true)  However, these updates are not replicated to the first 
 >>>>tab despite using the same custom field for the controls.  Am I 
 >>>>missing something obvious?  The only thing I did notice was that once 
 >>>>the controls are enabled the automatic formatting of dates, numbers 
 >>>>etc is not applied to any adjusted values.

 >>>What are the settings on the matching controls on the summary page?

 >>On the summary page:
 >>
 >>Control->Properties
 >>
 >>Settings:
 >>
 >>Visible: Yes        Resize: No
 >>Enabled: Yes        Sunken: Yes
 >>Readonly: Yes        Multi-line: No
 >>
 >>I did try with readonly = no but this didn't seem to have the necessary 
 >>effect.

 >I can't duplicate the problem here at all using a contact form with 
 >Outlook 2003. Maybe you could post the form as an .oft file somewhere.

 Hi Sue,

 Thanks for your time.  I have posted my form at 
 http://mercury.cramer.co.uk/oft/Travel Request.oft.  I designed it on 
 Outlook 2003 and we use Exchange 5.5 if this is significant.  It may be 
 helpful if I give a bit more detail on what this form is doing.  We have a 
 Travel Request procedure within our company, and for most people our 
 travel co-ordinator will decide flights, hotels etc.  If that is the case 
 a previous form will provide the values to populate all the fields on this 
 form.  However in some cases people should be allowed to decide their own 
 travel details in which case they can unlock the controls on this form and 
 enter the details on the second tab.  I thought that once the field had 
 been edited on the second tab any changes would automatically be shown in 
 the first page providing the summary.

So I don't have to deconstruct all the code, is there a shortcut to forcing
the form to unlock?

If you modify the function UnlockButton_Click() and just add the line unlock
= True before the if-then-else (line 218) this should enable the unlock
button regardless of who you are.

Regards,
James