Results 1 to 10 of 10
  1. #1
    Join Date
    Jun 2004
    Posts
    5

    Unanswered: Copy the file information from a directory

    How can I do the following?
    Copy the file information from a directory to a table in access

  2. #2
    Join Date
    May 2006
    Posts
    18
    What 'information'?
    Are you talking about the list of the files/directories names, content of the files, or...???

  3. #3
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Check out the third post here
    Last edited by gvee; 11-11-07 at 13:36. Reason: link corrected
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  4. #4
    Join Date
    Jun 2004
    Posts
    5

    copy files in directory

    yes basically I want to upload PDF type files in a directory.
    Then from access I want to read the DIR and of course the bring up the file a selected file to read.

    BTW Im not a programmer but have developed serveral progams in DB2, DB3 and of course Access. Not elegant but they get the job done.

    I vision being in a certain record in Access with a button that is linked to a specific directory. Push the button and a grid will POP -UP with the files in the directory listed. Than the user will select the applicable file and it will come to read.

  5. #5
    Join Date
    Jun 2004
    Posts
    5
    Loquin,

    The link provided doesnt seem to work.

  6. #6
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Link corrected.
    George
    Home | Blog

  7. #7
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Here's an example which will let you read and store the directory files of the specified file type into a table. You can see a listing of that table and click on and launch the file. It uses similar code in the example loquin posted with some added enhancements.

    http://www.dbforums.com/showpost.php...8&postcount=40
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  8. #8
    Join Date
    Jun 2004
    Posts
    5

    Thumbs up Thanks

    Thanks to both PKStormy and GeorgeV.
    Got the file and read the info.
    I will try to use the info to resolve my issue.

    ACE

  9. #9
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I think you meant
    Thanks to both PKStormy and Loquin
    But you're welcome nevertheless
    George
    Home | Blog

  10. #10
    Join Date
    Jun 2004
    Posts
    5

    Appoligies

    Yup! you are correct about GeorgeV thanks.
    BTW my name is George also has to be a good guy ;}

    One other thing I actually developed a very simple solution to my little problem.

    I created a Macro using Runcommand and openURL.
    Not fancy but works.

    Basically staff saves PDF's to a specific Dir on server.
    Added a button to the forms to run Macro.
    From the form they find the file view and close.

    This is a DB that tracks contracts and all letters/amendments/and other document files etc

    once again Thanks.

Posting Permissions

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