• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 456
  • Last Modified:

Error 3349: Numeric Field Overflow on Make Table Query

I have a number of queries which analyse data in a Link table and then split the results into sub-tables using a Make Table Query.  The process of running all these queries is done using a simple Macro.  When I run the Macro the first time it works fine but if I try to run it again it stalls with the above error.  In order to make it work again I have to tell each Query the name of table it is going to make - even though in theory it already knows as it suggests the name before I type it.

Does anyone know a good way to stop this from happening so that I can run the Macro over and over again?

Cheers
MotionMaster
0
MotionMaster
Asked:
MotionMaster
1 Solution
 
saragoseCommented:
I'm actually having a similar error with a program written in VBA/Access 2000. My problem is coming from an attempt to find which data is chosen in a combo box.

The problem comes from the fact that though there is something listed at the top of the combo-box, the user didn't choose it, and therefore if I try to fetch data through .column, or .itemdata, I get the same error as you have now.

I'm not sure how to fix it, but hopefully, it'll help find the source of the problem.

Eric
0
 
MotionMasterAuthor Commented:
I managed to solve it in the short term to make sure it searches the data for me - but in effect it is still a manual process as I have to run each Query seperatly.  The problem kicks in when I use a Macro to open and run each query and then close them.

The hunt for an answer goes on.
Thanks for the insight though
0
 
walterecookCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

PAQ with points refunded

Please leave any comments here within the next four days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

walterecook
EE Cleanup Volunteer
0
 
Computer101Commented:
PAQed, with points refunded (50)

Computer101
E-E Admin
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now