Recent content by A3Kluth

Here is the code I am using. Just trying to check for gaps between the Effective date of the 1st record and the End date of the second record. The records are ordered by effective date descending. I have to load and unload the arrays every time I see a new unique order ID. Some of the order...

I have created a module that uses multiple arrays to check transaction dates for the same order number and keep getting a System Resources Exceeded Error. I am using MS ACCESS 2010. I then have to stop the code and do a compact and repair which isn't a big issue except when I do this the code...

Hello everybody, Andrew here from the Chicagoland Area. Been working with MS Access for about 20 years.