Need more info what are you trying to do?

Export Reports to PDF

Hello,

I have a printable form in access, it looks like the PDF version of our NCMR forms. Everything is transferring from the input form to the printable form and I am able to print. I need to know how to save the current record to our network drive location. When i try to export as a PDF, it saves all 6,000 records. I am attaching photos.

You need to use the proper filter for your report so it won't print 6000 records.  If you only want to print for the record whose ID field equals 1, then this code will open the report with the filter "ID=1" applied:

     DoCmd.OpenReport "MyReport", acViewPreview, , "ID = 1"

This code will export the report above to a PDF and save it in the specified path:

     DoCmd.OutputTo acOutputReport, , acFormatPDF, "C:\My Documents\MyReport.pdf"

Hello Kevin,

Ii have created a Report, everything is transferring to the report correctly.

I can't get the Report to display the NCMR's in Descending order and When I hit the open report button It is opening the report, but the report is blank.

My code is this:

Private Sub Open_Form_Click()
    DoCmd.OpenReport "1-NCMR Print Form Report", acViewPreview, , "ID=1"
End Sub

"ID=1" is just a placeholder I used to illustrate what a filter expression looks like.  You need to use your own field name and value for it.  E.g.: "[MyFieldName] = MyValue"

If your report uses grouping and sorting, they determine the sort order, so you need to set the sort order in the grouping and sorting settings.  If grouping and sorting are not used, then the "Order by" property on the report's property sheet determines the sort order.

Hello Kevin,

I got it to work. Both Saving and printing. Thank you for all the help!