H
Hallgeir
This is a bit advanced for me, but I hope someone can help!
I have a recordset "rsCustomer" with the fields "Custno" and "Filename"
I have a query "qryNumbers" also containing, among other fields, "CustNo".
This query hold records for many different customers.
My masterplan was to loop through the recordset and save different excel
files for each customer containing only this customers records. I started
out with something like this:
Do Until rsCustomer.EOF
DoCmd.OutputTo acOutputQuery, "qryNumbers", acFormatXLS, ,
rsCustomer!Filename
rsCustomer.MoveNext
Loop
My problem is that there is not a possibilty (as far as I can see) in the
OutputTo method to put in something like "where CustNo = rsCustomer!CustNo".
So my problem is; How can I filter my query "qryNumbers" based on the field
"CustNo" from my recordset. Maybee this is a completly wrong approach, but I
appreciate any tips or hint.
Regards
Hallgeir
I have a recordset "rsCustomer" with the fields "Custno" and "Filename"
I have a query "qryNumbers" also containing, among other fields, "CustNo".
This query hold records for many different customers.
My masterplan was to loop through the recordset and save different excel
files for each customer containing only this customers records. I started
out with something like this:
Do Until rsCustomer.EOF
DoCmd.OutputTo acOutputQuery, "qryNumbers", acFormatXLS, ,
rsCustomer!Filename
rsCustomer.MoveNext
Loop
My problem is that there is not a possibilty (as far as I can see) in the
OutputTo method to put in something like "where CustNo = rsCustomer!CustNo".
So my problem is; How can I filter my query "qryNumbers" based on the field
"CustNo" from my recordset. Maybee this is a completly wrong approach, but I
appreciate any tips or hint.
Regards
Hallgeir