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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by BuckHunter1
-
QueryDefs in MS Access
Thanks, DoDo1975. A point of note, the querydef I created was in fact a temporary querydef since I was querying an ODBC data source. Anyway, thanks for the input. If anyone else knows of a novel method to accomplish this, please let me know as it would make my life much easier.- BuckHunter1
- Post #6
- Forum: Microsoft: Access Other topics
-
-
QueryDefs in MS Access
I tried the above code but it did not work. It returned an error "ODBC--call failed."- BuckHunter1
- Post #3
- Forum: Microsoft: Access Other topics
-
QueryDefs in MS Access
Is it possible to create a temporary querydef from records in another temporary querydef (ODBC connection)? For Example: Set qdf = Workspace.CreateQueryDef("qryTemp", "SELECT * FROM SomeTable") Set qdf1 = Workspace.CreateQueryDef("qryTemp1", "SELECT * Fiel1...- BuckHunter1
- Thread
- Replies: 5
- Forum: Microsoft: Access Other topics
