Hi.
This message appears when I am trying to pull up a report. There are about
43,000 entries in this database and everything prior to 32,000 works just
fine. For some reason the newer entries generate this message when recalling
them.
Could the point of failure be 32,768? It sounds as if something in the
report is relying on an Integer data type and is "rolling over" the next
digit, which makes it a negative number -- and absolutely invalid as a
counter or accummulator. When this happens, the computer alerts the user of
the "overflow" with this error message. I suggest analyzing the VBA code in
the report and the procedure that generates the opening of the report to find
the Integer data type and change it to a Long data type.
If you cannot find an Integer data type that is causing the problem, a
string value assigned to a numerical variable can also cause this same error,
so check for invalid assignments in the VBA code.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
