Access 2013 button to save report to Desktop as PDF and use a field from form as the name
Posted on 2014-09-03
Hi all, I have a simple Access 2013 project with a single table. I have setup an entry form that has a field on it called Job#. Currently I have a button at the bottom of the form called 'Print Report' which prints the current record on a named report. What I need to do now is create another button called 'Save' which will pull the Job# off the current form and use that as the name of the file to save, make the file a PDF, and save the file to the Desktop. I am a novice and have never used it before so any detailed help is greatly appreciated. I am looking for the VBA code to use to do the Save. Again, it needs to be saved as whatever the value is in Job# on the current form, on the desktop, and saved as a PDF. Thank you so much!