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 MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: barbarafloyd
- Content: Threads
- Order by date
-
Syntax for calling parameter query from VB
Hi, I have a button which runs a query and copies the contents to Excel eg: strQuery = "MyQueryName" objDB.Execute _ "SELECT * INTO [Excel 8.0;DATABASE=" & strExcelFile & _ "].[" & strWorksheet & "] FROM " & "[" & strQuery & "]" objDB.Close Now I have changed the Query to require a...- barbarafloyd
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
-
problem creating "Unmatched" query
Hi, Im Using Access 2003 and I am pretty new to SQL and am struggling to understand why my query wont work. I have 2 tables and I want to return only those rows from the first table where the joint primary key is not in the second. My code is below, and it returns 0 rows even though I know...- barbarafloyd
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
