Z
Zac
Hello
Working with Access 2002 and Excel X
I have a sheet that looks at different, rather complicated, queries (the reason I couldn't just execute the query from with VBA) in Access using odc links on different tabs. What I'd like to do, being as the names of the different tables/queries that are referenced use a similar naming convention, is load them on demand in one tab and have 2 cells that change the the 2 parts of the queries name within the naming format. Example
Queries currently referenced by odc on individual worksheets
Tom26WeekTotal
Tom52WeekTotal
Mike26WeekTotal
Mike52WeekTotal
I would like to have 2 cells, Name, Week, where I can edit Name and Week and refresh the query and it will return the data requested
Working with Access 2002 and Excel X
I have a sheet that looks at different, rather complicated, queries (the reason I couldn't just execute the query from with VBA) in Access using odc links on different tabs. What I'd like to do, being as the names of the different tables/queries that are referenced use a similar naming convention, is load them on demand in one tab and have 2 cells that change the the 2 parts of the queries name within the naming format. Example
Queries currently referenced by odc on individual worksheets
Tom26WeekTotal
Tom52WeekTotal
Mike26WeekTotal
Mike52WeekTotal
I would like to have 2 cells, Name, Week, where I can edit Name and Week and refresh the query and it will return the data requested