Results 1 to 3 of 3
  1. #1
    davedinger is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Nov 2017
    Location
    South Dakota
    Posts
    63

    Browse to file location button

    Background Information:
    Im working on a Document Management Program idea and I have a snag that should be simple but im not sure how to get it to work.
    Basically we have a ton of company traning documents but no real good way of organizing them. So my plan is to dump them all into one folder named "traning_docs"



    The access part of this is very simple. Its jsut going to be used as a index to all of the files. Basically when someone puts a file in the Traning_docs folder the will let me know. the user or administrator I will make a record in access that contains fileds like document name field / a category field / and others to help the user search/ all of which are not relivant at to this issue but gives you a background


    Now for the issue:
    I need to create a button on a form that will allow the users to browse the windows directory so that they can attach the file location and store it in the field named "Location_Field"

    Any thoughts,Thanks

  2. #2
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,250
    Have a look at the FileDialog:

    https://docs.microsoft.com/en-us/off...ion.filedialog

    Cheers,
    Vlad
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  3. #3
    Micron is offline Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,422
    In addition to what's been suggested, are you going to use Access to serve up the document? Is this doc management system going to track revision history, approvers, status, etc. much the same as an ISO type of system?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Replies: 8
    Last Post: 09-15-2019, 07:37 AM
  2. Command Button - send a file to a network location folder
    By 9944pdx in forum Database Design
    Replies: 4
    Last Post: 02-12-2018, 10:53 PM
  3. Replies: 21
    Last Post: 06-26-2014, 02:59 PM
  4. Replies: 22
    Last Post: 02-22-2014, 02:51 PM
  5. Button to Browse for File!
    By floyd in forum Forms
    Replies: 5
    Last Post: 08-23-2013, 09:09 AM

Tags for this Thread

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