I'm running a Macro that runs the code exporting a table & a query to another newly created database. I'm getting this error on coding that was previously working. It's now stopping and saying:
Microsoft Office Access 3265 Item not found in this collection
Can you tell me what this means and how I should fix it? Thanks, R.
Here is the code: Can you identify what is wrong? and how to fix it? All this is doing is catching "all" the columns from the original view - that are from Octoboer 2007 onwards to date. There are no other fields that are involved that may be incorrect by name or from another table/view. Please help..... This is a really urgent fix that I need to do...... Thanking you for your timely help, sincerely, R.
The Module starts with setting up the Array for Array Items AUD(1) thru AUD(9). 1 thru 8 work ok, but when it gets to AUD(9), I get this error message......
AUD(9) : Looks to a view in the ODBC Sybase Database - and gathers all columns from that view - and brings it forth : with one parameter: the Pay-Period-End-Dates are between Oct 2007 thru to Current.
If I make a Make-Table Query - it works thru. It's just that within this Arrayed-Module, it stops when it gets to this one - which is the last one amonst 9 such components. I need to have it functioning directly from one Macro - which operates & exports this array from the module.
I'm not sure - if this is what Sage was asking in the previous reply....
