Solved

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

Posted on 2013-01-11
10
2,501 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
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…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

867 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

16 Experts available now in Live!

Get 1:1 Help Now