?
Solved

Error 3349: Numeric Field Overflow on Make Table Query

Posted on 2003-03-04
4
Medium Priority
?
451 Views
Last Modified: 2008-01-09
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
Comment
Question by:MotionMaster
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 

Expert Comment

by:saragose
ID: 8064711
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
 
LVL 1

Author Comment

by:MotionMaster
ID: 8065070
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
 
LVL 17

Expert Comment

by:walterecook
ID: 10328991
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
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 10361654
PAQed, with points refunded (50)

Computer101
E-E Admin
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question