address

[He cries for help]

How can I input an entire address on a from or report , this list is
currently in excel?
I want it to enter like the example below when chosen from a drop down list.

AB fabricators
124 Main
Anywhere, Texas 43434
POC John Doe
Fax 999-999-9999
Phone 888-888-888

 

[John W. Vinson]

How can I input an entire address on a from or report , this list is
currently in excel?
I want it to enter like the example below when chosen from a drop down list.

AB fabricators
124 Main
Anywhere, Texas 43434
POC John Doe
Fax 999-999-9999
Phone 888-888-888

Without knowing *how* "this list is currently in Excel" it's more than a bit
hard to say.

I'd strongly suggest importing the data into an Access Table or Tables with
fields for the various components - CompanyName, Address, City, State,
Postcode, etc. (don't know what POC means...) and creating a Report with
textboxes for these various fields.

John W. Vinson [MVP]

 

[He cries for help]

John, each componet is in excel under seperate columns, I want to enter the
business name by selecting it in a dropdown then let the rest of the
information auto enter. (POC is Point of Contact) My main interest is enter
all this information on a form.

 

[John W. Vinson]

John, each componet is in excel under seperate columns, I want to enter the
business name by selecting it in a dropdown then let the rest of the
information auto enter. (POC is Point of Contact) My main interest is enter
all this information on a form.

WHY?

A form is *just a window*. It doesn't contain data. If you already have the
data in separate fields in a spreadsheet, you *HAVE* the data, and don't need
to enter it again! Just link to the spreadsheet, or import it into a table.

Maybe I'm misunderstanding the nature of the problem!

John W. Vinson [MVP]

 

[Jeanette Cunningham]

This database will be used for writing purchase orders and historical cost
of
materials. I have not programed a table for addresses yet. The form will
reflect the current form used for purchase orders i.e. Address, blocks to
define items to be purchased, requirements, signature areas, shipping, cost
etc.

Without knowing *how* "this list is currently in Excel" it's more than a bit
hard to say.

I'd strongly suggest importing the data into an Access Table or Tables with
fields for the various components - CompanyName, Address, City, State,
Postcode, etc. (don't know what POC means...) and creating a Report with
textboxes for these various fields.

John W. Vinson [MVP]

To import the data from Excel, you need to go to File > Get External Data >
Import

If you only need to link to the data, you go File > Get External Data >
LinkTables and choose Excel for the file type.

Post back when you need to.

Jeanette Cunningham