Questions about Hyperlink and how I can edit them

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a question about a hyperlink I want to put in a form.
I want the user to be able to browse in Windows Explorer and assign a file
name to an existing hyperlink.
I know I can do so in "design mode" but I want to know if the user can edit
the hyperlink content himself.
If not, is there a way to create a table from the content of a folder on my
disc ?
So this way I would create a dropdown field and the user could select a file
name that he could assign to the existing hyperlink ?

Thanx !
 
Hi,
there are several methods you can use.
Personally I would not use a hyperlink datatype, but rather a text datatype
field. Then you can either use this:
http://www.mvps.org/access/api/api0001.htm

To call the standard windows open/save dialog so the users can browse to the
file. This function will then return the full path to file which you can then
store.
OR you can fill a listbox/combobox with a list of files of a specified
directory and then use the users selection as the value. You would need to
loop through the folder using the DIR() function.
HTH
Good luck
 
Back
Top