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 cola125
-
Setting criteria in a query with VBA
I am looking for something like this below. The difference is that this is filtering a report. I want to filter a query and append to a table. Function Level_Five() Dim rs As Recordset Dim CC_Criteria As String Dim rpt As Report Dim FileName As String Dim Path1 As String Dim Path2 As...- cola125
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Setting criteria in a query with VBA
field1 is in query2. Say the first value in query1 is 373. I want the code to open query2 and place "373" in the criteria for field1. The query will append all records where field1 = "373" to the table. The idea behind the looping is that the code would open query2...- cola125
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Setting criteria in a query with VBA
Very junior question, but I am stuck. I have a query ("Query1") that contains a list of numbers. I want to run an append query ("Query2") that sets the criteria for a field ("field1") based on the value in query1. What I have in mind is code that opens query2...- cola125
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
