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
- 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
hiya! Thanks to everyone for their help, this is a great site!! Cheers Barbara- barbarafloyd
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
problem creating "Unmatched" query
Hiya, Thanks for the tip, Ive done what you said and got it to work, thats fantastic! If anyone knows what is wrong with my original post let me know though, as i still cant get my head around why it wouldnt work! Thanks! Barbara- barbarafloyd
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
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
