Overflow

[Jon123]

I have a line of code that when it runs I get an error Overflow thats all it shows.

Why

 

[KenHigg]

Care to post that line of code ?

 

[Jon123]

Sorry

the line is


Z = Forms![subform]![CallID]

If I put a stop right before this line and then highlight the Callid field I see the value but when this line runs I get Overflow error.

Also note that this code has worked for quite some time so I'm not sure what has changed to caues this error

Thanks

Jon

 

[andyski101]

How did you DIM Z? or did you maybe DIM Z as public or global elsewhere?

 

[boblarson]

My guess would be that Z is set to a datatype who's maximum is below the value of Forms![subform]![CallID].

In other words - If Z is an Integer and the value of your form object was 60,000, then you'd get an overflow error.

 

[Jon123]

I have DIM Z as Integer

Why is this limited to 60,000 or a better guestion how do I make this larger?


Jon

 

[andyski101]

If your only using integer values then you can use LONG instead. DOUBLE is as big as you can get but since it also hold the decimal places it uses extra memory.

 

[boblarson]

Actually 60,000 was just an example. The cutoff for an integer is around 32,000. You could make Z a Long instead and you should be fine.

 

[Jon123]

On the Table it is set to a Long Integer but I'm using Sim z as Integer do I need to Dim z as Long Integer?

What is the size for a long integer?

Thanks for helping

Jon

 

[andyski101]

Dim Z As Long

 

[mresann]

I never use the Integer or Single values anymore. Not worth the hassle.

 

[boblarson]

Integer is -32,768 to 32,767
Long Integer is -2,147,483,648 to 2,147,483,647
Single is -3.402823E38 to -1.401298E-45 for negative values and 1.401298E-45 to 3.402823E38 for positive numbers
and let's just say that Double is even larger.

 

[Jon123]

Thank for the help

Din z as Long = problem gone

jon