How do I add e-mail field to existing Access database?

[Guest]

The company Access contact data base file was originally created by wizard.
Now we want to add an e-mail field, origianlly omitted. How can I do this?

 

[Guest]

Sybil,

This is a simple multiple step process:

1- you are going to need to open, in design mode, the table that houses the
information about your contacts (name, address, etc.) and add a new field and
name it appropriatly and set it up as text. Close an save it with your mods.

2- you are going to need to open the form that displays this information, in
design mode, and add this new field. close and save it.

Hope this helps,

Daniel

 

[John Vinson]

The company Access contact data base file was originally created by wizard.
Now we want to add an e-mail field, origianlly omitted. How can I do this?

Open the table in design view, add the field (as a Text field).

You'll also need to be sure that the new field is included in any
Queries based on the table, and add a textbox on the forms or reports
which need it - once you've fixed the query upon which the form is
based, the field will be available in the field list in form design
view.

John W. Vinson[MVP]