Solved

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

Posted on 2013-01-11
10
2,610 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
  • 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

The canonical version of this article is on my web site here: http://iconoun.com/articles/collisions/ A companion presentation is available here: http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
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.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

856 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