Export to PDF filename creation

J

JohnG

We are using an access db to grade phone calls at a 911 center according to
set standards as part of quality assurance. We then export the file to PDF
and send it to the employee and his/her supervisor. Right now the PDF file
name defaults to a standard filename. What we'd like to do is have the
filename be composed of the answer to a couple of questions on the form.
Specifically the ID number of employee beimg graded and the call number that
was reviewed. Would want it to occur manually when the grader exports the
form to PDF. An example would be 7053_200823457.pdf. Both the employee ID and
the call number are input by the reviewer on the form.

Any suggestions? I don't know much scripting so hopefully it is something
outside of that unless it's a copy and paste solution where I can fill in the
table names.

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top