Recent content by mavesan

Hi Trevor Thanks very much for your work, that works good except that it pdf the full report, it doesnt break it into each invoice for each customer. Any chance you could have a look on this? Thanks and Regards

Hi Trebor Thank you very much for all your help I have made a mini copy of the db with the bits that I need to pdf, the report is called "invoices to PDF" The main ID is the invoice number called [ID] Also when i output the file in pdf i would love to call that file as [Invoice Date]...

Hi Trevor I tried the link and I have modified the VBA to my data base but still wont work. I am not sure if I have done it properly as i am not use to work with VBA, This is what I got Private Sub Toggle9_Click() Dim MyDB As DAO.Database Dim MyRS As DAO.Recordset Dim strSQL As String Dim...

Hi Trevor, Thank you for your reply, I have tried the code and done the modifications, it works but it outputs the whole report in one pdf file. I need to output the 180 records in the report in 180 pdf files, not sure how to do this. Thansk

Hi There, i am quite new to Access and I am finalaising a db that will produce invoices. I have created a report that contains all the customers that i want to invoice for the month but i need to export the records of this report as independent pdf files. I know that i have to built a loop...