how to make the text clickable in ms access?

Is there anyone here have an idea how to make the text clickable (and will open a new form)
for example

StudentNo

12345

Sponsored Links:

Related Topics

"Clickable" title in report
In a Report, is there any way to embed a hyperlink within a text box that is pulling data from a field other than the field that a hyperlink is stored in? For example, my current report hasa textbox (txtTitle), and then beneath it another textbox that displays a clickable hyperlink, so the Report ends up looking like:


Drop Down Help Menu
I'm creating a form that functions as a help menu. The basic idea is a form that will have click able text boxes each with the name of a specific help issue.

A few issues.

1) The help form will be based on a table. The table has two entries, helpItem and helpDisplay. I would like the form to be created each time the db is opened, it should remove the earlier clickable commands.

step through the table and create a clickable command for each helpItem in the table.

2) Upon clicking command the form should display the helpDisplay associated with the helpItem, underneath the command. Clicking the command again should collapse the text.


Mail Merge: Clickable Hyperlink
I would like clickable hyperlink on mail merge to actually work. In my access 2003 database the field that corresponds to the Hyperlink is named VideoLink1 and I have made it a Hyperlink type field. However, when I insert the field within a MS word Hyperlink field brackets shown like this:

{ HYPERLINK { MERGEFIELD "VideoLink1" } }

Then merge new document, I am able to see its shown as a hyperlink ie. blue font BUT when the pointer hovers over it, the javascript note as it should says CTRL + Click to follow link and I do that, ctrl and click but the link does not open. Just to make it clear the my links are correct.


Mail Merge: Clickable Hyperlink
I would like clickable hyperlink on mail merge to actually work. In my access 2003 database the field that corresponds to the Hyperlink is named VideoLink1 and I have made it a Hyperlink type field. However, when I insert the field within a MS word Hyperlink field brackets shown like this:

{ HYPERLINK { MERGEFIELD "VideoLink1" } }

Then merge new document, I am able to see its shown as a hyperlink ie. blue font BUT when the pointer hovers over it, the javascript note as it should says CTRL + Click to follow link and I do that, ctrl and click but the link does not open. Just to make it clear the my links are correct, here is one of them, you can see its:

http://www.youtube.com/watch?v=51gBN4nA9s


Making text a hyperlink
What I have is a form in Access that has a command button on it that when clicked it opens a new outlook mail message with text already inserted into it. Part of the text is:

Please visit the Facilities Operations page for more information.

How could I possibly go about making the words " Facilities Operations " a clickable hyperlink in the the mail message?


Form Field open Default mail client
Access 2003

I have a field on my database that is for email address.

When I display that field on a form I would like it to be a Mailto: link and open up the users default mail client (assuming they use a local client and not web based email).

The field is self in the table is set to "hyperlink"

Is this form by form coding (In other words can I have it clickable on some forms and not on others?). I guess I could just lock the field on the forms I do not want it clickable


Make Table Format
Can you create a blank make table where the columns are formatted to date rather than text. Does a make table default to text when no data is in it? I want my make table to not have to be manually changed every time I have no data in it. I have also trying to append into the make table, and it still converts everything into text


MS Access 2003 Hyperlink to Intranet file
Our IT department have a call logging facility where IT calls are logged, each call is assigned a unique number which is e-mailed to the user logging the call. The main part of the URL doesnot change only the unique number (last 5 digits).

I want to be able to key these last five digits into a text box on my form and have the main part of the URL + these 5 digits appear as a clickable hyperlink on the same form.

The hyperlink when clicked will open IE and the relevant page/data.


VBA Rx to switch index of local temp table to update Multiple Items form sort order
I am looking for the Access / VBA way to do something I have done with Paradox / Object PAL. The scenario is as follows:

1) A query is run to cache some data from the SQL Server BE DB down to the local Access FE DB.
2) I would like to pre-define some indexes on various columns of the FE table.
3) Then I would like to have the header labels of a Multiple Items type form be clickable and switch the index the local temp table is sorted by.

I have not found documentation stating how to switch indexes on an Access table.

I would guess it is a straight forward call, then do my usual two calls to make sure the UI table grid is bound to the correct local temp table and then refresh to display the new sort order.


Securing Database (necessary when only viewer is used?)
In the company I'm at, I'm the only person with Access. Every other person who will be using a database I made will be using the Access 2007 viewer. The very nature of the viewer doesn't allow the end user to have access to anything to change.no stand alone objects that aren't clickable from the switchboard, no access to underlying code, etc.

I even tried to get around the login (with password) form on load by holding down the SHIFT key, and that doesn't even work. I feel like I can split the database, password protect the backend just to be safe, and not have to do anything for the frontend.


Importing URLs - how to have them automatically be clickable links
Whenever I import a table from Excel, even though I have the URLs in a column labeled "web address" and I have the settings on the table column as "Data Type: Hyperlink" I have to be manually right-click the hyperlink, choose "edit hyperlink" copy the "text to display" which is in the format http://www.something.com, then paste this address into "Address" in order to get the link to work with a click on the form.

How can I import into Access and have the URL links work automatically without having to go through this step for each and every record


Unusable subform
Some of my forms have Excel-style subforms in them but for some reason the fields are listed but not the individual cells are not clickable and no data can be entered. I have checked the "Visible" and "Enabled" properties and they are both set to "Yes". I am using Access 2007 (and 2010 when on my work computer). The problem appears on both versions. Any clue on what might be the problem


Locked linked Text File
In our Windows network environment every time someone logs on to a network computer the logonrecords.txt text file is updated. I created a database to make the log in data easier to search. I linked the text file to a access table but the text file stays locked until I exit the table or access. I get a "The process cannot access the file "" because it is being used by another process." dialogue box. Is there anyway to have that text file unlocked, so it can update while I'm using Access.


How do I pass a field value to a Shell command?
We have an application external to Access that populates a table in an MSSQL database. The records contain the fields "docRef", "docData", and "docName" where "docRef" is the searchable key, "docDate" is the date the document was created, and "docName" is a text field containing the full filepath including filename of the document file.

We have a simple Access form that queries this externally-linked table and returns the resulting record.

I would like to create on the form a clickable element (either the docName field itself, or a button) that, when clicked, would open in NotePad.exe the file specified in docName.

Intuitively, it should be something like:

Private Sub Command1_Click()
Dim retVal
retVal = Shell("notepad.exe" & ?, 1)
End Sub

But it is the ? that I cannot figure out how to populate from the field value returned in the query


Deleting Text VBA
I was wondering if there is a way to search through a column and delete text out of that column. I am using Access 2007. The column I am wanting to look through is customer_id, and I want to make sure that there is no text in that field. Is there any VB coding that would allow for me to do this


mapping from excel to access
I am a newbie to access. I have many excel files where I want to map to access. For instance in excel: the field under the text "name" is what I want to grab as name, and the field under the text "jobNumber" is what I want to import as jobNumber into access. The text I want to import is not always in the same cell each time, but is always under the title ie. "name."

Should I first alter the excel file with a macro, in order to make it more "mapable", or is there a way to do this within access?


Make a text box read only
I need to make a text box read only in access 2007. is there a property that set a text box to read only.


Access Cannot Find Form
I have a continuous subform (BooksFullSubCC) that is located on a tab in the main form (BooksFull). In BooksFullSubCC, there is a text box in the footer that sums up all the amounts of credit card charges to make a total with =Sum([Amount]).

For some reason, I cannot pass the value from the text box to VBA or another text box on the main form because Access "cannot find the form"

Private Sub TabCtl93_Change()
Dim Amount As Currency

Amount = Nz(CCur(Forms!BooksFullSubCC!CCchargesTotal))

Me!CCFees = Amount * 0.015
End Sub

Its really simple - Access should take the amount from the text box (CCchargesTotal) on the subform and then put it the result of some simple math into a text box on the other form.

I get
"Run-time error '2450':

Microsoft Access cannot find the referenced form 'BooksFullSubCC'."

I've checked the spelling, everything. I even tried to make a text box on the main form with control source =[Forms]![BooksFullSubCC]![CCchargesTotal] but that didn't work either.


form doesn't work as a subform
I have a form called frmReportdates - This form has two text boxes txtfrom and txtto (for the dates) & a clickable button which opens the report -

In the query of the report I set the dte criteria to :

Between [forms]![frmReportdates]![txtFrom] And [forms]![frmReportdates]![txtTo]

the form works as desired. but I want to use this frmReportdates as a subform for frmemployees, but I cant get it to work. When I click on the button it gives me an error asking for "Forms!frmReportdates!txtFrom


Email clickable button
I am trying to get this stubborn button to work. It works on the sample database that came with the Access 07 bible, but for some odd reason, it wont work on mine. I copy/pasted the code, changed everything accordingly, but somehow it still doesn't work. I am stuck. can anyone elaborate? am I going about this the right way?

I do have an Email field in my form. I also have a "Client Email" field that is where I want this button to email.