D
DoveArrow
Using Access 2003, I have a table linked to an Excel spreadsheet.
Running a series of append queries as part of a macro, I'm trying to
generate a table that pulls up the E-Mail addresses of students'
advisors so that I can run a Mail Merge. If I run this macro once, it
works fine. If I try to run the macro again, it gives me a "Numeric
field overflow" error. If I close the Access Database altogether and
open it back up again, the macro again works fine, but only the one
time. Finally, if I go through and manually run each of the append
queries by double clicking on them in Queries, I can run the whole
process any number of times without ever getting the error message.
I'm sure you're going to need to know more information than that, but
I'm not exactly sure what you're going to want, so let me know and
I'll respond.
Running a series of append queries as part of a macro, I'm trying to
generate a table that pulls up the E-Mail addresses of students'
advisors so that I can run a Mail Merge. If I run this macro once, it
works fine. If I try to run the macro again, it gives me a "Numeric
field overflow" error. If I close the Access Database altogether and
open it back up again, the macro again works fine, but only the one
time. Finally, if I go through and manually run each of the append
queries by double clicking on them in Queries, I can run the whole
process any number of times without ever getting the error message.
I'm sure you're going to need to know more information than that, but
I'm not exactly sure what you're going to want, so let me know and
I'll respond.