I have several email fields in my Customer Contact database. The fields are set up as hyperlinks. When I enter an email address for the customers they appear as a hyperlink. When I click on them it tells me page is not available. I understand that it is trying to open a web site. However When I type the protocol mailto: prior to the email address in the field and then click it will open the mail program with the customers email address in the send to of the composing email. My question is, is there a way to get the mailto: protocol into the field description so that the any email address in the field will open the mail program. I have created this database for the use of our sales staff to utilize, as they receive email addresses for their customers they update the email address field in the database for future use. I do not want them to have to type mailto: before each email address they enter. It just seems crazy that this cannot be addressed in the field description. Please someone help I have been trying to figure this out for days!!! Thanks so much in advance.
Sara
4 1549
I have several email fields in my Customer Contact database. The fields are set up as hyperlinks. When I enter an email address for the customers they appear as a hyperlink. When I click on them it tells me page is not available. I understand that it is trying to open a web site. However When I type the protocol mailto: prior to the email address in the field and then click it will open the mail program with the customers email address in the send to of the composing email. My question is, is there a way to get the mailto: protocol into the field description so that the any email address in the field will open the mail program. I have created this database for the use of our sales staff to utilize, as they receive email addresses for their customers they update the email address field in the database for future use. I do not want them to have to type mailto: before each email address they enter. It just seems crazy that this cannot be addressed in the field description. Please someone help I have been trying to figure this out for days!!! Thanks so much in advance.
Sara
I forgot to mention that I'm running Access 2002, Thanks!
I forgot to mention that I'm running Access 2002, Thanks!
I create a small button on the form beside the email field. On Click of this button, I have the following code:
On Error GoTo SKIP
DoCmd.SendObjec t acSendNoObject, , , Forms![frm_MAIN]![email], , , , , True
SKIP:
MMcCarthy 14,534
Recognized Expert Moderator MVP
I create a small button on the form beside the email field. On Click of this button, I have the following code:
On Error GoTo SKIP
DoCmd.SendObjec t acSendNoObject, , , Forms![frm_MAIN]![email], , , , , True
SKIP:
This code would be used instead of a hyperlink.
Only other option is to have the textbox where user enters the email as an unbound textbox and have a hidden textbox on the form for the bound field. Then in the after update event of the unbound textbox concatenate the "mailto:" to the beginning of the address.
Mary
I create a small button on the form beside the email field. On Click of this button, I have the following code:
On Error GoTo SKIP
DoCmd.SendObjec t acSendNoObject, , , Forms![frm_MAIN]![email], , , , , True
SKIP:
I've never written code before, so I'm not sure what I'm looking at. I have been researching and found where to enter it, however not sure how it links up with the field. The area above in the brackets [], is that the form name and the field names respectively? Would I make the field a text field instead of the hyperlink as stated in the second response? Thanks so much for your help!
Sara
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Targa |
last post by:
Not sure if this is the correct group for this but I assume this can be done
with javascript.
Basically, I have a page with a form on it. There is also an IFRAME on the
page that has several form fields which contain the results of a database
query. I need to be able to submit the form and have the fields in the
IFRAME submitted along with it.
Is there a way to do this with javascript?
|
by: Chuck |
last post by:
Hello,
I have an Access XP database that has several fields. One of the
fields is a text field and has an account number that is preceeded by
a text character, like: F102354. Every account number has this prefix
and is always followed by a 6 digit number.
What I need to do is to drop the character at the beginning and keep
the remaining part of the account number.
|
by: (PeteCresswell) |
last post by:
I'm equi-joining two tables on a Long and a DateTime field and then
comparing an amount in one with an amount the other via an Immediate If
statement.
Problem is that for some (not all...not even most...) records, I am getting
false differences.
I know the stuff below probably looks like a rat's breakfast, but I'm at the end
of my little string on this. Similar things are happening in a couple other
queries, so I'd have to assume...
|
by: Joe |
last post by:
Hello,
I have created a login page using dotnet. I am using requiredFieldValidator
and noticed that the code works fine in IE but not in Netscape, Opera,
Mozilla, Firefox, etc.
For example if I do not enter anything in the form in IE, then form won't be
submitted but in other browsers it is submitted.
I checked that JavaScript is enabled in Netscape, Opera, Mozilla, Firefox,
|
by: Gordon Youd |
last post by:
Randy Harris and Bob Quintal have tried to help me with my data base report
problem, for which I thank them.
The suggestions they gave me still do not seem to work and I am still
getting false data showing.
Data base is of customers who book a car to pick them up on a certain date
to take them to an Airport.
They would also book a car for thier return on a date in the future.
| |
by: The guy upstairs |
last post by:
Am looking for suggestions on comparing two email fields. Have looked in
the usual cut and past sites, but none seem to fit. the name of the two
fields are email and confirmEmail.
Any suggestions would be appreciated.
|
by: Harvey Waxman |
last post by:
Can someone see why this asp validation script doesn't send the email? The
validations work as expected the with JS turned on or off but the email never
gets processed. The middle portion is lifted directly from my standard asp
file which works fine without the asp validation code. The "Response.Write
Thanks" is shown but the email doesn't go.
<%
DIM strEmail, strSubject, strComments
strEmail = Request.Form("Email")
|
by: Steve |
last post by:
Hi;
We just migrated to SqlServer 2005. When I import tables from from
SqlServer database into another the identity fields get switched off
from being identities.
How can I prevent that from happening?
Thanks in advance for any information
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
| |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |