473,799 Members | 2,786 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

HELP!! Email fields and getting to work

3 New Member
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
Apr 12 '07 #1
4 1549
smdreger
3 New Member
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!
Apr 12 '07 #2
sweihrauch
1 New Member
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:
Apr 12 '07 #3
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
Apr 13 '07 #4
smdreger
3 New Member
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
Apr 13 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

2
2424
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?
4
1692
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.
4
2619
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...
4
5108
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,
5
1514
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.
2
1841
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.
1
1298
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")
3
1825
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
0
9687
marktang
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...
0
10257
jinu1996
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...
0
10029
tracyyun
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...
0
9077
agi2029
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...
0
6808
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();...
0
5467
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...
0
5588
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4144
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
2
3761
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.