Topics Search

how to make the text clickable in ms access?

how to make the text clickable in ms access?
Views: 51
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:

More topics

 

"Clickable" title in report

Preview
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

Preview
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

Preview
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

Preview
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

Preview
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

Preview
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
 

MS Access 2003 Hyperlink to Intranet file

Preview
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.
 

Make Table Format

Preview
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
 

VBA Rx to switch index of local temp table to update Multiple Items form sort order

Preview
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?)

Preview
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.