List of drives

[bujin]

Hi

Since Access 97 doesn't seem to allow use of the File Open Dialog box, I am trying to write my own crude version. Basically, I want to display a list of drives, then when a drive is clicked, to display the files and folders within that drive, and in each subsequently clicked-on folder, until a button is pressed and the file or folder name and path are returned.

I already have ideas on how to actually work this, using the DIR function, but I want to know how to get a list of the drives for the computer.

Would appreciate any help.

Thanks.

 

[nickjar2]

Hi Bujin,

If u give me your email address I have something that MAY help you. It doesn't actually list the drives, but opens up something similar to the common dialogue boxe. You may be able to modify it for your needs.

Nick

 

[bujin]

Thanks Nick

My email address is: gjh@yale-wrexham.ac.uk

Much appreciated.

 

[nickjar2]

Can't beleive u live in wrexham. I lived there up uintil 1998. Can u bear with me. My email isn't letting me send attachments at the mo.

Nick

 

[THoey]

If you look at the following thread, or do a keyword search on "file open", this has been discussed several times:

thread705-74074

Hope that helps... Terry M. Hoey

 

[bujin]

Thanks for your help. I found a solution on another thread (181-55041) to locate a folder and return the path.