I have the following code to open a specific file:
Private Sub OpenDoc_Click()
FollowHypelink "C:Documents.......
End Sub
The name of the file is written in the code, for every record on my form I have a different file to open so I have a field called "DOCN" wich is the name of the file I have to open. How can I put a extension on the code to read the file name mentioned in the field on my form?
Thanks
Marco
I have a form with a textbox on it that is populated with the path of a pdf doc associated to the form. How do i get the pdf to open when i click on the path?
thanks..
Is it possible?
I want a link that can be put in a mail (to someone in our network) and clicked. It should open Access on a specific database and I should be able to use parameters (like /cmd and /wrkgrp).
I'm lost... :confused:
I have a table has two fields: CompanyLocation , FileName
I have a form that uses and unbound field to create a file path string
="file:///s:/My Folders/" & [CompanyLocation] & "/" & [FileName]
In the form it looks like file:///s:/My Folders/My Company One/This Is My File.doc
I then set this to hyperlink in the form but when i click on it nothing happens.
When i copy the link it gives me and paste it into Windows Explorer it works fine.
I have a form, and on that form I have a textbox called RefDwgNo (user not allowed to make changes...just for viewing). Displayed in this textbox is the name of a file (without the .pdf extension). I changed the textbox to 'is hyperlink' and added to OnClick- this code:
Private Sub RefDwgNo_Click()
FollowHyperlink "***private***engineering_data***Private***Des ignFitoutLabel Plate\_LATEST REV"
End Sub
The user needs to actually open the .pdf file, not the folder its located in. How do I add the file name from this textbox to the code above?
I have a form linking to information in a query, and simply shows some client information. one thing the form shows is the clients email. from the query i can click on the email (hyperlink) and outlook opens a blank email with the clients email already inserted. how do i get the form to do the same?
View 1 Replies View RelatedHello all, I hope your hollidays were great!!
Ok I have a Continuous form that in one of it's fields contains Hyperlinks. The form is named [Song Info] and the field is [Play].
I want this field to be hidden and have a command button open up the hyperlink in that recordset. I think that all the info need
but if not let me know.
Thanks
Rich M
I have a continuous form that lists all unapproved invoices. I would like to have a hyperlink at the end of each row that says Review and will open another form that queries the details of the unapproved invoice based on the invoice number in the current row.
View 9 Replies View RelatedI have 3 attachment boxes in my table that appears in a form.each attachment box contains specific files (not specific as in extension such as PDF, JPEG, etc.) but specific as in Company Documents, Certifications, Resumes. The issue is there's a lot of document and I see my database growing (fast)...My question finally is....
Can I use a Hyperlink to open a folder within a specific directory where multiple file are located so i can open the specific file need there RATHER than attaching them in the attachment box individually?.?.....If not how this can be done (no SQL) unless that route is very simple and basic coding.
My thinking would be to place the file path to the documents in the table and hyper link that column in the table, but not knowing exactly how Hyperlinks work I don't think it would actually work..
I have a report that will open by clicking a hyperlink and I want it to open in preview mode.
I tried using:
"DoCmd.RunCommand (acCmdPrintPreview)" or "Report.CurrentView = 5"
in the On Open event but, no success, I only get an error message.
I am investigating on the possibility of setting up an approval process for our employee intake procedure by using MS Access and Outlook.
The idea is for the requester to open an intake form in Access and fill in the new employee's information and send an Outlook email to the manager for approval. I know how to trigger off an event on the form to send an email to the manager but my challenge is how to create a hyperlink in the email for the recipient to directly open the intake form with the specific record, without the need to open the database and find the specific intake form.
The intake form is built in a frontend .mde file on a shared drive where all users have access to.
I am trying to create a button that opens up a webpage. I get how to create a hyperlink on a button. The problem is, I need to open a specific page depending on the information in a text box.
The text box displays the tracking number for the current record. That number is populated automatically via a control source. The problem is that I need to open different web pages depending on the tracking number displayed. For example, UPS has a specific start to their number (1ZX....). Other trucking companies have a specific format, also.
So how do I tell it to look at the tracking number and then open the corresponding web page?
I create a table that have one hyperlink data type and i want to open a existing form that i created using this hyperlink.
Can this hyperlink data type open a form in the same access database? or open form in different access database?
Using hyperlink button have the function to open form in same database but the problem is this function is not available in hyperlink data type.
I have created an action log database that sends an email when a new action is entered. I would like to launch the database using a hyperlink in the email, but can't seem to get it to work. All users have a copy of the front end on their desktop, so whatever I add to the email needs to launch the front end for any user signed on to their own desktop.
This is what I have and it sends a hyperlink but I click it, I get an error saying it can't find the file. I don't know how to word the path name for any user?
With obMsg
.subject = "New action request for " & team
.To = people
[Code].....
I am trying to add a feature in my database dashboard that shows a list of hyperlinks that are the most frequently used forms and reports based upon the user. I can figure out how to capture the event each time the form or report is opened and update a record to increase the count, and build a recordset that will query the table filtering by user and order by frequency...
However, I am stuck on building the hyperlinks that will point to the correct form or reports dynamically.
Specifically, I am not able to update the subaddress using VBA. I get an error that the hyperlink cannot follow to the new form...
Here is my code:
Code:
Private Sub Form_Load()
Dim strUser As String
Dim strApp As String
strUser = Environ("username")
strApp = "frmTest1"
Me.txtUser = strUser
Me.txtLink3 = strApp
Me.txtLink1 = strApp
Me.hypTest.Hyperlink.SubAddress = strApp
End Sub
i have thousands of data records with hyperlinks that are correct. Each data record shows the actual link (google.com, foxnews.com, espn.com, etc.). However, i want to change all of the records to just say "link" instead of saying espn.com, etc. How can i do this automatically without having to manually right click, edit, and changing the text to display?
View 6 Replies View RelatedI have created a very simple code to fill automaticly an hyperlink field when a text box is updated on a form:
Me.txtHyperlink = "F:DataCPPCPP PDF" & [TxtPipeSize] & "" & [DrawingFile] & "" & [PartNumber] & ".sht" & [TxtSheetNo] & ".Rev" & [TxtRevNo] & ".pdf"
TxtHyperlink is bound to the hyperlink field, when the code is executed the Hyperlink field is filled with the right address. but I think the code just fill the text to display "parameter" of the hyperlink field and not the actual adddress.
what should I do to get the result of the function to be saved as the Hyperlink address?
Hey guys.
I am VERY new to Access, and trying to learn as fast as I can, but I have no idea how to do this.
I have a database, brand new, it will eventually be holding hundreds of docs. Anyway, we have it as a document naming machine. We insert all the data associated with our document, it stores it and gives us a name for the doc, we then save that doc as a pdf with the name given.
After this, we are going to put all the documents in one central folder on our network drive, as follows:
F:FolderAccessDocuments*.pdf
So, what I need is to create an automative hyperlink creater, that will take our document name once created, put it on the end of the "F:FolderAccessDocuments" and have the hyperlink sitting there ready to go.
One more thing, I need to be able to change my Initial Drive Directory (from "F" to "E") at any point in time, and the switch would have to go through and change every hyperlink.
If anyone can help with any part of this problem, I would appericiate it.
Thanks Guys!
Chris
Hi
is it possible to have a txt field which will contain an email address and once you input teh address it becomes a hyperlink, so you can just click it and send an email from outlook?
Hello ,
I have ListBox and I have put in ControlSource:
SELECT HorizontalniDrzaciKabela.Referenca, HorizontalniDrzaciKabela.Opis, HorizontalniDrzaciKabela.Visina, HorizontalniDrzaciKabela.Napomena FROM HorizontalniDrzaciKabela WHERE (((HorizontalniDrzaciKabela.PickFlag)=False));
Can I make column HorizontalniDrzaciKabela.Napomena as hyperlinks for each record when I open ListBox?
In design view I put Napomena as hyperlink (I have added hyperlinks) but it will not work,
thank you in advance
I have a Hyperlink field (can be a text field if necessary) that is intended to open the document listed in the field. I have all of these documents stored on a server and I have set up another field that contains the path to the server directory. So, at the time I click on the document link, I want to concatenate the path with the document name, so I can open the file. This will enable me to not have to type the full path everytime I enter a new document name.
I tried setting up the field as a text field and I can concatenate the path and document name, but then I cannot open the file. I want to be able to pass the concatenated variable to the Windows OS and have it launch the document, regardless of the file type.
Any thoughts?
I have a report based on a query that has data for many dates. At the moment I have put a specific date in the criteria of the query so that I could build the report format. So it now displays all the data for the date i have in the criteria section. I will need to run this report several times per week so the specified date (and corresponding data in the report) will need to be changed to a new date when I open the report i.e. when I open my report I want to show data in the report only for a specified date.
Can I create a date parameter box open up when I open the report? Can I create a form with a button that when I click will open the report displaying data for that date? What would be the best way?I also need to display the specified date on the report.
I have been searching the forums and all I could find was how to hyperlink to outside url such as www.google.com and likewise.
I am looking for some kind of code or a direction that will help me hyperlink between records in my form.. best method probably would be using an ID number.
Any ideas?
Hello. New to this, but am creating a hyperlink in a new form. Using Edit Hyperlink, I direct the program to open a PDF format file. All seems fine, the path is relative to the main file, (although it does display %20 between all separate words, why?), but when I click on it, the warning :
"No prgram is registered to open this file". This file itself is fine, and opens happily when dble clicked. The hyperlink works fine when opening a Doc file. Help as I need this working...
I want to have a hyperlink on my form, that when clicked it will open a specified webpage. It will be the same hyperlink every time so doesn't need to be stored in the database.
How do I do this?
I have an unbound field txtMyField which I want to fill with a hyperlink after entering data in another field. So I put the Is Hyperlink setting to yes, and some code to populate the field. But I cannot click the link. It is just like text.
How can I amend this so that it is clickable?
Thanks,
Dave