How to SELECT hyperlink.htm FROM table?

[deko]

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!

[deko]

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!

[deko]

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