[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2013-01-11
10
Medium Priority
?
3,073 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
Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

 

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

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

656 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