Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Numeric overflow

Status
Not open for further replies.

mart10

MIS
Nov 2, 2007
394
GB
I am using Access 2003

I run a macro of about 25 queries each looking at different linked spreadsheets to append data to a table. And note it also has an initial query to clear the table

The first time it runs it works fine. However if I run again I get numeric overflow
 

There is no question in your post. But if you want some help, show the code that you have a problem with, including the declaration of any variables you use.

Have fun.

---- Andy
 
The code runs through a macro. i GET ROUND THE ISSUE BY RELINKING THE SPREADSEEHTS
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top