Recent content by Andyrew21

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 &...

Ok so i need to make a form first and then a report? what i have done is create a Query the created a form where i input a from and to date, this returns all PO numbers in that period. then i have a Report that uses the selected po number in the PO number list to create the report. i am then...

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...

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...