Search results

I was finally able to figure it out, with some help from a local access guru. It was related to a few fields in the individual databases. They all had #num errors because of the way the formula was setup. I changed the formula to accommodate the inputs, and after that the consolidation process...

Honestly I am new to access and VBA and I'm working with a hand-me-down database, so I don't feel qualified to respond to this one, but logically yes, I would agree that the form is pulling the data from the 23 tables, and then transferring it into the single consolidated table. I'm sure that...

I'm not modifying any data. I'm just consolidating it. All 23 databases produce the exact same data, I'm just consolidating it into a single table. The consolidated database I am using, links to those 23 tables, the form then pulls that data, and consolidates it into a different table in the...

Yes, I am actually linked to 23 different databases. I am consolidating those records into a single table within the same database. But I was able to figure out my problem, which were missing fields in the consolidated table. My code was referencing fields that didn't exist. Once I put those...

My apologies, here's the actual offending line Form_frmConsolidate.rsIndividual.Close

I am attempting to consolidate data from 23 different databases (all Access 2010). The content across each database is exactly the same, I just need to consolidate it into a single database. When I attempt do so i am getting the run-time error 91 "Error in modload_consolidated_tables 91 object...