Access 2002 - Overflow error

  • Thread starter Thread starter Jim Stuart
  • Start date Start date
J

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
 
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
 
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
 
Back
Top