By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,588 Members | 1,089 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,588 IT Pros & Developers. It's quick & easy.

How to SELECT hyperlink.htm FROM table?

P: n/a
Is there a special syntax for hyperlinks in queries?

I have a table of hyperlinked documents displayed in a subform datasheet.
Clicking the hyperlink opens the document from the hard drive.

I have an Autonumber field (Doc_ID) in the table that indexes the documents,
but sometimes the same hyperlink can have different Doc_ID's, so I need a
query to find the hyperlink in the table. For example:

SELECT Entity_ID FROM tblDocuments WHERE Document = "My Hyperlinked
Document.doc"

-- or --

SELECT Entity_ID FROM tblDocuments WHERE Document = "My_html_page.htm"

But these queries don't work...

I've tried this:

SELECT Entity_ID FROM tblDocuments WHERE Document = "#My Hyperlinked
Document.doc#"

but that didn't work either...

any suggestions welcome!

Thanks!
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies

P: n/a
While I'm on this issue of hyperlinks....

Is it possible to programmatically set the Hyperlink Base property for my
database?

Also, what if I store the UNC path to the document as a text field in the
table (in order to avoid hyperlink base issues) -- how then do I open the
document when clicking on it in a subform datasheet? Access seems to know
how to open documents when I format the table field as Hyperlink, but not if
I use the UNC path (formatted as text) in the table.

Thanks again...

"deko" <dj****@hotmail.com> wrote in message
news:Cc*******************@newssvr25.news.prodigy. com...
Is there a special syntax for hyperlinks in queries?

I have a table of hyperlinked documents displayed in a subform datasheet.
Clicking the hyperlink opens the document from the hard drive.

I have an Autonumber field (Doc_ID) in the table that indexes the documents, but sometimes the same hyperlink can have different Doc_ID's, so I need a
query to find the hyperlink in the table. For example:

SELECT Entity_ID FROM tblDocuments WHERE Document = "My Hyperlinked
Document.doc"

-- or --

SELECT Entity_ID FROM tblDocuments WHERE Document = "My_html_page.htm"

But these queries don't work...

I've tried this:

SELECT Entity_ID FROM tblDocuments WHERE Document = "#My Hyperlinked
Document.doc#"

but that didn't work either...

any suggestions welcome!

Thanks!

Nov 12 '05 #2

P: n/a
Is there a way to get the HyperlinkAddress (stored in the table) when I
reference the HyperlinkSubAddress (stored in the form field)?

strHlkAdd = Me!Documents.HyperlinkAddress

This returns an error: Error Number 438: Object doesn't support this
property or method
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.