Open selected file in listbox

[constantG]

Hi,

I am using this:
http://www.everythingaccess.com/tutorials.asp?ID=List-files-recursively
to show files in a listbox. Just as one of the replies asks, I too would like to know how to allow users to open the selected file.

Thanks

 

[DCrake]

What version of Access are you using?

 

[constantG]

It will be running on 2003

 

[DCrake]

Take a look at this demo it may help you with your quest. It has a variety of uses but does what you want.

 

[constantG]

I have this file already and when opened the reference for the common dialog produces an error. I am working on a 2007 version at home but the DB is to be implemented on a 2003 system.

 

[DCrake]

Reason I asked is because it will not run under 2007 as Application.Filesearch has been lost in this version.

 

[constantG]

Ahhh ok. So it will work as expected on my works PC which is 2003?

 

[DCrake]

tried and tested on 2003.

If you look as the API declarations on the form and follow it through to the double click event of the list box you will see that there is no shell command to launch the native app. It will decide for itself what software to use to open the file, be it a pdf, xls, txt, etc.

 

[constantG]

Just wondering how long it will be before the company updates to access 2007 and whether it's worth implimenting this code. Anyway, thanks for the help. BTW I checked out the link you sent me, some very interesting ideas.