Topics Search

how to make the text clickable in ms access?

how to make the text clickable in ms access?
Views: 55
Is there anyone here have an idea how to make the text clickable (and will open a new form)
for example


Sponsored Links:

Similar posts...


"Clickable" title in report

"Clickable" title in report Icon
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

Drop Down Help Menu Icon
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

Mail Merge: Clickable Hyperlink Icon
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:


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.

Making text a hyperlink

Making text a hyperlink Icon
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

Form Field open Default mail client Icon
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

Make Table Format Icon
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

Locked linked Text File

Locked linked Text File Icon
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.

MS Access 2003 Hyperlink to Intranet file

MS Access 2003 Hyperlink to Intranet file Icon
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

VBA Rx to switch index of local temp table to update Multiple Items form sort order Icon
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?)

Securing Database (necessary when only viewer is used?) Icon
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 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.