User Input into custom form

[Daniel]

Hi...Pretty much a newbie in Outlook forms design, so any help or pointers
would be appreciated with my question.

1. In my custom form I have 12 fields, with each one representing a
Commission Rate for the given month ex: CR (Jan), CR (Feb),...,CR (Dec)

2. I have also created a 13th field called "AutoFill CR".

I would like the form to: a) Verify if there is a value in the "AutoFill
CR";
-- If YES, then Copy this value to ALL CR fields.
-- If NO, then let the user input individual monthly values in.

So I set the "Initial Value" of the field to the following formula:
IIf( [AutoFill CR (%)] <> 0.00 , [AutoFill CR (%)] , [Jan CR (%)] )

This works great if all I want to do is copy the value from AutoFill to the
monthly CR field, but, it breaks down if you want to type in a value into
the field...because it will not let you input any other data.

any suggestions?

thnx
dan

 

[Hollis Paul [MVP - Outlook]]

Well, you have probably have set it to continusally set the value, instead
of just at opening. Not sure that I remember the available choices just
very well.

Perhaps a better way would be to have a command button, which, when clicked,
will copy the value of the auto-fill field to all the fields if it is
non-zero, or copy the auto-fill value to the fields that are 0, if the
auto-fill fiels is non-zero. You have more flexibility with code behind a
command button, but you do have to write it.

I trust that you have remembered to bind your screen controls to the fields.

Hollis

 

[Daniel]

Hi Hollis,

Thanks for the info, I figured it was something similar - and I did bind the
screen controls to the fields that I created . The two choices that you
have for setting initial values are:

1- Calculate this formula when I compose a new form
2- Calculate this formula automatically

-- If I use the first one, the AutoFill value is not transferred to the
field,however, I can key in information in the field.

-- If I use the second one, I have the situation described in my first post,
i.e., info from AutoFill Cell is transferred, however, user cannot modify
data.

Being a newbie to VB and programming with Outlook Forms could you suggest a
resource where I could find the information needed to program the code
behind the AutoFill Command Button that you suggested previously?

many thanks for your help,

dan

Well, you have probably have set it to continusally set the value, instead
of just at opening. Not sure that I remember the available choices just
very well.

Perhaps a better way would be to have a command button, which, when clicked,
will copy the value of the auto-fill field to all the fields if it is
non-zero, or copy the auto-fill value to the fields that are 0, if the
auto-fill fiels is non-zero. You have more flexibility with code behind a
command button, but you do have to write it.

I trust that you have remembered to bind your screen controls to the fields.

Hollis

Hi...Pretty much a newbie in Outlook forms design, so any help or pointers
would be appreciated with my question.

1. In my custom form I have 12 fields, with each one representing a
Commission Rate for the given month ex: CR (Jan), CR (Feb),...,CR (Dec)

2. I have also created a 13th field called "AutoFill CR".

I would like the form to: a) Verify if there is a value in the "AutoFill
CR";
-- If YES, then Copy this value to ALL CR fields.
-- If NO, then let the user input individual monthly values in.

So I set the "Initial Value" of the field to the following formula:
IIf( [AutoFill CR (%)] <> 0.00 , [AutoFill CR (%)] , [Jan CR (%)] )

This works great if all I want to do is copy the value from AutoFill to the
monthly CR field, but, it breaks down if you want to type in a value into
the field...because it will not let you input any other data.

any suggestions?

thnx
dan

 

[Hollis Paul [MVP - Outlook]]

I would go to the library section of www.slipstick.com, and look for the
teach yourself Outlook programming in 24 hours, or some title like that, by
Sue Mosher, or any of the beginning books listed there.

Hollis

Hi Hollis,

Thanks for the info, I figured it was something similar - and I did bind the
screen controls to the fields that I created . The two choices that you
have for setting initial values are:

1- Calculate this formula when I compose a new form
2- Calculate this formula automatically

-- If I use the first one, the AutoFill value is not transferred to the
field,however, I can key in information in the field.

-- If I use the second one, I have the situation described in my first post,
i.e., info from AutoFill Cell is transferred, however, user cannot modify
data.

Being a newbie to VB and programming with Outlook Forms could you suggest a
resource where I could find the information needed to program the code
behind the AutoFill Command Button that you suggested previously?

many thanks for your help,

dan

Well, you have probably have set it to continusally set the value, instead
of just at opening. Not sure that I remember the available choices just
very well.

Perhaps a better way would be to have a command button, which, when clicked,
will copy the value of the auto-fill field to all the fields if it is
non-zero, or copy the auto-fill value to the fields that are 0, if the
auto-fill fiels is non-zero. You have more flexibility with code behind a
command button, but you do have to write it.

I trust that you have remembered to bind your screen controls to the fields.

Hollis

Hi...Pretty much a newbie in Outlook forms design, so any help or pointers
would be appreciated with my question.

1. In my custom form I have 12 fields, with each one representing a
Commission Rate for the given month ex: CR (Jan), CR (Feb),...,CR (Dec)

2. I have also created a 13th field called "AutoFill CR".

I would like the form to: a) Verify if there is a value in the "AutoFill
CR";
-- If YES, then Copy this value to ALL CR fields.
-- If NO, then let the user input individual monthly values in.

So I set the "Initial Value" of the field to the following formula:
IIf( [AutoFill CR (%)] <> 0.00 , [AutoFill CR (%)] , [Jan CR (%)] )

This works great if all I want to do is copy the value from AutoFill

to
the

monthly CR field, but, it breaks down if you want to type in a value into
the field...because it will not let you input any other data.

any suggestions?

thnx
dan

 

[Sue Mosher [MVP-Outlook]]

If you want to set values some of the time but not all the the time, you
need to use code not a formula.

 

[Daniel]

Cool, thanks.

being a newbie and all I was hoping for some guidance as to where I could
find such information.

thnx,

dan

If you want to set values some of the time but not all the the time, you
need to use code not a formula.
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

Hi...Pretty much a newbie in Outlook forms design, so any help or pointers
would be appreciated with my question.

1. In my custom form I have 12 fields, with each one representing a
Commission Rate for the given month ex: CR (Jan), CR (Feb),...,CR (Dec)

2. I have also created a 13th field called "AutoFill CR".

I would like the form to: a) Verify if there is a value in the "AutoFill
CR";
-- If YES, then Copy this value to ALL CR fields.
-- If NO, then let the user input individual monthly values in.

So I set the "Initial Value" of the field to the following formula:
IIf( [AutoFill CR (%)] <> 0.00 , [AutoFill CR (%)] , [Jan CR (%)] )

This works great if all I want to do is copy the value from AutoFill to the
monthly CR field, but, it breaks down if you want to type in a value into
the field...because it will not let you input any other data.

any suggestions?

thnx
dan

 

[Sue Mosher [MVP-Outlook]]

If you mean that you need information on Outlook property syntax, see
http://www.outlookcode.com/d/propsyntax.htm
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

Cool, thanks.

being a newbie and all I was hoping for some guidance as to where I could
find such information.

thnx,

dan

If you want to set values some of the time but not all the the time, you
need to use code not a formula.
--

Hi...Pretty much a newbie in Outlook forms design, so any help or pointers
would be appreciated with my question.

1. In my custom form I have 12 fields, with each one representing a
Commission Rate for the given month ex: CR (Jan), CR (Feb),...,CR (Dec)

2. I have also created a 13th field called "AutoFill CR".

I would like the form to: a) Verify if there is a value in the "AutoFill
CR";
-- If YES, then Copy this value to ALL CR fields.
-- If NO, then let the user input individual monthly values in.

So I set the "Initial Value" of the field to the following formula:
IIf( [AutoFill CR (%)] <> 0.00 , [AutoFill CR (%)] , [Jan CR (%)] )

This works great if all I want to do is copy the value from AutoFill

to
the

monthly CR field, but, it breaks down if you want to type in a value into
the field...because it will not let you input any other data.

any suggestions?

thnx
dan