Forms :: Create Hyperlink To Open Access Form
Jul 10, 2015
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.
View Replies
ADVERTISEMENT
Jun 6, 2007
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:
View 7 Replies
View Related
Oct 23, 2013
how can i set a character as hyperlink in access form label...like GO ,in this G use as hyperlink for run a query
View 2 Replies
View Related
Mar 4, 2014
I have a main form [Job Quote Form 10-2205] and I am trying to add a command button to open up [Job Process Form-MKD] and have the [Job Process Form-MKD] open up and only show the records that match a certain field, in this case what I call "JobTrackNo" in the [Job Process Form-MKD]. (see attached .jpg)
This problem started to happen only recently, namely you will see that the left column under [Job Quote Form 10-2205] is blank, where normally there had been a number of fields to choose from. The fields are all still available, they are just not opening when I try to match two fields.
View 2 Replies
View Related
May 15, 2015
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].....
View 14 Replies
View Related
Nov 16, 2012
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 Related
Nov 26, 2014
I 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..
View 6 Replies
View Related
Jun 12, 2014
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 Related
Oct 18, 2014
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
View 3 Replies
View Related
Jun 8, 2014
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.
View 2 Replies
View Related
Jun 3, 2015
How to make application such that only a form is opened (not as a tab in access) just like pop up feature of a form. i have only one form in my application...
View 2 Replies
View Related
Dec 11, 2004
I want to create a new word doc, do a saveas to a specific path and file name, allow the user to edit the new doc, and then close it and return to the Access app. I can create the doc but Word opens without opening the New Savedas Doc. using this code
Dim oApp As Word.Application
Dim WordDoc As Word.Document
Set oApp = CreateObject("Word.Application")
Set WordDoc = CreateObject("Word.document")
oApp.Visible = True
WordDoc.SaveAs ("TS-" & Me.Scriptnum & ".Doc")
Your help is appreciated.
View 1 Replies
View Related
Jul 29, 2014
We are using access 2010, I have a blank form that produces an ID number for the specific record when saved. then i have other forms where the ID field is hyperlinked to the original form that was entered. I now have 2 users that are unable to open the hyperlinked form. when i login as them im able to open the hyperlinked form.
Private Sub ID_Click()
On Error GoTo Error_Catcher_1
DoCmd.OpenForm "NewRequestForm", , , "ID= " & Me.ID, acFormEdit
[code]....
View 4 Replies
View Related
May 12, 2015
I am creating a database to store patient ultrasound reports in a clinic. The form I've designed contains a single patient's report with various values and measurements. I need a button on that form that opens a report showing ONLY THAT PATIENT'S data.
So, for example, if I've opened the form (AbdomenForm) on patient with ID 4, when I press this button, it should open the report showing only patient ID 4's data.
I can get it to work manually by creating a query (AbdomenQuery) that contains 4 in the criteria for ID (my table's primary key). Then I made a report (AbdomenReport) that uses AbdomenQuery as its data source and everything turns out well.
Now, how do I go about making a button on the form so that when patient ID 5 is open, that button opens the report for only patient ID 5? What code should I use and where should I put it?
View 3 Replies
View Related
Jan 12, 2015
Access database 2007: I have a database with some forms init but when i type my username and password to open the main menu to insert data the form shows 1 second and closes the whole database. I don't know whether the problem is the VB code or the microsoft.
View 14 Replies
View Related
May 2, 2013
I am currently creating a database in a hierarchical system that is to be used by multiple users to enter information specific to them. The tables are arranged like this:
Owners
Modules
Tasks
Highlights
Theses are connected using primary ID's and Particular Entries in the next table so they form a hierarchy - when you expand owners it brings up a list of Modules attached to that owner, then expand each module and it brings up a list of tasks associated with that module, expand the task and it brings up a list of highlights associated with that task. This is all very straightforward of course but what I would like to do is create forms that basically match so that the users can navigate from their name, through their modules and tasks and then add highlights to each task.
For this I have been using continuous forms to list all the different entries and inserting a button in each entry that I would like to link to the next form and find the specific data, however when I try to do this the button always without fail will just return all the entries from the form rather than the specific ones requested. I set up the button using the wizard and select 'open form and find specific data' and then select two entries that are identical on each form. I have trawled the internet quite a bit to try and find why this is happening and have inserted various bits of code etc into the embedded macro in an attempt to make it work but to no avail.
I wonder if there is something I need to activate on the form that the button connects to aswel or if I need to connect these forms using the relationship that I used to connect the tables (I am still using a unique identifier).If I connect to a single form it will display the first entry on the list (and I can cycle through them all) on a continuous form it will display all entries starting with the first.I would like it to display all entries for the selected record on the form.
View 1 Replies
View Related
Dec 17, 2007
Running 2007. In 2003, to make a shortcut for an object, all I had to do is right click and place the short cut where i wanted.
I can't seem to find anyway to do it in 2007
Anybody have any clues?
View 3 Replies
View Related
Dec 16, 2012
Occurs when I try using the Create Email button. I've enabled the access add in in Outlook. Same message comes up when Outlook is closed or open.
View 4 Replies
View Related
Sep 16, 2005
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..
View 3 Replies
View Related
Dec 14, 2006
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
View 2 Replies
View Related
Nov 11, 2005
Hello,
I have a MS Access form with a few hyperlinks on it. I have tried to achieve effect similar to hyperlink roll over effect on a web page: when mouse pointer goes over a hyperlink it changes colour, etc.
Unfortunately, all I could find was MouseMove event:
Sub Label_MouseMove
Label.ForeColour=vbBlue
End Sub
But in this case hyperlink stays blue even after mouse pointer leaves it. And I would like hyperlink get back it's initial colour.
Thank you
View 2 Replies
View Related
May 5, 2015
I've set hyperlinks to a couple of forms using the hyperlink address in properties. All works fine, and I've done it this way because the cursor changes to pointy hand when hovering over.
However, I need to navigate to a tabbed form in a main form.
Is there a way of doing this? I've been searching all sorts, and the most probable is to concatenate the destination?
description##Page1#page2... or something like that?
Is this correct?
What ever I've tried doesn't work, this includes ...
adding the main form destination to Hyperlink Address, and tabbed form in the SubAddress (Can't find main form)
Using the hyperlink builder. (Can't find anything)
Objects in this database (Only one form).
View 4 Replies
View Related
Aug 5, 2014
I am trying to set up something to be able to take me to a folder that holds various forms for personnel. I have a query that generates the link for each person. I have tried to set it up as a hyperlink in ACCESS 2013 and it displays as one but doesn't act like one.
I want to be able to click the link and have it open up a personnel folder for that individual. I can't find a MACRO that I can create to do it. Example of my query is that it creates a link K:Main BreakdownSection BreakdownPersonnel FoldersName and the name is the variable part.
My next problem will be to have it create that folder when we have new personnel arriving.
I would also note that I have not worked with ACCESS in many years and much of what I was able to do with 2002 and 2003 doesn't work with the newer versions of ACCESS.
View 3 Replies
View Related
Jun 6, 2007
I am attempting to creae a hyperlink to set into a table that is generated automatically by other information curently residing on the table, and with the ability to change the disc location.
The table I have created is an application that will name reports that I have in .PDF format. I put in the report title, date, inspectors, etc. and it gives me a unique name for the document. I then go to my document and name it what the application gives me. Now, we would like to have a link to that file that resides on the table, so if we look it up in the future we don't have to search any further, we can just click right there and go strait to it.
I know how to insert a hyperlink to get to the file, assuming it stays on the same directory. Our directories change fairly often (can go from C:/My Docs/File to E:/My Docs/File in a matter of a week), so I would like to know if there is a way to create a partial hyperlink that I can change the begining to whenever need be.
Any ideas or suggestions are greatly apericiated.
Thanks guys!
View 1 Replies
View Related
Feb 19, 2015
I am simply trying to create a command button to open a folder on my desktop
Cannot seem to find this code
This is the path to the folder I want to open
C:UsersJONATHANDesktopCMS FILES
View 4 Replies
View Related
Feb 20, 2005
I am working on a database that tracks products. The products are divided into groups (Bath Salt, Stick Incense, Candle, etc.) and these are store in a table. The products themselves are stored in another table.
When a new scent is created, it can belong to multiple groups ... for instance, Strwberry Vanilla could be a perfume, a bath salt, a candle, stick incense.
When the form is opened, I want to read the contents of the groups table and create a check box for each entry.
I do not really want to use a list/combo box for this task ... would prefer to be able to check in a list of boxes to specify what groups to create entries for when a new product is entered.
Thanks
Phil
View 1 Replies
View Related
