Search results
-
A
save to PDF based on multi select list box
hi, i have got my save report to PDF working perfectly currently but it only works on a one by one process. Private Sub SavePDFbttn_Click() Dim MyPath Dim PONumber Dim Warehouse Dim SBV Dim Thefilename As String DoCmd.OpenReport "Purchase_Order", acViewPreview MyPath = Me.SaveLoactionTXT &...- Andyrew21
- Thread
- Replies: 3
- Forum: Modules & VBA
-
A
Saving a report as PDF
i have written some VBA to save a report as PDF, its pretty basic but gets the Job done, Private Sub SavePDFbttn_Click() Dim MyPath As String Dim MyFilename As String MyPath = "C:\Data\RFP PO\" MyFilename = "RFPPO" + ".pdf" DoCmd.OpenQuery "qry_full_po_details_by_PO" DoCmd.OpenReport...- Andyrew21
- Thread
- Replies: 4
- Forum: Modules & VBA
-
A
Help with Reports
Hi, i am fairly new to using Access and i am getting stuck on creating a report. i have the tables and queries down but i want to create a Purchase Order file using reports and for each new PO number i want there to be a new page in the report with the details for this PO. whats the easiest...