Results 1 to 2 of 2
  1. #1
    tcheck is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Nov 2010
    Posts
    131

    Header and Footer


    One of our vendors needs data from a table with a header (as HD) and a footer (as FT). The header is easy but short of converting the query to a report, how do I send CSV file with a footer as the last line. Thnks in advance.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    CSV file is a text file that can be edited with word processor app. Notepad will do. If you want to automate adding line to the CSV, need to open the CSV file as an object in VBA write new line then close the object.

    Google: Access VBA append to text file
    http://www.devhut.net/2011/06/06/vba...o-a-text-file/
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. header and footer
    By slimjen in forum Forms
    Replies: 2
    Last Post: 10-03-2011, 08:10 PM
  2. Replies: 3
    Last Post: 08-31-2011, 02:34 PM
  3. Replies: 3
    Last Post: 01-13-2011, 03:53 AM
  4. Footer Totals
    By allenjasonbrown@gmail.com in forum Reports
    Replies: 3
    Last Post: 09-30-2010, 09:40 AM
  5. Page Footer
    By jamil_kwi in forum Access
    Replies: 1
    Last Post: 05-31-2010, 04:02 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums