We maintain an employee spreadsheet that has all of the Reports to for the division. We use that as the source for Visio org chart. I talked the management in to using Access to do some of the heavy lifting. They wanted to create individual visio pages a certain way by sub departments. So I created a database and 60 queries that make the tables to be the source for the visio files from the linked spreadsheet. So because the project is in the infancy stage, I have come across a big issue.
The manager added two fields to the spreadsheet and therefore all 60 queries when run in the macro gives errors of missing fields.
My question is how would I create the tables and manage the tables with the certain criteria for each query and if a new field or two is added to the spreadsheet, update the 60 queries.
I thought of moving the macro to vba and do a replace all for the missing fields in vba. But that sounds kind of clunky and not very efficient. Unless the group confirms it is the best idea.
I also thought of somehow creating a table with the criteria for each table in a criteria table and using that to assist in the table creation.
What are the groups thoughts.
Thank You Very Much.
Posted by: email@example.com
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (1)|