Numeric Overflow in Query

[achillese]

Hi,

I created a query to update a MS acces table from Excel spreadsheet.

When I run the raw append query it works perfectly well. when I add a parameter value in a field to append only certain records in raw query it also works fine.

But when i pass on the parameter value in a form and the query to fecth them from there it will say..NUMERIC OVERFLOW...and it won't append any records...

I don't understand why. When i don't use the value from the form it works okey.

Please help...


Thanks +++

 

[PCLewis]

there is more to the error thatn just "Numeric Overflow" surely?

In general when things don't work and you can isolate it to one variable, you should just be sure of the type (use VarType) of variable you are using as well as the value.

More than likely you are passing a decimal value when a whole number is expected or something to that effect.

 

[achillese]

I have already applied trim() for some fields it works fine but the error is still there. Is cell comment in spreadsheet causing the overflow?I may have to try that...

Thanks +++

 

[PHV]

Don't you pass a Long value to an Integer ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886