Query update selected do not update

angelnthesky

New Member
Joined
Jun 5, 2017
Messages
3
I have 10 tables, i use lots of queries. The tbl with the raw data do not update my queries when the tbl is modified.

The results do not show. When i try to run the query to show itself, nothing happens, it has no content inside the query.

This is mind boggling.

Angelnthesky

:eek::eek::eek:
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
does the table with raw data have an autokey field ?

when you modify that table are you deleting rows or doing anything that would cause the autokey do reset, or change ?

is so then your joins won't work
 
Upvote 0
No; I am only appending records to a dump file. While expecting all the queries to blend in. You see its like this. I have select queries, When i import an excel table, it arrives. When i look at my queries, nothing happens. How do i get to do update all the queries then.

Please! Anyone!! desperate but patient.
 
Upvote 0

Forum statistics

Threads
1,221,691
Messages
6,161,310
Members
451,696
Latest member
Senthil Murugan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top