Checkbox and multiple pages

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Aggie G - 20 Mar 2008 00:02 GMT

I have a custom form in Outlook and I need help. This is what I want. If the
'Policy/Procedure' checkbox is checked, the form will require the user to
complete specific fields on a different page (Procedure Details) of the
Outlook custom form. The validation formulas in the fields on the procedures
detail page should only apply when the box is checked.

I think this would require VBA, but I am not experienced enough to do this.
Please help.

Reply to this Message

Eric Legault [MVP - Outlook] - 20 Mar 2008 16:30 GMT

You can monitor the CustomPropertyChange event and check the Name parameter
to make sure it equals the field you have bound to the checkbox. If it is
true, call Inspector.ShowFormPage("PageName") to display your page.

However, you can't toggle any validation checks for a control with code.
You'd have to code the validation logic yourself and implement it in the
CustomPropertyChange event, setting Cancel=True if the logic test fails with
the current value.

Signature

Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/

> I have a custom form in Outlook and I need help. This is what I want. If the
> 'Policy/Procedure' checkbox is checked, the form will require the user to
[quoted text clipped - 4 lines]
> I think this would require VBA, but I am not experienced enough to do this.
> Please help.

Reply to this Message

Aggie G - 20 Mar 2008 18:28 GMT

Ok this sounds like I need to write code to bound the checkbox to the
specific page; problem is I don't write code. Can you provide me with code to
do this :)?

> You can monitor the CustomPropertyChange event and check the Name parameter
> to make sure it equals the field you have bound to the checkbox. If it is
[quoted text clipped - 13 lines]
> > I think this would require VBA, but I am not experienced enough to do this.
> > Please help.

Reply to this Message

elegaultZZZ@REMOVEZZZmvps.org - 20 Mar 2008 22:27 GMT

If it's your job to create custom Outlook forms, it is in your best
interests to learn the basics of Outlook coding! There are plenty of
resources out there - it's best to start with http://www.outlookcode.com.
If you can start, I'll assist you with specific questions but I don't have
time to code your entire solution - sorry.

Eric

> Ok this sounds like I need to write code to bound the checkbox to the
> specific page; problem is I don't write code. Can you provide me with code
[quoted text clipped - 25 lines]
>> > this.
>> > Please help.

Reply to this Message

Aggie G - 24 Mar 2008 18:40 GMT

Actually it isn't my job to create forms, I do it to make it easier on
myself. If you don't have time to help me, that is fine...I'll try to figure
it out myself!

> If it's your job to create custom Outlook forms, it is in your best
> interests to learn the basics of Outlook coding! There are plenty of
[quoted text clipped - 33 lines]
> >> > this.
> >> > Please help.

Reply to this Message

Sue Mosher [MVP-Outlook] - 25 Mar 2008 20:53 GMT

The checkbox needs to be bound to an Outlook property (call it MyField for purposes of this example). The validation formula for each other field would be:

([MyField] = False) OR ([OtherField] <> "")

Signature

Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

>I have a custom form in Outlook and I need help. This is what I want. If the
> 'Policy/Procedure' checkbox is checked, the form will require the user to
[quoted text clipped - 4 lines]
> I think this would require VBA, but I am not experienced enough to do this.
> Please help.

Reply to this Message

Rate this thread: