Reports :: Preserving Hyperlinks When Converting To PDF
Aug 6, 2013
I have a report that contains hyperlinks to various folders on our share drive at work. I distribute this report once a week using the EmailDatabaseObject built-in function in the macro builder. I specify the output of the report to be PDF format. Everything works great, except when it is converted, the hyperlinks do not work.
You can click on them within the PDF, and a message pops up asking me to "allow" it to connect to the address. (Only the address now contains "%20" scattered throughout the address. Is the link corrupted?).
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
I have a table with fields of Title, Description, and URL. I have a report with a text box, IsHyperlink set to yes and Control Source set to =[Title] & "#" & [URL] & "#" . When I open the report in report view, it works great - the Title is displayed as a hyperlink and if I click it, I go to the URL. However, if I export the report to rtf or excel, I only get the Title - it is not a hyperlink. How to get the display text (Title) and hyperlink address (URL) from the access report to Word rtf and excel.
I am using the shell command to call dos ftp in order to download and upload files that I then import into my db (Access 2002). This is working great. I would like to check the file date before I import the file data into my db so that I do not import duplicate records. Unfortunately, the file date is modified when I grab a file. Is there a means to preserve the file date using the dos ftp utility? If not, is there some other way to do this in code so I can automate the procedure? The code I am currently using is:
'******* Code Start ***** 'This code was originally written by Dev Ashish 'It is not to be altered or distributed, 'except as part of an application. 'You are free to use it in any application, 'provided the copyright notice is left unchanged. ' 'Code Courtesy of 'Dev Ashish ' Public Sub sFTP(stSCRFile As String) 'Usage Example: ' call sFTP("C: emp est.scr") 'Sample SCR File for NT/Win95 FTP ' lcd "c: emp" ' open ftp.someserver.com ' anonymous ' dash10@hotmail.com ' cd public ' binary ' get dead.letter dead.letter ' bye Dim stSysDir As String stSysDir = Environ$("COMSPEC") stSysDir = Left$(stSysDir, Len(stSysDir) - Len(Dir(stSysDir))) Call Shell(stSysDir & "ftp.exe -s:" & stSCRFile, vbNormalFocus) End Sub '********** Code End *******
The excel worksheet that I am importing into my database has some formula's, for an example =2+2. I am importing this worksheets, then checking fields against the main table, then exporting back to Excel. But I want to be able to keep the "=" signs when I import to remain so that when I export back into Excel the columns with the formulas will already be there.
I have a check box in a form (set to yes/no in the table) and when I generate a report I would like the check box value to show up as yes or no in text box, but I can't seem to figure it out.
I have a query that uses DateDiff to give me Minutes of an in and out time.Online I found the following to use in a textbox control source on a report to convert the minutes to Hours:Minutes.
=[Minutes] 60 & Format([Minutes] Mod 60, ":00")
But when I enter this it gives me an error. I am not sure how to fix it. I tried writing it like this with RegHours being the source of that column
=[RegHours]60& Format([RegHours] mod 60, ":00")
but when I go back to report view that text box then says #Type!
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.
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.
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?
I 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?
Hi 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?
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?
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
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.
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.
