Driver File selection...

[vividor]

Hi!! guys, I do not know if this is posibble but any suggestions will be appreciated.
I have a field on a form where I want it to be able to select the Driver (C, D, E, F, etc...) and type or select the name of the file.

Also, I want to be able to go into the table itself and make the whole colum like a link... you know!! If I click on any of the names on that colum automaticly will open the file for me..

Any good ideas, anybody? thanks in advance..

 

[The_Doc_Man]

Your problem requires a couple of advanced actions but is mostly doable, with reservations.

As to finding the file using a search, what you want is the FileOpen option of the Common Dialog box. Search this forum for a virtual plethora of discussons on Common Dialog box. Using some VBA code to help drive the operation, it is possible to store a fully qualified file specification for any file that can be reached by the FileOpen dialog box.

As to making one field a hyperlink, here is where the reservations come in. If the database is shared by multiple users, be warned that not all users will have all required libraries and conversion wizards installed unless you are incredibly lucky. Particularly for foreign (i.e. non-Office) file formats, the conversion wizards can only be installed using a custom installation dialog.

Using the New Table wizard, it is a piece of cake to declare a field to be used as a hyperlink. But if the file in question requires an application that isn't on your machine, you still won't be able to open it.

Suppose, for the sake of argument, that you happened to store a file of type .PDF, but your computer doesn't have any version of Adobe Acrobat Reader installed. When you click on the link, it will try AND FAIL to launch a viable application for that file type.

 

[vividor]

Thank you for the good idea, I think it is simple...
By the way, this is going to work fine because only 1 or 2 persons will have access to this database and the type of file we are going to be using are (txt or html )...
thank you very much...