Lookup and open files

[jpr]

Hello,

I would like to create a sort of lookup form with two listboxes. The
firts should read all the drives on my workstation. According to the
drive selected, the second listbox should display all the files it
containg. I would then need to open these files with the double click
event. I am not trying to replicate MyComputer functions but would like
to add this little tool to my database.

Any help or sample? Thank you.

[chris.nebinger]

Well, looking here: http://mvps.org/access/api/api0003.htm will give
you all the drives. You could add these to a list box (or, treeview,
even better). On the click event, you could use the DIR function to
list all files in a second list box (bonus points for listview). Using
the double-click even:

Application.FollowHyperlink FullPathToFile

Chris Nebinger
jpr wrote:

Hello,

I would like to create a sort of lookup form with two listboxes. The
firts should read all the drives on my workstation. According to the
drive selected, the second listbox should display all the files it
containg. I would then need to open these files with the double click
event. I am not trying to replicate MyComputer functions but would like
to add this little tool to my database.

Any help or sample? Thank you.

[pietlinden]

jpr wrote:

Hello,

I would like to create a sort of lookup form with two listboxes. The
firts should read all the drives on my workstation. According to the
drive selected, the second listbox should display all the files it
containg. I would then need to open these files with the double click
event. I am not trying to replicate MyComputer functions but would like
to add this little tool to my database.

Any help or sample? Thank you.

This is a pure VB question. Only tangentially related to Access
insofar as VBA can do this kind of thing. Look it up on VBNET.
http://vbnet.mvps.org/

[jpr]

Thanks for your help. I have seen the code and paste it into a new
module. But I cannot get it to work as I am quite new to Access and do
not know much about VBA. Could anyone help me with some sample
database? Thanks.

[chris.nebinger]

Probably not. What you're asking is not a basic type question. It is
more immediate to advanced task.

I'll dig around what i have and see if there's anything that will do
what you want, but I wouldn't put your project on hold for it.

Chris Nebinger

jpr wrote:

Thanks for your help. I have seen the code and paste it into a new
module. But I cannot get it to work as I am quite new to Access and do
not know much about VBA. Could anyone help me with some sample
database? Thanks.

[jpr]

thanks for your reply. I appreciate your help. Perhaps you could guide
through the code you had suggested. Thanks.

ch************@gmail.com wrote:

Probably not. What you're asking is not a basic type question. It is
more immediate to advanced task.

I'll dig around what i have and see if there's anything that will do
what you want, but I wouldn't put your project on hold for it.

Chris Nebinger

jpr wrote:

Thanks for your help. I have seen the code and paste it into a new
module. But I cannot get it to work as I am quite new to Access and do
not know much about VBA. Could anyone help me with some sample
database? Thanks.