I have set up a field into which I am typing e-mail addresses (there seems to be no special e-mail data definition in Access 2003 Design View). By clicking on the e-mail address, I want to cause an e-mail browser to open (preferably Eudora). How to achieve this?
OK I get this far:
1 Create yourself a form using the wizards.
2 enter Design view
3 right click the textbox containing the email address
4 choose properties
5 click on the events tab
6 put your cursor in the textbox next to "On Click" or "On Dbl Click"
7 click on the "..." button on the right that appears
8 chose code builder
Then I get the error message:
"You can't refer to a form or report module from Form view or Report preview if the form's or report's HasModule is set to No.
Switch to Design view or set the HasModule to Yes in order to refer to the module"
This is puzzling. I cannot find any HasModule. When I switch to Design view, the Event box is empty and has no choices in it. What to do?
Why should I not be accessing the table directly? It's more convenient. I don't like the way forms present data, vertically. I want my data on a horizontal line, and the way the table presents it is just fine for me.
I think the question should read: why does it always appear so simple?
The error message you recieved suggested you were not in design view.
Why shouldn't you access directly? I am now assuming you are the only person accessing this access database, in which case be my guest to fiddle directly with the data. But in a multi-user environment it is a big no-no.
It is best practice to remove direct data access from the use, because it makes it far too easy for them to screw it all up
Programmers do their best to control and clean a users entry; have you ever noticed that you cannot put a "\" in a filename?
Well, that's a prime example of programmers intevention! Direct table access doesn't allow much in the way of validation!
With regards to the mailto bit; did you set the fields datatype to hyperlink as I advised? Did the text you type in go blue and underlined?
Databases and programming are not simple beasts take many years to come even close to mastering. Unfortunately, as you have found, most users do not understand how something that appears to them to be "so simple" actually takes a lot more than expected!
Tis the nature of the beast that is making this difficult for you MP.
When anyone tries to compare Word to Access, I feel the need to say this:
Word is simple to setup and very difficult or impossible to maintain complex data. Data relationships don't exist. Excel is average at both. Setup can be awkward but manageable. Data relationships can be forced into existence with lots of VLOOKUP functions and it's still not perfect. Access is hard (by comparison) to setup but simple to maintain complex data. Data relationships are simple.
Just design a continuous form MP. It can look almost exactly like a table, but it gives you high levels of control.