Results 1 to 4 of 4

Thread: Folder Dialog Option

  1. #1
    Member
    Join Date
    2008-07
    Posts
    6
    Login to Give a bone
    0

    Cool Folder Dialog Option

    Hello everyone,

    I am very good with Access and I know VB (I am not an expert but I understand the code). Here is what I am trying to do with less code as possible:

    1. I want to create a button in Access that will allow me to navigate to a folder (the folder is located in a tree three or four folders down) using the folder dialog option. I do not want to use the commondialog button but would rather hard code if possible.

    2. Once I locate the folder I want to click the folder and automatically import certain files that are in the folder into Access. The folder will contain files such as jpg, doc, txt, xls, xml, and gifs. I only want to import all xml files into Access.

    Is there a simple and quick way to do this? I need to be able to use this in other projects as well.

    Also, I want to call this procedure from a module.

    Thanks to anyone who can help me with this issue.

    Thanks,

    bdthomas02

  2. #2
    Administrator Ed Jobe's Avatar
    Join Date
    2000-11
    Location
    Turlock, CA
    Posts
    5,744
    Login to Give a bone
    0

    Default Re: Folder Dialog Option

    Access has some objects in that area. You can also use Windows dialogs. Search this forum for FileDialogs. It is a class module you can import into your project. It has File open, save as and folder browser dialogs.

    If you don't need the user to interact with dialogs, just use the vbscripting FileSystemObject. Look in vb help for that.
    C:> ED WORKING....

  3. #3
    Member
    Join Date
    2008-07
    Posts
    6
    Login to Give a bone
    0

    Default Re: Folder Dialog Option

    I am new to this forum. Where do I go to search for the information you provided in your response?

  4. #4
    Administrator Ed Jobe's Avatar
    Join Date
    2000-11
    Location
    Turlock, CA
    Posts
    5,744
    Login to Give a bone
    0

    Default Re: Folder Dialog Option

    Look at the top of this thread. There is a "search this thread" link. Above that is a "Search" link and to the left of that are links to the parent forum. Navigate to that, the "VBA" forum, and there is a "Search this forum" link. You can also do this from anywhere using advanced search.
    C:> ED WORKING....

Similar Threads

  1. Folder Browser Dialog for LISP
    By peter in forum Bridging the Gap: LISP -> .NET -> LISP
    Replies: 10
    Last Post: 2014-02-15, 03:09 AM
  2. 2013: New Folder from dialog
    By dgodfather in forum AutoCAD LT - General
    Replies: 8
    Last Post: 2013-01-16, 09:39 PM
  3. Option to Save Imported Files in a Specific Folder
    By inventor.wishlist1738 in forum Inventor Wish List
    Replies: 2
    Last Post: 2012-12-15, 05:43 PM
  4. Inventor Option to Auto-Write DWF's to Project Folder
    By inventor.wishlist1738 in forum Inventor Wish List
    Replies: 0
    Last Post: 2007-10-24, 05:58 PM
  5. Open File Dialog Folder Addition
    By barathd in forum Revit Architecture - Tips & Tricks
    Replies: 0
    Last Post: 2005-02-07, 04:44 PM

Posting Permissions

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