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
Is it possible to follow a hyperlink to a file without using a file extension?
I have links being created based on the name of a file, but because I haven't used a file extension it crashes.
I know I can give the user a choice of what the file extension is and add it to the hyperlink, but it's an extra step, and another place for someone to make a mistake.
I'm potentially using 3 different file types, Word, Excel and PDF's.
The hyperlink works if I just reference a drive/folder, or if I add the file extension.
I have an old program with ade file extension and I would like to add some filters in one of the forms but I don't have design view or layout view option.
Hello. I have a mdb access file. When I open it, I can see lots of tables. How on earth do I open a form? Do I need another file, if so, what extension should I look for on my computer?? I really dont want to create a new form, since a person who did it has told me that its all have been already done. I just need to open the form and enter the data in. Thanks for any help!!!:)
I want to release an Access program to the production environment for users. I remember there being a file extention that can be used so the users cannot access the DB or Code.
I have a text box and sometime the word in that text box is too long. So, is it possible to make the whole word appeared when the mouse is on the text box? I don't want to extented my text box.
I am new here and dont know much about access but I have to do some things.
I have a table filled in access. This table (dlb_tbl) contains serveral colums. One colum named "type". The records of this colum has to be changed like this:
one record: 0RD00S101 this has to be changed into: EDH01-RD00S101
So there has to come a new extension EDH01- and the 0 has to be deleted. This has to be done to the whole colum. How can I make a query to do this?:o
Several post in the recent past asked the question of how to package the db for distribution and how to run the Access db in computer not installed with Access. Before Access 2007, you must purchase another program for about one thousand dollar to do this. Microsoft now offer these two programs "Developer Extensions" and "Runtime" for free. The Developer Extension is a program that will package your db into an installation disk. You can package the Runtime program in the install disk for users that use computers without Access 2007. Here are the links to the MS website for the download.
I have around a hundred tables all with exactly the same format and headings that i would like to combine into one long table, but the copy-paste append data to table function doesn't do what i had hoped. How can I join my tables together? And is there an easy way to do all 100 at once?
Greeting All, I am trying the beta version of Access 2007 and realize that when converting Access 97 to Access 2007, the new db in Access 2007 has an extension of .accdb. I rename the db file name to xxxxx.mdb and the VB app fails to recognize it.
Is there any way to convert the xxxx.accdb (Access 2007 beta) to xxxx.mdb so that I can try my app against the Access 2007 db?????
How would one go about scanning a hard drive for all mp3 files (i.e. *.mp3) and importing all of the titles into a database? I'm sure the dir function comes into play, but it seems to only handle "current" directory and not sub directories.
I was just curious is all..... haven't really dabbled that much in the file/directory functions.
I have a pretty basic TransferSpreadsheet module that works well except that if the Zip code has the four digit extension, it's not importing.
Option Compare Database
Dim myCheck Function MeridianLinkFileImport() DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tbl_MeridianLinkFileImport", "R:DEPT-BRCONSUMER LENDINGMarketing Campaigns2014 Auto Loan PrescreenReport from LoansPQ.xls", True, "Sheet1!A3:AO50000" End Function
If there is no extention, it is importing fine... 85086 works fine but 85018-4710 doesn't import.
What I need to do is remove the ".tif" part of the data. because of the way the path is output with regards to the tif image number, I'm having difficulty in targeting only that data that comes before the ".tif" extension.Is there a method I can use that will remove the right 4 characters and in conjunction with my expression above produce the following:
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
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?
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
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.
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).
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.