Overflow

[AndyShuter]

Hi, just wondered if anyone could help me pls

Our record code has just recently gone through 32000 barrier and I'm noticing that when I try to send a file and refer to the record code that I am getting an "Overflow" error.

An example of the code I'm using is

Send_DealTrak_Proposal "Concept Car Credit", Forms!frmFinanceProposal.DealCode

When the DealCode is less than 32000 it works, when above I get "Overflow"

I am using Access 2003 linked to a mysql database


Thanks

Andy

 

[RuralGuy]

Overflow is a way that Access can tell you that a number is too large for the DataType, usually an Integer should be a Long Integer.

 

[MStef]

Or you try to deal with 0.