I have a colleague that asked me a question regarding Access that I am sure can be done, and am guessing with some VBScript, but am unsure where to start. So, she has a report that is essentially a performance review with kpi's and other data metrics that is 2 pages per each unique technician. The question is this - she wants to be able to save each tech's individual report in the following way: tech_A-07062012.pdf, tech_B-07062012.pdf, tech_C-07062012.pdf etc. Is this possible at all to do? I know VBScript but do not know all the ins and outs of Access to know where to start with this. Thanks!
Mike