"Numeric field overflow."

From: "G Lykos" <GLykos@xxxxxxxxxxxxxx>
Date: Wed, 17 May 2006 23:00:14 -0700

Am regularly running into a problem where something snaps and an append
query stops running with the captioned error message. I'm not doing any
math calculations, just appending selected fields from a filtered record
set.

Once this happens, it stays broken until I edit the query (as in add a
field, then delete it, functionally taking me back to when I started) and
then the query works again for a while. It's driving me nuts because I
don't know how to identify the source, and I'm tired of having to futs
around with nonsense edits to the query to get it working again. Any ideas
what might be causing this??

I have the impression after having struggled with this and other oddball
Access things this week that Access 2003 SP2, under XP Pro with all updates,
is kind of buggy. Were earlier releases more stable?

Thanks,
George

.

Follow-Ups:
- Re: "Numeric field overflow."
  - From: Allen Browne

Prev by Date: Re: Hours calculation problem
Next by Date: i have 2 numeric fields and i want to compare them helppppppppppp
Previous by thread: Re: Hours calculation problem
Next by thread: Re: "Numeric field overflow."
Index(es):
- Date
- Thread

Relevant Pages

Re: Membership database updates
... When you open any Query in Design View, click on the toolbar just next to ... black down-arrow where you can change your query to an Append or Update ... If you have any current members in your Import list, ... You mention Update Queries and Append Queries but I can't find how to ...
(microsoft.public.access.tablesdbdesign)
RE: Assign macro on After update event
... I don't see why you can't append the current record next scheduled date to ... it then try using an update query to update the dates in the new record. ... "Anna" wrote: ... maybe you can help me with that: all this macro is ...
(microsoft.public.access.forms)
Re: duplicates query help & strategy for update queries with SetWarnings = False
... I have many many queries that check for orpaned data (for example, if there's a billing record with no matching custID in the customer table, I'm putting up a form with the unmatched data, and a quick way to update all unmatched to one archive type customer, etc. ... I was surprised to see duplicate entries in some of the static tables for dropdown selections, so I have to solve this one now. ... Once the user has handled all the problems, you enable the final command button at the bottom of the form, which executes an append query to add the data to the real table. ...
(comp.databases.ms-access)
Re: Append Query Date Criteria Problem.
... Why can't I append some records? ... Choose Parameters on the Query menu. ... Access opens the paramters dialog. ... > End Sub ...
(microsoft.public.access.queries)
RE: How to use Append Queries to add new records
... I sort of knew how the append query would work, ... > destination field name that you want to append those values to. ... > out new action queries. ...
(microsoft.public.access.queries)