Please Help! Custom Form Showing Dialog Box with Date/Time w

[DOreen]

mHi Everyone,

When some of my users fill out a custom form created in Outlook and hit the
send button a little dialog box pops up with today's date and the time
8:00:00AM with an OK button. If I hit the button nothing happens. I did not
create the form. It was created by soeone who no longer works at my company
and I am not familiar with forms at all. It is an intermittent problem. I
tried leaving some fields blank on the form and sometimes it goes through and
sometimes it doesn't. Can someone point me in the right direction to getting
this resolved. It is happening on Office XP SP2 and also some Outlook 2003
users.

If you give me your email address I can send a screenshot.

Thanks very much! I am lost with forms and any help would be most
apprecated.

 

[Sue Mosher [MVP-Outlook]]

Look in the form's code for a MsgBox statement.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[DOreen]

Hi Sue - thanks very much!! The form is password protected. I have a call
into the programmer to see if I can get in. I may need more help at that time.

Thanks for your help and hopefully I will get into this soon.

 

[Sue Mosher [MVP-Outlook]]

Don't let a little thing like a form password get in your way: http://www.outlookcode.com/d/code/getformpassword.htm

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[DOreen]

Hi Sue, thanks! I got the password. But I am still lost. I have the form open
but do not see any code. I went into design mode and just see a bunch of
fields. Of course I looked at the properties of all of them, but am stull
unclear on where this msgbox is coming from. I don;t believe he wrote any VBS
code but just used the form designer. How should I proceed. Thanks so much!!!

 

[Sue Mosher [MVP-Outlook]]

In design mode, there's a View Code button on the right side of the toolbar. If there is no code behind the form and no validation message on any of the controls' Validation tab (on each control's Properties dialog), then the form is not the cause of the message that users are seeing. Look elsewhere, like at VBA code or add-ins.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Miss Deep Thinker]

Hi Sue,

I just checked and there is no code behind the form. There are validation
messages, but no info box with date/time as I previously described. Just
messages saying the fields are required is they are. When you say look else
like VBA code what exactly do you mean, if there is no code behind the form.
IS there some other place to look for VBA code. I will definitely check the
add-ins.

thanks again.

 

[Sue Mosher [MVP-Outlook]]

VBA code lives in the VBA editor in Outlook, not in custom forms. Press Alt+F11 while viewing Outlook's main window.

You can also start Outlook in safe mode by using the /safe command-line switch; that will turn off VBA and all add-ins, allowing you to confirm or eliminate those possible sources of a stray message box.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Miss Deep Thinker]

Hi Sue - When I Press Alt+F11 while in design mode of the form, I get the VB
window but nothing opens up, so I assume it is safe to assume there is no
code, correct? I will contact one of the users with the issue and have her
run in safe mode. I will let you know what happens.

Thanks again! I really appreciate!!!

 

[Sue Mosher [MVP-Outlook]]

The Project Explorer at the left side of the VBA window will show you any code modules that are present.

Are any of the fields being validated using a validation formula? Or do they just have the box checked to tell the use if the field isn't given a value?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Miss Deep Thinker]

Hi - they are using a validation formula just to check the length and they
display amessage box if the field is blank or the number of characters is
less than the length. thanks

 

[Miss Deep Thinker]

Sue - I checked with one of the users having the problem and she has nothing
in comm add-ins and the add-ins are the default. Nothing else.

 

[Sue Mosher [MVP-Outlook]]

Please show the formula. It is probably the source of the problem.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Miss Deep Thinker]

Sue,
the boxes on the form are all text fields and the formula's are the ones
below. There is really isn't anything else. I haven't tried running in safe
mode yet but as I don't see any add-ins or VB stuff I still not sure where to
go from here. Thanks again!

Len( [HCP-Name] ) <=12
Len( [HCP-Name] ) <=30
Len( [HCP-State] ) <=4
Len( [REGBN] ) <= 7
Len([HCP-Number] ) <=12
Len( [DM Name] ) <= 12
Len( [DM Name] )
Len( [DMCellPhone] ) <= 14
Len([TM Name] ) <= 14

 

[Sue Mosher [MVP-Outlook]]

Bingo! This is a bad formula because it does not evaluate to True or False:

Len( [DM Name] )

You'll probably want to consult with the form designer to determine what it should be.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

Sue,
the boxes on the form are all text fields and the formula's are the ones
below. There is really isn't anything else. I haven't tried running in safe
mode yet but as I don't see any add-ins or VB stuff I still not sure where to
go from here. Thanks again!

Len( [HCP-Name] ) <=12
Len( [HCP-Name] ) <=30
Len( [HCP-State] ) <=4
Len( [REGBN] ) <= 7
Len([HCP-Number] ) <=12
Len( [DM Name] ) <= 12
Len( [DM Name] )
Len( [DMCellPhone] ) <= 14
Len([TM Name] ) <= 14

 

[Miss Deep Thinker]

Sue - That was a typo on my part - they all evalaute to True or false. They
all specificy a length. So sorry. I was hopeful for a minute. The person who
designed the form was a contractor who was let go. I have been given the
daunting task of figuring out why this is happening and I have never worked
with Outlook forms before.

thanks

Bingo! This is a bad formula because it does not evaluate to True or False:

Len( [DM Name] )

You'll probably want to consult with the form designer to determine what it should be.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

Sue,
the boxes on the form are all text fields and the formula's are the ones
below. There is really isn't anything else. I haven't tried running in safe
mode yet but as I don't see any add-ins or VB stuff I still not sure where to
go from here. Thanks again!

Len( [HCP-Name] ) <=12
Len( [HCP-Name] ) <=30
Len( [HCP-State] ) <=4
Len( [REGBN] ) <= 7
Len([HCP-Number] ) <=12
Len( [DM Name] ) <= 12
Len( [DM Name] )
Len( [DMCellPhone] ) <= 14
Len([TM Name] ) <= 14

I just checked and there is no code behind the form. There are validation
messages, but no info box with date/time as I previously described. Just
messages saying the fields are required is they are.

:

In design mode, there's a View Code button on the right side of the toolbar. If there is no code behind the form and no validation message on any of the controls' Validation tab (on each control's Properties dialog), then the form is not the cause of the message that users are seeing. Look elsewhere, like at VBA code or add-ins.


Hi Sue, thanks! I got the password. But I am still lost. I have the form open
but do not see any code. I went into design mode and just see a bunch of
fields. Of course I looked at the properties of all of them, but am stull
unclear on where this msgbox is coming from. I don;t believe he wrote any VBS
code but just used the form designer. How should I proceed. Thanks so much!!!

:

Don't let a little thing like a form password get in your way: http://www.outlookcode.com/d/code/getformpassword.htm


Hi Sue - thanks very much!! The form is password protected. I have a call
into the programmer to see if I can get in. I may need more help at that time.

Thanks for your help and hopefully I will get into this soon.

:

Look in the form's code for a MsgBox statement.

mHi Everyone,

When some of my users fill out a custom form created in Outlook and hit the
send button a little dialog box pops up with today's date and the time
8:00:00AM with an OK button. If I hit the button nothing happens. I did not
create the form. It was created by soeone who no longer works at my company
and I am not familiar with forms at all. It is an intermittent problem. I
tried leaving some fields blank on the form and sometimes it goes through and
sometimes it doesn't. Can someone point me in the right direction to getting
this resolved. It is happening on Office XP SP2 and also some Outlook 2003
users.

If you give me your email address I can send a screenshot.

Thanks very much! I am lost with forms and any help would be most
apprecated.

 

[Miss Deep Thinker]

Sue - Is there any way I can run the form in debug mode to shed some light on
theat weird dialog box. If you could tell me how that would be helpful.

thanks!

Bingo! This is a bad formula because it does not evaluate to True or False:

Len( [DM Name] )

You'll probably want to consult with the form designer to determine what it should be.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

Sue,
the boxes on the form are all text fields and the formula's are the ones
below. There is really isn't anything else. I haven't tried running in safe
mode yet but as I don't see any add-ins or VB stuff I still not sure where to
go from here. Thanks again!

Len( [HCP-Name] ) <=12
Len( [HCP-Name] ) <=30
Len( [HCP-State] ) <=4
Len( [REGBN] ) <= 7
Len([HCP-Number] ) <=12
Len( [DM Name] ) <= 12
Len( [DM Name] )
Len( [DMCellPhone] ) <= 14
Len([TM Name] ) <= 14

I just checked and there is no code behind the form. There are validation
messages, but no info box with date/time as I previously described. Just
messages saying the fields are required is they are.

:

In design mode, there's a View Code button on the right side of the toolbar. If there is no code behind the form and no validation message on any of the controls' Validation tab (on each control's Properties dialog), then the form is not the cause of the message that users are seeing. Look elsewhere, like at VBA code or add-ins.


Hi Sue, thanks! I got the password. But I am still lost. I have the form open
but do not see any code. I went into design mode and just see a bunch of
fields. Of course I looked at the properties of all of them, but am stull
unclear on where this msgbox is coming from. I don;t believe he wrote any VBS
code but just used the form designer. How should I proceed. Thanks so much!!!

:

Don't let a little thing like a form password get in your way: http://www.outlookcode.com/d/code/getformpassword.htm


Hi Sue - thanks very much!! The form is password protected. I have a call
into the programmer to see if I can get in. I may need more help at that time.

Thanks for your help and hopefully I will get into this soon.

:

Look in the form's code for a MsgBox statement.

mHi Everyone,

When some of my users fill out a custom form created in Outlook and hit the
send button a little dialog box pops up with today's date and the time
8:00:00AM with an OK button. If I hit the button nothing happens. I did not
create the form. It was created by soeone who no longer works at my company
and I am not familiar with forms at all. It is an intermittent problem. I
tried leaving some fields blank on the form and sometimes it goes through and
sometimes it doesn't. Can someone point me in the right direction to getting
this resolved. It is happening on Office XP SP2 and also some Outlook 2003
users.

If you give me your email address I can send a screenshot.

Thanks very much! I am lost with forms and any help would be most
apprecated.

 

[Sue Mosher [MVP-Outlook]]

If there is no code behind the form, the script debugger won't help you. Perhaps you should try removing all the validation formulas, then adding them back one by one.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

Sue - Is there any way I can run the form in debug mode to shed some light on
theat weird dialog box. If you could tell me how that would be helpful.

thanks!

Bingo! This is a bad formula because it does not evaluate to True or False:

Len( [DM Name] )

You'll probably want to consult with the form designer to determine what it should be.

Sue,
the boxes on the form are all text fields and the formula's are the ones
below. There is really isn't anything else. I haven't tried running in safe
mode yet but as I don't see any add-ins or VB stuff I still not sure where to
go from here. Thanks again!

Len( [HCP-Name] ) <=12
Len( [HCP-Name] ) <=30
Len( [HCP-State] ) <=4
Len( [REGBN] ) <= 7
Len([HCP-Number] ) <=12
Len( [DM Name] ) <= 12
Len( [DM Name] )
Len( [DMCellPhone] ) <= 14
Len([TM Name] ) <= 14


I just checked and there is no code behind the form. There are validation
messages, but no info box with date/time as I previously described. Just
messages saying the fields are required is they are.

:

In design mode, there's a View Code button on the right side of the toolbar. If there is no code behind the form and no validation message on any of the controls' Validation tab (on each control's Properties dialog), then the form is not the cause of the message that users are seeing. Look elsewhere, like at VBA code or add-ins.


Hi Sue, thanks! I got the password. But I am still lost. I have the form open
but do not see any code. I went into design mode and just see a bunch of
fields. Of course I looked at the properties of all of them, but am stull
unclear on where this msgbox is coming from. I don;t believe he wrote any VBS
code but just used the form designer. How should I proceed. Thanks so much!!!

:

Don't let a little thing like a form password get in your way: http://www.outlookcode.com/d/code/getformpassword.htm


Hi Sue - thanks very much!! The form is password protected. I have a call
into the programmer to see if I can get in. I may need more help at that time.

Thanks for your help and hopefully I will get into this soon.

:

Look in the form's code for a MsgBox statement.

mHi Everyone,

When some of my users fill out a custom form created in Outlook and hit the
send button a little dialog box pops up with today's date and the time
8:00:00AM with an OK button. If I hit the button nothing happens. I did not
create the form. It was created by soeone who no longer works at my company
and I am not familiar with forms at all. It is an intermittent problem. I
tried leaving some fields blank on the form and sometimes it goes through and
sometimes it doesn't. Can someone point me in the right direction to getting
this resolved. It is happening on Office XP SP2 and also some Outlook 2003
users.

If you give me your email address I can send a screenshot.

Thanks very much! I am lost with forms and any help would be most
apprecated.