is there a way to compare a query definition to a table definition and tell if the query is missing any newly added column from the table.
Reason - i have a query that pulls all the columns from that same table but renames all of them to increase readability. I cant store the readable columns as headers in the original table as they have special characters and spaces in them.
so the only way is to >> create query to pull those renamed columns by the column names i need.
now bad news - if a new column is added to table, the query has to be updated to include that new column too
so is there query or vba to tell me what columns are in table1 which are not getting pulled by query?
<<so is there query or vba to tell me what columns are in table1 which are not getting pulled by query?>>
That would be doable in VBA. A TableDef(), QueryDef, and Recordset all have a fields collection
The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…