Forum Discussion

Sietoebie's avatar
Sietoebie
New Member
3 years ago
Solved

Name of query changes

Hi,   When I change something (eg adding a column) to my query - the name of the query changes and I have to change my VBA code which I use to refresh the query. And the outcome of the query is on...
Need Help
  • Sietoebie's avatar
    Sietoebie
    3 years ago

    I seems to be solved.. 

    I duplicated the masterquery and this one loaded to a new sheet; (logical)

    Then I added some columns to this new query and it loaded to the same, new sheet. The query name stays the same.

    But now I'm wondering why this happens to the original query. 

Sietoebie's avatar
Sietoebie
New Member
3 years ago

Hi,

 

Thanks for answering.

The 'master'query exists out of 8 queries.

I can't provide a demo, but here are some screenshots.

- name of sheet

- queryname1 (already containing 13 times 1)

- new sheet (after adding a column to the masterquery)

- new query name (containing 14 times 1)

 

name of sheetquery (containing 13 times 1)column added in query causing new sheetnew query name (14 times 1)

 

Sietoebie's avatar
Sietoebie
New Member
3 years ago

I seems to be solved.. 

I duplicated the masterquery and this one loaded to a new sheet; (logical)

Then I added some columns to this new query and it loaded to the same, new sheet. The query name stays the same.

But now I'm wondering why this happens to the original query.