I am trying to automate the way re****ts are printed in an Access 2003
database - I have ~200 records (people) who require between 5 and 10
customized re****ts (depending on values within certain fields) -
currently I print each re****t by selecting all employees and printing
one re****t at a time - once all re****ts are printed, I manually
collate the packages - I would like to be able to have a combo box (or
other option) highlight the required employees, press one button and
have all related re****ts print for the first employee, then move on to
the second employee, etc - thus each customized package will be
collated on the printer and all I have to do is add a paper clip.
I would use a combo box that displays all employees alphabetically
showing their name and employee number - once selected their employee
number (primary key) is used to select the re****t. I have looked at
using a macro to select the list of 10 re****ts, but do not have enough
experience to know how to code the procedure that will cycle through
the employee's and if they don't meet certain criteria, skip the
printing of certain re****ts.
I am not a programmer by any means but can generally understand code
and modify canned code to make it suit the tasks but for this project
I have not been able find a sample database that would help me
understand what I need to do.
Any help you can provide would be appreciated.
Thanks.
