Consulting

Results 1 to 20 of 27

Thread: split data into individual groups

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #20
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,297
    Location
    OK, here is the database, it has a form called save files with 2 command buttons on it, save group files and read file.

    This line of code is where it puts the files on my disc drive, you will need to change it to where you want them to go.

    Open "C:\Access Databases\" & groupname For Output As #1


    There are message boxes in the code telling you which group is being actioned and what data is being sent to the file, you obviously won't need them in your version.

    The read file button only reads one file to check that they have data and you won't need it in your database.
    Attached Files Attached Files

Posting Permissions

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