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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Passing parameter to query in recordset based on previous recordset
Never mind everyone, i figured it out. Rather than calling the query as a dataset, i did a docmd.RunSql with the original query pasted into the sql statement (adjusting the double quotes etc as needed for SQL) passing the parameter in that statement. I did a docmd.setwarnings false before and...- dbnichol
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Passing parameter to query in recordset based on previous recordset
dhookom, perhaps i should explain that this started as code to prompt the user for the number of blank labels to skip, and then the number of copies. Supports a single label quite well. The idea came from them that based on the quantity of product, we know how many labels we will need so...- dbnichol
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Passing parameter to query in recordset based on previous recordset
The problem is that if i don't use code, all labels get the same quantity. I have a table that has the data for label 1, i need 20, then label 2 has a quantity of 35 ... I have to loop through to get each quantity for that particular label data.- dbnichol
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Passing parameter to query in recordset based on previous recordset
The code i am having trouble with is below, but here is the gist of my problem. I run a label report that pulls the number of labels from a field in a table. This all works without a problem. The issue was when the table has more than one record, the code would only use the number of copies...- dbnichol
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
