Solved

how to show a tree view of files and folders in ms access using vba

Posted on 2013-01-11
10
2,686 Views
Last Modified: 2013-01-16
How to show tree view of files and folders starting from a specific directory.

Also whne I get inot files I want to be able to open that specific file.
0
Comment
Question by:maximyshka
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
10 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38768739
0
 

Author Comment

by:maximyshka
ID: 38768773
i need to see a treeview of diirectories and files but not data from db
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38768791
just use the window explorer...
0
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 

Author Comment

by:maximyshka
ID: 38768794
how do i insert windows explorer in access form?
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38768807
why do you need to insert it, you can open it with

followhyperlink "c:\"

that will open the window explorer  in c:

followhyperlink "C:\Program Files"

opens the window explorer to Program files folder
0
 

Accepted Solution

by:
maximyshka earned 0 total points
ID: 38768950
I found what i was looking at the url below. Very nice written code.

http://www.access-programmers.co.uk/forums/showthread.php?t=102667

I had a need to make it within a form for a security reasons. User chave to be directed to a specific folder and ONLY that folder. I did not want to expose any other directories or explorer functionalities.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38768999
<No Points wanted>

I agree with capricorn1,

<Also whne I get inot files I want to be able to open that specific file. >
...then all you have to do to open the file is simply right-Click the file and select: Open
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38769524
the answer you found, will only display your folder and files.

will you still use it?
0
 

Author Comment

by:maximyshka
ID: 38778604
It is also allows double click on files to open it. So it works
0
 

Author Closing Comment

by:maximyshka
ID: 38782021
All other answers did not provided what i was looking for. I have found answer myself.
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question