473,778 Members | 1,911 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to SELECT hyperlink.htm FROM table?

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.h tm"

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
2 2293
While I'm on this issue of hyperlinks....

Is it possible to programmaticall y 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******** ***********@new ssvr25.news.pro digy.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.h tm"

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
Is there a way to get the HyperlinkAddres s (stored in the table) when I
reference the HyperlinkSubAdd ress (stored in the form field)?

strHlkAdd = Me!Documents.Hy perlinkAddress

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

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
1508
by: celerystick | last post by:
This is an xsl question, comp.infosystems.www.authoring.stylesheets were not able to help , here goes .... With one xml file containing repeated element <subject>: ....<subject>Accounting</subject> <subject>Business</subject>.. I can apply one stylesheet "Accountingfilter.xsl" that does this :
1
5705
by: Alex | last post by:
I am trying to select a hyperlink from a combobox (web addresses stored in a table) and launch the web site. Selecting from the combobox (ishyperlink=yes) does not launch the site. The same info in a text box does when I click on it. How can I get the Hyperlink to fire when selected from combo box? Any help appreciated. Alex
0
550
by: Ryan Harvey | last post by:
Hi all, I have written a web user control that contains a repeater control. the ItemTemplate for this control is basically 6 Hyperlinks in a row, that are dynamically allocated one of 7 gif images as the ImageURL of the Hyperlink. When a load the page with the controls on it works fine, but sometimes the images are broken, but if i hit refresh i get random selections of the gifs appearing and not appearing. if i hit Back button to a page...
5
6689
by: Martin Dew | last post by:
Having some problems getting a hyperlink object to work in my repeater control, It displays the text I have asked it to for the hyperlink, but it does not act as a link. My repeater code is below but here is the snippet of my asp:hyperlink object; <asp:HyperLink NavigateUrl="authonly/clientdetails.aspx?searchID="+<%#DataBinder.Eval(Conta iner.DataItem,"CLIENTREF")%> ID="Hyperlink1"><%#DataBinder.Eval(Container.DataItem,...
4
4407
by: sakieboy | last post by:
I currently have a datagrid with several columns. The first column in the DataGrid is a HyperLinkColumn. When I select a row, I would like for this HyperlinkColumn to fire. I have the mouseover colors changing, and I have the routine, but I can't seem to get the HyperLinkColumn to fire.... Private Sub MyDataGrid_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles...
2
1764
by: jodyblau | last post by:
I am trying to go through a list of files in a folder and then add a hyperlink to each one in a table. I am having a difficult time figuring out how to add that link into the table and do it in such a way that the entire path isn't displayed in the record, just the document name (just like I can make it look if I add the hyperlink by hand and then edit it using the dialog.) I have tried figuring it out using this article: (but I still...
5
21240
by: NJonge01 | last post by:
Greetings, I've read some great advice on similar topics, just nothing matching exactly what I'm trying I'm pretty close I think on making this work, but note quite there. I want to print a report that basically displays photographs. the photographs are located on a web server viewable from my browser. I want to reference the URL and "pull" them into my report at print time TABLE: In a Table, I have a field defined as Hyperlink. ...
5
8809
LAD
by: LAD | last post by:
Using Access 2003 on Windows 2000. My Skill Level: Med Low (Some VBA, okay with Access) Form: Single View - based on Query of single Table to sort by field. Application: Dealers email 'contract packages' that include as attachments: a contract (PDF or TIF), a pricing tool (Excel), a companion document (Word). Clerks detach these files into a shared drive file on our intranet. I'm building an 'contract package management' application...
10
3008
by: sierra7 | last post by:
I'm trying to create a form where a user enters a document reference number and then clicks a command button to add a hyperlink to the document, via a file picker. Thanks to Adezii's excellent article http://bytes.com/topic/access/answers/725778-inserting-hyperlink-into-table I can manage to create a hyperlink to the document and store it in the table, but it is the full hyperlink path not the reference number of the document that is...
0
9629
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9470
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9923
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6723
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5370
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5500
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4033
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3627
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2865
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.