Recent content by firshad

  1. F

    Multiple prints form Single Report for Individual Accounts

    JHB, Thanks for your quick reply, error is in the Set RS, #Set rs = db.OpenRecordset("SELECT [AccountReference] FROM qryL_Inv2", dbOpenDynaset# Thanks
  2. F

    Multiple prints form Single Report for Individual Accounts

    Now i have made some changes to the code. Some how it does work with the table but when i change the setrs to a query it start giving me error of 3061 with expected 2. Private Sub Command43_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim MyFileName As String Dim mypath As String...
  3. F

    Multiple prints form Single Report for Individual Accounts

    Hi, I have a report , which i print every month and it consist of of more than 500 pages. This report is based on a Query called L_Inv2. i want to filter and loop this report based on the filed AccountReference with in the query. And save as PDF for individual accounts. i have also created...
Back
Top Bottom