My database is for customers details.
I have created a form (from a table) in which two fields are hyperlinked. One field is the web address and the other one is the email address.
The email field is not working properly: Instead of opening the email, it opens the web page for the customer.
When I edit the hyperlink, I can see that it is linked to the box at the top saying "Existing file or web page". I can edit each customer's details one by one so that the "email address" box at the bottom is selected then I copy and paste the email address which add the "mailto" bit and Access recognizes that it is an email address.
BUT I have 1000+ customers in this database and do not want to edit their details individually.
Question 1: Why is Access not automatically selecting the "E mail address" (in the editing hyperlink window)?
Question 2: I would like to be able to change this setting easily and not have to edit each customer's details individually. What can I do?
Please help.
Thank you.
I have created a form (from a table) in which two fields are hyperlinked. One field is the web address and the other one is the email address.
The email field is not working properly: Instead of opening the email, it opens the web page for the customer.
When I edit the hyperlink, I can see that it is linked to the box at the top saying "Existing file or web page". I can edit each customer's details one by one so that the "email address" box at the bottom is selected then I copy and paste the email address which add the "mailto" bit and Access recognizes that it is an email address.
BUT I have 1000+ customers in this database and do not want to edit their details individually.
Question 1: Why is Access not automatically selecting the "E mail address" (in the editing hyperlink window)?
Question 2: I would like to be able to change this setting easily and not have to edit each customer's details individually. What can I do?
Please help.
Thank you.