Have an existing Access file that allows me to create a simple Windows Explorer type environment to view folders and files.
(This is not my file but is allowed to be used as part of an application.)
I need to be able to set it to a selected root folder. (Which will be always changing.)
At the moment it automatically uses My Computer as the root folder, displaying C:, D:, E:, Etc folders beneath that.
I want to it be able to set the root folder to, say, 'C:\Test'
but I just cannot get it to use a chosen folder as the root folder.
I wish to do this as I do not wish users to move up outside of the root folder, only down inside.
So, in a nutshell, I need the Root folder of the left panel to be set via VBA variable to whatever I select. You can use any sub folder beneath C:\ as a test.
The actual folder address, in practice, is a separate text feild assigned to each record.
Dear Client,
As your description you would like to change the disk drive list (which auto load from system) to manual. The updated application needs to load only selected folder as root folder and use only can go further to sub-folders but not out the root folder.
Furthermore, this look MS-Access 97-2003 file format. If you are using new version of MS-Access we can change to newer version too.
Thank you.
Regards,
Shiv
Hi,
I am an expert in MS Excel, MS Access, SQL database production and management. I have over 7 years of experience in working with all of the databases and analytics. I have gone through your requirement and am confident that I can do this for you.
So lets discuss this project in detail and start at your earliest convenience. I can guarantee you the best possible work in least possible price.
I'm Microsoft Access expert. My english level is basic. If you dont care, i would like to help you.
One of the last microsoft access apps developed by me uses create (if it doesnt exist), and store in folders.
I´m moderator from 12 years ago in mvp-access co-m
****I DID IT!!!****