how to make the text clickable in ms access?
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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.
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?
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
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.
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
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.
"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.
In Access 2003, is it possible through code to make selected text in a field to appear in italics - leaving the remaining text unchanged in appearance?
For example, the text field contains several paragraphs but where it includes a reference to legislation - eg "Property Act" - these two words need to appear in italics, while therest of the text (before/after) is unchanged in appearance.