Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Dynamic Access Query Objects
- Thread starter gharabed
- Start date
tomschafer
Technical User
This should help to get you in the right direction.
Dim qry_Query As QueryDef
Dim str_SQL As String
Set qry_Query = CurrentDb.QueryDefs("QueryName"
str_SQL = "select name from msysobjects where type="
qry_Query.SQL = str_SQL
Dim qry_Query As QueryDef
Dim str_SQL As String
Set qry_Query = CurrentDb.QueryDefs("QueryName"
str_SQL = "select name from msysobjects where type="
qry_Query.SQL = str_SQL
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question