Help With Hyperlinking
Nov 3, 2005
Hi all,
Just looking for a bit of help with hyperlinking on a form. Basically, I am adding a 'read more' function to a quiz program I am writing.
I have a label simply called 'Read More' that sits on the form. I need to set a hyperlink to this label, that is looked up from the DB as the hyperlink changes each time the form reloads.
From a simplistic view - I have a table "tbllink", with two fields, 'ID' and 'hyperlink'.
I have tried using a simple DLookUP query as the hyperlink, but access does not recognise this as a piece of code and thinks it is the actual address of the link.
=DLookUp("[hyperlink]","tbllink","[ID] = " & [ID])
Just wandering if there is an easy way to work this?
Thanks in advance
View Replies
Jun 5, 2005
First of all I would like to say a big hello to all on the forum. Great info and great reading for newbies Like myself
I am very new to access and I'm using the 2002 version.
Problem:
I have a form with a textbox, I want to add a button on the form to open the hyperlink browser. After I select the location of the file I want that URL to be entered into the textbox as a hyperlink. This has been bugging me now for 3 days. As I say I am a real, real newbie so any help would be much appreciated.
Thanks in advance.
View 2 Replies
View Related
Aug 7, 2007
I was wondering if its possible to.... In my business, we test electronic components. When one fails, it gets documented as a test error, and the document is named TE-XXXX YYY where XXXX is a four digit number and YYY is a code of some sort. is it possible that in a table, When TE-XXXX YYY is entered, it only recognizes "TE-XXXX" which hyperlinks to microsoft word document in a folder that gives more information about the test error. Thanks in advance!
View 3 Replies
View Related
Oct 29, 2006
hey all,
I would very much appreciate any help or ideas on how to do this as I am stumped.
I need to develop an access database to track documents but also link to them.
I’ll explain what it needs to do;
Every day there is a numbered (and titled) Word format document that is sent.
Most, but not all of the time an accompanying excel file is also sent. The excel file is used for updates to the word document of the same name.
Lets say the word document is titled DW101.1.doc and the Excel file is called DE101.1.xls
The first would signify it is a Word document by D (being short for Document) and W for Word.
The 2nd would be D for document and E for Excel, and then a number which is 101.1.
They are saved in a folder on the hard drive.
Each time these documents are recd then the Access Database is opened and info about those documents is entered. The document name, date, subject, number etc.
There will also be 3-4 fields that are also filled out with terms from the content of the document that could be searched by those 3-4 fields.
So as each document is recd, it’s opened and ‘scanned’ for relevant terms and or content.
That content is what will be filled in the search fields and then the subject will be the ‘main’ searchable item.
All this so far I can do with no problem.
It’s this part that’s making me crazy.
What I would really like to do is when the document(s) come in and are saved in the folder, from access you can open a dialog box, browse to that folder, and click in the file to associate it with the entry you are making for it in the database.
That way when a search is done with terms or words or subjects that match that document it will bring up the results of the search as a hyperlink that will open that document.
The people that will be using this are not very computer literate to say the least.
I could create a link to the document but I would have to be in design mode and it won’t show up as a record in a table.
Any ideas would be very much appreciated……………..
reb0101
View 3 Replies
View Related
