Hello:
Is there a more efficient way of entering hyperlink in MS Access for use as a dynamic link, within the search results page?

Presently I enter the hyperlink in HTML code into Access. It works fine. I was just wondering if anybody knew a better way, or of an automated command for the DB.

Thank You,

Yes select the text or object you want to link and if you click on to the properties and click the little folder icon to link a page you'll get another window. then click on select data sources instead of file sytems and then choose the field where your web address are and that will make it a link without using access to do it. Works great.

Edited by - Lilac Crafts on 10 Mar 2004 04:27:08

Thank you Lilac Crafts:

I did not know about that feature, however I find, I need more control over the hyperlink description in the results page, because it will change depending on the data for that entry.

Here is the short story: I am building a paperless file system at a law firm. Document tiltes change depending on the case. These files are to be searched from a standard search page incorperated into an intranet site. the page will search the MS DB which will serve as a Master file Index. I am tryin to make it esier on the person who will be hired to populate the DB. This person propbally will not know much about dreamweaver.

Any suggestions welcome.

Thank again for your response! <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

Edited by - NathanD on 10 Mar 2004 16:01:46

They wouldn't have to.
Set it uplike this. Make an an insert page that will upload your files and one for the page title. NOw your access database will have fields of ID, File_name, and File_link. Make sure you put underscore instead of spaces in the file names. today_file.htm instead of today file.htm you'll have trouble with access with that.
Now your results page will have only the file_name field in it. Then just click in the properties inspector and click the yellow folder in the link section and click data sources. select the recordset and make sure you select the File_link field.
Now everyone will see the file name but not the link but yet it will link to the page you want.

I will try that, thanks.<img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>