Hyperlink Record

  • Thread starter Thread starter RobVT
  • Start date Start date
R

RobVT

Hey all, using MS Access 2000.

I've created a form that allows the database user to browse for and
insert the file path for a video library of sorts. I used the standard
"Browse" code located at http://www.mvps.org/access/api/api0001.htm.

That works just fine. However, once the hyperlink is input into my
table, I can not click on and follow that hyperlink from the actual
table or a query. I know it has something to do with the data type,
but I can't seem to figure out where I need to alter the code found at
the above-mentioned website in order to get the string inserted as a
hyperlink.

Has anyone else had troubles with this same thing? According to the
sources on here, the fix for it is to add a "#" to each end of the
string, but that's of little use when I don't know where the string is
called out.

Thanks in advance!

Rob
 
To change the data type in your table open it in design view. Change the data
type for that particular field to hyperlink.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top