Selasa, 18 Oktober 2016

Re: [MS_AccessPros] Create Multiple tables and manage them


Well I changed it to * but I get an error stating that  
"Cannot define field more than once" came up. So that will not work.

Jim Wagner

On Tuesday, October 18, 2016 9:08 AM, "Jim Wagner [MS_Access_Professionals]" <> wrote:

I think I answered my question. I need to change the sql to  Select * and then the criteria fields. Would that be a good way?

Jim Wagner

On Tuesday, October 18, 2016 8:44 AM, " [MS_Access_Professionals]" <> wrote:

Hello all,

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.

Jim Wagner


Posted by: Jim Wagner <>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.



Tidak ada komentar:

Posting Komentar