How can I change the table used by a querie with VBA?
A Allen Browne Nov 28, 2003 #2 Assign a new string the the SQL property of the QueryDef, e.g.: dbEngine(0)(0).QueryDefs("MyQuery").SQL = "SELECT FROM MyNewTable ...
Assign a new string the the SQL property of the QueryDef, e.g.: dbEngine(0)(0).QueryDefs("MyQuery").SQL = "SELECT FROM MyNewTable ...
