Solved

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

Posted on 2013-01-11
10
2,428 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 119

Expert Comment

by:Rey Obrero
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 119

Expert Comment

by:Rey Obrero
ID: 38768791
just use the window explorer...
0
 

Author Comment

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

Expert Comment

by:Rey Obrero
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
Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

 

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 119

Expert Comment

by:Rey Obrero
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

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

708 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now