Dafydd has attended:
Access Advanced course
Access VBA
I have a report where I select a staff member from a list / table, and it runs a make-table query then opens opens a report showing me their performance.
Is there a way of iterating through these and printing each one off automaticall? - that is WITHOUT having to select each one in turn.
RE: Access VBA
Hi Dafydd
Thank you for your question
It is certainly possible to automate the above process by writing a couple of procedures in a module. The first procedure would cycle through each employee in the relevant recordset, and then pass that name to a procedure which would run a query with that employee as the parameter. It would then build a report based on that query.
This would require a good knowledge of Access VBA as covered on our access vba course
Regards
Stephen
