I sometimes get a pop-up box that reads "Overflow" and the module that
is executing pauses. It doesn't get caught by my error trapping, and
it seems to be randow. By random, I mean usually in the same section
of code, but I can run the code a few times, then it appears. I can't
reproduce it when I want to, and I have no idea what is causing it.
Any ideas ? Thanks
By the way the code is some record manipulation of 2 recordsets.

Sorry for the repost, forgot to mention the message just reads
"Overflow", no mention of an error or an error code

On Fri, 24 Mar 2006 02:54:35 GMT, SheldonMopes (AT) KidNet (DOT) com wrote:

Overflow errors usually mean you're trying to stuff too much data into sometime; for example, trying to set a Variable
declared as in Integer to a value > 32,767. If you're dealing with recordsets, perhaps your recordset code is trying to
set the value of a variable to something larger than the variable an hold.

The fix depends on what's causing it; if it's the varialbe issue, you can use a different Variable type (like Double or
Single), but make sure this works and doesn't just fix a symptom.


Scott McDaniel
scott (AT) takemeout_infotrakker (DOT) com
www.infotrakker.com

On Fri, 24 Mar 2006 02:54:35 GMT, SheldonMopes (AT) KidNet (DOT) com wrote:

This question was asked and answered on comp.databases.ms-access

PLEASE DON'T MULTI-POST!!!

If you feel that your question is relevant to several groups (and it rarely is), then you should instead cross-post.
Multiposts are often considered Spam and will get you ignored by many people in these newsgroup who can help you.



Scott McDaniel
scott (AT) takemeout_infotrakker (DOT) com
www.infotrakker.com

Maybe you should have read the whole message, where I explained the
repost because I forgot to mention something. Thank you, those who
helped, and for those who feel the need to chastise over trivia, seek
help.


On Fri, 24 Mar 2006 07:21:33 -0500, Scott McDaniel
<scott (AT) NoSpam_Infotrakker (DOT) com> wrote:

On Fri, 24 Mar 2006 23:39:19 GMT, SheldonMopes (AT) KidNet (DOT) com wrote:

I did read the entire message, and reposting has absolutely nothing to do with multiposting ... you should have posted
this under your original question.

Scott McDaniel
scott (AT) takemeout_infotrakker (DOT) com
www.infotrakker.com

I thought I did, must have typed 'databases' instead of database. I
can see this has caused you great distress, am for that I am truly
sorry. I can only hope this will prevent others from going down the
terrible path that I chose. We can now consider order restored to the
universe.

On Sat, 25 Mar 2006 09:51:47 -0500, Scott McDaniel
<scott (AT) NoSpam_Infotrakker (DOT) com> wrote:

On Sat, 25 Mar 2006 15:54:04 GMT, SheldonMopes (AT) KidNet (DOT) com wrote:

It did ... I was unable to sleep for the past few days ... but I'm glad that order has been restored <g>

Sorry you took this so personally. I certainly didn't intend for that. My only intent was to alert you to your
multipost, since this can have a very negative impact on future answers to any questions you may post. Excessive
multiposting quite often results in the "regulars" ignoring posts from the person, and therefore excludes a large list
of potential "experts" who could provide answers (note that I do NOT include myself in this "experts" category).


Scott McDaniel
scott (AT) takemeout_infotrakker (DOT) com
www.infotrakker.com