Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Location
    Eastern Pennsylvania, Pennsylvania, USA
    Posts
    97
    Thanks
    0
    Thanked 0 Times in 0 Posts

    vba report print to .txt (97sr2)

    I am writing code in a report module to print report data to a .txt file. There are 5 fields in the 'header', and the rest of the fields in the report 'section'. I need the first textfile lines to be the fields in the 'header' (printed ONCE), and the rest of the textfile to be the records in the report 'section'. Is therer a way to loop through the records so I can write them all, one after the other? My code now writes the header data and only one record. Any help is greatly appreciated.....

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: vba report print to .txt (97sr2)

    Instead of looping in the detail section of the report (I don't know if it is possible), use the recordset that is in the recordsource of the report.
    Francois

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •