Validation Errors on calculations

[Kentwoodjean]

I am stummped and hope someone can tell me what to look for. Have an
inforPath form attached to an Access Database. Within the form, there are 3
calculations wich work perfectly and do no indicate any errors. However,
when I go to submit my form, I am getting the message that "InfoPath cannot
submit due to validation errors". I have checked and rechecked my Access DB
and the primary table I am using is showing the fields and a number type,
same as the Infopath form. I have also verified that any tables that were
linked to the primary carried the same data type. I have even gone so far as
to remove all tables but the primary. Each I time I made a change to the
database, I did the "Convert Main Data Source" from the InfoPath tools menu
to update that.
Any ideas on what else I should look at?

 

[Clay Fox]

Hey there.
Typically the validation error would be within InfoPah not in Access.

Try this. Create another view in your form and drag all of the fields from
your main data source into it. Then add a button to get to it from your main
view.
Complete your form and then switch to your new view before submit.

Check your fields for red this will be the data validation issues you need
to resolve.
Try fixing them and see if you can submit.

Typically there will be a field in your form that needs validation but it is
not visible.

--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

 

[Kentwoodjean]

I tried what you said and it did not work. I think I figured out the problem
but am not sure how to fix it. All my fields on the InfoPath form are tied
to my database table, including the fields that calculate totals. I notice
that if I put in whole numbers in the fields making up the calculations they
are just fine. Today, I put in a number like 252.80 and that field got the
red boarder. If I just put in 252 it is fine. In my access table, each
number field is set for 2 decimal point2. My fields are in text boxes on the
form, and because they are tied to the database the DataType Field where I
could set it to "Decimal(double) is greyed out. Could this be the problem?
I would think that because it is tied to the DB, it would automatically
accept the double decimal.

 

[Clay Fox]

When a database from is created the fields types are derived from the
database. Did you change them after the form was started?
If the field in the datasource is a Decimal(double) then I think that is
correct.
Go into the properties of your control on the form and go to format and
setup 2 decimal places for formatting there so that it matches the field it
is bound to.

--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

 

[Kentwoodjean]

Unfortunately as I go to format, it does not give me the options to do as you
have indicatd. Since I can't paste on this post, you can't see what I am
looking at. The format option lets me select "None, Number, or Currency".
Below that, the other options lets me check or un check a grouping symbol (,)
as well as a drop down to determine how to display any negative numbers. I
am at a loss.

 

[Clay Fox]

Ok.

Another option is creating a new test form and see if you get the same thing.

If that is the same thing then why don't you email me the template and DB
and I can look at it.
http://www.infopathdev.com/members/clayfox.aspx

--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

 

[Kentwoodjean]

Sorry, but I had the same result. I will be sending you the template and DB
shortly and appreciate anything you can do to assist me. It is probably
something very stupid but I am not a pro at either Access or Infopath.
Thanks.

 

[noche]

Hello Kentwoodjea,
I have the same problem as you. Do you find the solution?
Thanks

 

[Swathi]

Hi

Can you send your post onceagain telling about the issue you are facing.