Results 1 to 4 of 4
  1. #1
    Rev12 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2016
    Posts
    11

    display folder and its sub folder after selection of Drive in my Combo box

    Dear Experts,

    I have a form name Folder_File with one unbound combo name CboDrive three unbound listbox LstFolders, LstSubF and LstFiles.

    I need a help to build my code to have this to work,

    Ex. After select for drive B:\ a list of folders are populated in my LstFolders after a double click it could display both my sub folders in my LstSubf and the documents in my LstFiles in that folders.
    LstFolders LstSubF LstFiles
    Rev_12 Manuals Photo.jpeg
    Letter.docx


    after double click on sub folders (LstSubF)


    LstFolders LstSubF LstFiles
    Rev_12 Completion 1.pdf
    2.pdf


    3.pdf
    4.pdf
    so on......
    Can access to this stuff?

    Please refer to attachments for the format of my Form.

    Appreciate any kind help, thanks in advance
    Rev12
    Attached Files Attached Files

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    You may get some insight from this site.
    or this article from Allen Browne or
    M$oft

    Good luck with your project.

  3. #3
    Rev12 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2016
    Posts
    11
    orange, I really appreciate your response.

    However I added a new Form with a List box and copy the those codes as per the article but no results.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    The links were meant to give you some samples and alternatives and info to assist with your "issue".

    Which article? What code? Any errors?
    You may want to post your database(zip format) with instructions to repeat what you have tried.

    Did you review FileSystemObject methods?

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

Similar Threads

  1. VBA code to create a folder on a shared drive.
    By tgall in forum Programming
    Replies: 4
    Last Post: 01-08-2016, 11:39 AM
  2. Replies: 10
    Last Post: 09-09-2015, 03:25 AM
  3. Replies: 1
    Last Post: 05-15-2015, 10:58 AM
  4. Replies: 4
    Last Post: 06-27-2013, 12:29 PM
  5. open folder/Make new folder(example)-VBA Code
    By Madmax in forum Code Repository
    Replies: 3
    Last Post: 03-13-2012, 09:17 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