DataBase - e-mail field

Hi,
I have a field in my table which is set as a hyperlink.  In my Contacts form
i want to enter an e-mail address to use later.
How do i enter data into this field so that it is saved as Mailto: rather
than HTTP: (so that i do not have to right click, edit hyperlink......)
Can this be done with a piece of code using VB?

  Arvin Meyer [MVP] replied to red

Just use a text field rather than a hyperlink.

You can still use the text field with code from a form like:

Dim strMail As String
strMail = "#MailTo:" & Me.txtEMail & "#"
Application.FollowHyperlink HyperlinkPart(strMail, acAddress)
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

  Jack Leach replied to red

Save it as a text rather than hyperlink... then, for the control's OnClick
procedure you can use the following line:

Application.Followhyperlink "mailto:" & Me.ControlName


I think that should do... you may not need the mailto line there, it may do
it automatically.

hth
--
Jack Leach
www.tristatemachine.com

-Thomas Edison (1847-1931)

  red replied to Jack Leach

Thanks Jack,
Works a treat!

com / If Microsoft had not scuttled "real" Visual Basic in favor of Visual Fred (aka VB.NET), I'd say you might as well spend 3 - 5 times as long (if more if it does not) and that many times more effort to write it in VB. The same ratio will apply if you use unbound forms and ADO in Access. ODBC experience - rewriting an already-developed Access app using VB6 was 3x. Would you say that VB.NET would take more than that or less - assuming an experienced .NET developer. - - PeteCresswell 9a49 projects where I was enhancing existing databases - - most of those were done by "refugees from VB" who'd been drafted to work on an Access project because, "after all, the development tools are almost identical" (which anyone who is worked with both Access and classic VB knows to be only a superficial resemblance). Oh, I saw one case of some folks Office Access MVP it Just from observation at user group demonstrations, not personal use of VB.NET, I'd guess developing VB.NET would be less efficient at producing working, tested code than classic VB. I know I have _re-created_ an existing classic VB application of modest complexity in

Access is deleting records DataBase Hi We have an Access 2003 database with a VB 6.0 front-end interface. It is used on a server where multiple individuals can in question has a primary key that is text and is sequentially incremented by the VB interface. It appears that records are being periodically deleted by either the interface or Access Has anyone ever heard of this happening? Any thoughts on whether it is Access or VB? Paul Access Discussions Access 2003 (1) VB (1) Database (1) SharedDefault (1) Bontrager (1) LocksThe (1) Tremors (1) Individuals (1) I doubt been deleted. Has anyone said that something they typed in has gone missing? Then the VB code might be deleting records. . . . . Can users delete records? That would be worth considering. - - Jerry regina-whipp.com / index_files / TipList.htm Hi We have an Access 2003 database with a VB 6.0 front-end interface. It is used on a server where multiple individuals can in question has a primary key that is text and is sequentially incremented by the VB interface. It appears that records are being periodically deleted by either the interface or Access Has anyone ever heard of this happening? Any thoughts on whether it is Access or VB? Paul I ran into something similar and was never able to resolve it. Records seemed

Is VB.Net the best option for a web front end port of an existing MS Access modules front end. The majority of the "value add" of the system is in the VB logic in the front end that guides and validates the users actions as they use tables in both MS Access and MS SQL Server. 2. rewrite the front end in VB.Net so that all the users can view and update the back end through their right way to go about it? I am a programmer so am happy to learn VB.Net and should have no problems with SQL Server. Would this be the quickest way would do a good job as the real value of the system is all the VB code behind the forms which I am sure any conversion tool would really butcher. I think it would be best just to clone my system myself in VB.Net. Have I chosen the right tool VB.Net) for my web enabled front end? It has to be something Microsoft I think for the IT department to support it on their servers. I am very comfortable with VB for MS Access so I am sure I can learn VB.Net easy - is this

ist es f?r alle anderen nur noch Daher die ?bertragung nach Access, damit mehrere VB und Innendienstler gleichzeitig mit den Daten arbeiten k?nnen (d.h. Eintragungen vornehmen), ohne dass es vom Himmel Zitronen regnet - - lerne, Limonade zu machen. Access Discussions Excel (1) VBA (1) VB (1) CboVBName (1) WonBW (1) VPN (1) CboOffiziellerName (1) OffiziellerName (1) Oijeh. ;-) Was heißt "kein Firma gemacht. Ebenfalls gigantische Excel-files mit redundanten und wiederspr?chlichen Daten. Ebenfalls "Deine" Terminologie ("VB" und so). Ich ahne schlimmes. . . Verzichte am besten f?r Deine Zwecke auf Access als tzung nicht zu erwarten. Das ganze soll einfach nur eine Liste sein, in der die VB ein paar Angaben machen k?nnen. Was steht drin? Ganz einfach 'Systemfelder Bezeichnung der Verkaufsdivision Name des VB Angebotsnummer Erstellungsdatum G?ltig-bis Datum Distributor H?ndler Endkunde G?ltigkeitskennung (valid / expired) Won Lost status im System (won / lost / pending) 'angaben durch VB Won-lost status_VB (won / lost / pending) <- hier gibt der VB den status an status-tender (won / lost / pending) <- VB gibt den Status der zug. ausschreibung an Das isses schon. Die Werte in Klammern sind

VB and set of Data bases DataBase Bonjour, I have a set of databases. Each database has a VB procedure to launch the database queries. These databases are used in sequence : Database_3 needs data in is turn needs data from tables generated in database_1. Is it possible to launch VB proc = E9dures of database_1 and database_2 from database_3 ? And how to perform this job ? Thanks in anticipation for your help. le Nordiste Access Discussions VB (1) Database (1) QryWhatever (1) InThere (1) Mvps.invalid (1) Procédures (1) Arvinm (1) Com run out of resources and crash the machine. You can also run queries without using VB, just call the second query from the first: SELECT * FROM [C: \ DatabasePath \ Database2.mdb].qryWhatever www.mvps.org / access Bonjour, I have a set of databases. Each database has a VB procedure to launch the database queries. These databases are used in sequence : Database_3 needs data in is turn needs data from tables generated in database_1. Is it possible to launch VB procédures of database_1 and database_2 from database_3 ? And how to perform this job ? Thanks in http: / / www.dfenton.com / usenet at dfenton dot com http: / / www.dfenton.com / DFA / keywords: VB, and, set, of, Data, bases description: Bonjour, I have a set of databases. Each database