Access 2002 - Overflow error

[Jim Stuart]

I have converted an Access 97 database to 2002. On one particular form there
is a button which should open another form which displays address
information. When I click on this button a simple message box is displayed
with the words "Overflow Error". An help would be appreciated.

Jim

 

[Ragnar Midtskogen]

It is likely a field width problem, but it might be a divide by zero.
Open the form with the button on it in design view. If it is no already
open, open the form's Properties window. Click on the button to set focus to
it and look for what is entered in the button's Click property. If it is an
Event Procedure, click to the right of the box, this will open the VB Editor
on the event proc. set a break point on the first executable line and open
the form in normal mode.
Then you click the button and step through the code to see where you get the
error.

If the button runs a macro you will have to open the macro editor and try to
figure out where the error could happen, you cn't step through a macro.

Ragnar

 

[Jim Stuart]

Thanks,

Found the problem. Access 97 and Access 2002 apparently handle integer
values differently. Thus what worked fine in 97 failed in 2002 causing the
overflow error.

Jim