Export to PDF filename creation

  • Thread starter Thread starter JohnG
  • Start date Start date
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!
 
Back
Top