How would I change the SQL statement behind a particulary query using vba .
D Duane Hookom Aug 14, 2004 #2 You can use code like: Currentdb.QueryDefs("qselYourQuery").SQL = "SELECT ...." This requires a reference to the DAO object library. -- Duane Hookom MS Access MVP Breeze said: How would I change the SQL statement behind a particulary query using vba Click to expand... ..
You can use code like: Currentdb.QueryDefs("qselYourQuery").SQL = "SELECT ...." This requires a reference to the DAO object library. -- Duane Hookom MS Access MVP Breeze said: How would I change the SQL statement behind a particulary query using vba Click to expand... ..
