Recent content by agr1487

JHB that was it! Awesome! Thank you!

Go on..... :) ... so you have a table with each state and their respective field names? and then what?

Actually, it would be 50 SELECT queries, with 1 APPEND query. It would be much easier to debug and take up less space. I don't see how this can't be done with something like a FOR TO NEXT or FOR EACH NEXT or DO LOOP structure. Anyone else out there have any ideas?

Sure, but when I need to change the query (that's not a part of the state module) then I have to change it 50 times. My way, I only have to change the query once in VBA. In either case, it's much easier to script out 50 append queries in VBA vs. created 50 append query objects in the Access GUI...

I'm trying to append data from each state table into one table and I don't want to write the same append query 50 times for each state. I want to write one append query with a nested query inside said append query referencing 50 select queries for each state. I've updated my original post with...

StateScripts is different for each state. Each state has different fields and different tables. I tweaked my original post to better reflect that. Where my script starts at "CurrentDb.Execute" is where my APPEND query starts. So how do I create an APPEND query object and use VBA to loop? My...

I hardly ever post for help and try to figure it out on my own, but now I’m stuck. I’m just trying to append data from multiple tables to one table. The source tables are data sets for each American State and the append query is the same for each State, except for a nested select script to pull...

I'm Jason from KC. I'm a BI Data Analyst and get to play with Access/VBA/Excel all day. I'd classify myself as an expert in Access and Excel, but I've been thrown into a VBA environment with no VBA exp, so any questions I have will probably have to do with that. Thanks!