Hey all,
I have a table for my documents and I have to add all these documents which need to be entered into the table, is there a faster way then right click edit hyperlink and go through the folders and find the file? Since I have a lot of doc this will take a while so I was wondering if there was another way? Thanks
Help please. I would like to be able to create a browse button that will allow the user to find a file that when they click ok on the browse window is assigns the file to a hyperlink .
I have used the following code to open a dialog box which works fine and puts the file name in the hyperlink field on my form however when I click the hyperlink nothing happens.
Dim strFilter As String
Dim strInputFileName As String
strFilter = ahtAddFilterItem(strFilter, "Excel Files (*.XLS)", "*.XLS")
strInputFileName = ahtCommonFileOpenSave( _
Filter:=strFilter, OpenFile:=True, _
DialogTitle:="Please select an input file...", _
Flags:=ahtOFN_HIDEREADONLY)
Me![txtFile] = strInputFileName
any ideas
A field in the table is hyperlinked. I put urls in, but obviously I have to do something else to tag on "http://".
Alternatively, be pleased to know the code to concatenate "http://" onto the urls.
I am trying to link to a specific page in a word document from my Access database. I pretty sure I've done this before, however my brain doesn't seem to want to retrieve that information at this time. Does anyone know how to do this?
Thank you!
Jamie
Hey all,
I have a table for my documents and I have to add all these documents which need to be entered into the table, is there a faster way then right click edit hyperlink and go through the folders and find the file? Since I have a lot of doc this will take a while so I was wondering if there was another way? Thanks
Hi all
in my table, i have a field type set to hyperlink.
I'm sending a hyperlink address to the table using ADO.
the control property is set to hyperlink yes on the form.
i then display the captured information in a subform data sheet with the filed property set to hyperlink yes. It displays as it should (in blue and underlined) ... but the hyperlinks aren't working. I click on it and nothing happens. If I right click on the hyperlink and "edit" the hyperlink address is missing.
But...
If i go into the table and reset the field to text, save it and then reset it back to hyperlink.... presto is all seems to work. Now when I edit the hyperlink... the address is there. Weird!!
something isn't right. I shouldn't have to do this. I'm being driven mad.
Any ideas??
Hi,
I am new to Access, what is the hyperlink feature in Access ?..is that used to store hyperlinks in their native form ?, am creating a small application where a column is a hyperlink column, this when output to the page should take the use to the correct link. It's part of a news feed program.
I have the forms/HTML all done up to accept and to store the info, it's only the display area that i have a problem with. There are 3 cols in the db, one is an ID, one is a short desc, and the last one is the URL (this is the actual hyperlink).
One more question....
I created a table with one field being a hyperlink
I created a query to query out specific fields including the hyperlink.
I then create a subForm on a form and point to the query.
Everythign works great except the Hyperlink.
It just stops working....I can Delete the Hyperlink field and recreate it then delete the subform and recreate it and it works once....
But then Stops....any thoughts...
I dont know what else to do...I am currently returning multiple records into a Subform based on a query. I did it this way becuase I can click individual fields, including the hyperlink fields.
If I use a List Box then I can select the whole row.
AnYone know why the hyperlinks stop working...or can throw another idea out there of a better way to do this.
Hi,
I have a database I use at work. We have to manual enter in the the hyperlink eg "h:quotes12345.doc". I was wondering if Access can do this for us.
I tried to use the combine function eg [open quote] = "h:quotes"&[Quote No]&".doc". This does appear to work it has the the text in blue and underscored but when you try to click the link nothing happens.
Any ideas on how to get this to work.
Regards
Mike
Hi,
I am a newbie at Access and this forum. Here is the question I have a database set-up in Access'97 which recently got converted to Access'03. Now previously database reside on my computer and I have a field that holds hyperlinks to documents which were set as relative paths. Now the database has been moved to another location..where ofcourse the relative path don't work, as the parent directory is different. There are a huge number of records in the database with hyperlinks. I need to convert all relative path to absolute paths. Is there an easier and faster way of doing this? Perhaps via a query? I don't want to do this one by one.
Thanks in advance for your help.
I have a database of chemicals and one of the entries is the MSDS number. I would like a hyperlink, pointing to the .pdf of the chemical, created when I enter the MSDS number. If the MSDS number is 1111 the .pdf file will be something like (\servernamefolder1111.pdf). Is there a way to store \serverfolder in a string, append the MSDS number, and .pdf then store that in a hyperlink field. Any suggestions?
View 3 Replies View RelatedI have a form in which the user must put in a description in a text box. Within the description, the user will have to reference a PDF file that he will put a hyperlink to. Is this possible for him to do?
View 1 Replies View RelatedHi everyone! I am new to this forum, but I am hoping that I can find the help that I have been unable to find. Thank you in advance!
I am creating a database and I need to have users insert hyperlinks to files that will be saved to a table. I have created a text box and set the control source to a hyperlink, so that it will save to my table. What I want is for the user to double click on the text box and the Inert Hyperlink box to appear. Instead of having the user either selecting Insert -> Hyperlink or typing the link themselves. I have looked in several books, tried the help in access, and have search the web to no avail. Any suggestions?
Thanks!
I am in the process of creating d/base of early settlers for our local museum. The Fields need to have reference to one or more files or programs outside of Access, e.g. Legacy, Word, photo files, d/bases of electoral rolls, etc.
The apparent easy solution was to attach these sources and I also got a handy Attachments dialog box that showed me the list of attachments for a every person or place. However, after entering only 10 names and attachments, the file size had grown to nearly 8Mb - obviously impracticable if the d/base is to contain over 2,000 names.
So, I switched to using Hyperlinks which cut the file size by 90% but now I have another problem: Hyperlinks only lead to one item, e.g. a photo, whereas the person concerned may have several photos and several other references. This would necessitate creating multiple Fields.
Is there a way to create a Dialog box (similar to the Attachments box) that would show me a list of the Hyperlinks for a particluar person?
Hi Everyone
I have just solved one problem concerning creating hyperlinks based on values in other fields: See Previous Thread (http://www.access-programmers.co.uk/forums/showthread.php?t=124590)
but now I have another, the hyperlink I have created links to a document, while for the majority of time it is a word document it is not always, occasionally .xls or .pdf
So I need a way of building into the hyperlink code the file extension, my thoughts are it would involve check boxes and if statements (one check box for each) but I am unsure of how to do this, can anyone help?
My code is currently:
Private Sub H_Enter()
Form!H = "hyperlink#C:Documents and Settingscew1My DocumentsWORKSpecs" & Form!S & Form!PC & ".doc#"
End Sub
I have been asked if is possible to highlight some text in a memo field and make it a hypertext link.
A memo field can be changed to a hyperlink field, this is not what is wanted.
Here's a tip for anyone trying to update or change a series of existing hyperlinks: you can use the >edit>replace feature on the menu to make changes to multiple records, BUT first you need to change the field type to text. Access shows only the display part of the hyperlink in a table when the field type is set as hyperlink, but the actual link info is hidden. If you change the field type to text the hidden link appears, and you can use replace to make the changes you want. Be sure to set the length of the text field to 250 before making the change. When you're done just change the field type back to hyperlink, and you're good to go.
For example, we had dozens of hyperlinks to documents in folders listed by months. When we moved all of the February documents to March, i had to update all of the hyperlinks. I change the hyperlink field type to text, did a replace search on 'February 2006' (any part of the field) and change it to 'March 2006'. The I switched the field type back to hyperlink. I didn't find anything on this procedure after searching the forums, so I thought I'd pass it along.
Because they are more efficient, I am using hyperlinks to connect my forms. I want to be able to deactivate hyperlinks based on criteria that are selected.
Please help! :o
What I want to do is add drawings and history files to my database. I have it set up in a table that just has my primary key field and 2 hyperlink fields for drawings and for history, this table is linked as a subdatasheet to my main table.
I'd like to know if it would be possible to create a form with a "browse" button to find the files and from here add the files to my hyperlink table.
With a regular label you can make it a hyperlink to open a file but is it possible to use these to open another form or is there any other way of doing this?
View 1 Replies View RelatedI have created a table in Access 2000 that contains among other things, hyperlinks to .txt files. This is a CD database, and the hyperlinks link to .txt files (local) containing track listings. I have designed a form that displays each record (CD). I can get everything to display except the hyperlinks. How do I tell Access (w/VB) to AUTOMATICLLY display these .txt files (w/o prompting) as users scrolls through individual records? I don't want to manually enter the paths, and I don't want to have to click the hyperlink to display it. Just like the other fields, I would like them to display w/o prompting. Any help would be greatly appreciated.
Tim
I have created a table in Access 2000 that contains among other things, hyperlinks to .txt files. This is a CD database, and the hyperlinks link to .txt files (local) containing track listings. I have designed a form that displays each record (CD). I can get everything to display except the hyperlinks. How do I tell Access (w/VB) to AUTOMATICLLY display these .txt files (w/o prompting) as users scrolls through individual records? I don't want to manually enter the paths, and I don't want to have to click the hyperlink to display it. Just like the other fields, I would like them to display w/o prompting. Any help would be greatly appreciated.
Tim
I have a 2 part question. I'm looking to enter the names of different files that I have for a particular client so that they appear/pop up as a list in a subform in "real time". I'd also like those file names to be hyperlinks to their actual location on my server. Is there any way to do this?
View 1 Replies View RelatedI am creating a database that basically holds product information. The different fields I have is Supplier, Product Code, Product Description.
For each product I have a product specification in a word document the names of these specifications follow this convention: [Supplier]&[Product Code] e.g. Coca Cola012345
I need a hyperlink to link to the relevant word document, but rather than going through and setting them up one by one I want the hyperlink to be self calculating depending on the information entered in the fields.
I tried typing in the following in the hyperlink address part in the properties:
=[Supplier]&[Product Code]&".doc"
but it seems to read it exactly as I type it in and obviously does not work.
Can anyone suggest a way round this or perhaps a completely different way of doing it which may be more effective???
Thanks in anticipation of your help.
I have recently updated my version of Access.
Within a tbl i have a series of hyperlinks.
All of these hyperlinks are linked to an object within the database, a macro as an example.
When i go to edit these hyperlinks, it does not allow me to link 'to objects within the database'. This options used to be available in my older version of Access. Am i missing something?
My Db had an email_address field which was a hyperlink. For various reasons I had to change it to a text field. However, now every email shows as:
some_email@domain.com#http://some_email@domain.com#
Is there a simple way of cleaning this up so I am only left with the email address? In other words is it possible to create an update query to remove everything between # signs (including the # signs)?
----
I found some vba code on the forum which extracts strings but was wondering if there is an easier way just using an update query since I'm still not too efficient with vba