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

Create a Query on a Hyperlink

P: n/a
Have '97 and am trying to create a query on the underlying Hyperlink
field - ie if xxx then else ...
Can't find a way to do this and would very much appreciate some kind
help - thanks - John

Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Not sure I understand your example. Can you explain what xxx is supposed to
be?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Gamesetal" <in**@gamesetal.net> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
Have '97 and am trying to create a query on the underlying Hyperlink
field - ie if xxx then else ...
Can't find a way to do this and would very much appreciate some kind
help - thanks - John

Nov 13 '05 #2

P: n/a
Sorry - that wasn't too helpful of me - The hyperlink field will have a
legend in a search, form or table - the hyperlink under this -
activated when clicked upon - is what I want to search on - that could
be a link to a variety of web pages - I can't seem to query at the
hyperlink depth just the field image - God am I making this any
clearer? - so if Hyperlink = www.xxx.com then show in the query results
[ criteria = www.xxx.com ] - honestly this has nothing to do with sex
sites ;~)
Hope this explains my problem.

Nov 13 '05 #3

P: n/a
Gamesetal wrote:
Sorry - that wasn't too helpful of me - The hyperlink field will have a
legend in a search, form or table - the hyperlink under this -
activated when clicked upon - is what I want to search on - that could
be a link to a variety of web pages - I can't seem to query at the
hyperlink depth just the field image - God am I making this any
clearer? - so if Hyperlink = www.xxx.com then show in the query results
[ criteria = www.xxx.com ] - honestly this has nothing to do with sex
sites ;~)
Hope this explains my problem.

See HyperlinkPart in help. In VBA, you can use acAddress and acDisplay
in HyplerlinkPart. In a query, you need to use the value of acAddress
or acDisplay. To find the values, go to the Immediate/Debug window and
enter
? acDisplay
to get the value.

Now, if you break the hyperlink apart, clicking on that value in the
column will not execute a jump to the link. So you might have something
like
Select Hyperlink from Table Where HyperlinkPart(hl,2) = "www.xxx.com"
Nov 13 '05 #4

P: n/a
Thanks for that but I am a layman and don't know a thing about VBA??? -
can I do this at the Access Query Level without resorting to
programming?
TIA - John

Nov 19 '05 #5

P: n/a
Thank you all - I have managed it at the Query level using
HyperlinkPart and guessing [? sorry] at the part number... John

Nov 28 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.