I'm working on an address database and some of the addresses and company
names are the same. What can I do to avoid typing the same words over and
over?(auto fill when I type the first couple of letters)

Thank You

You would need to give us some examples.

If you have a company with ten contacts, then you should probably have at
least two tables. One would store the company name and address information.
A second related table would store the contact names and direct phone
numbers, emails, etc. This is a classic one-to-many relationship.

--
Rick B



"Donald" <(E-Mail Removed)> wrote in message
news:8161D9C9-0466-43CE-BE18-(E-Mail Removed)...
> I'm working on an address database and some of the addresses and company
> names are the same. What can I do to avoid typing the same words over and
> over?(auto fill when I type the first couple of letters)
>
> Thank You

"Rick B" wrote:

> You would need to give us some examples.
>
> If you have a company with ten contacts, then you should probably have at
> least two tables. One would store the company name and address information.
> A second related table would store the contact names and direct phone
> numbers, emails, etc. This is a classic one-to-many relationship.
>
> --
> Rick B
>
>
>
> "Donald" <(E-Mail Removed)> wrote in message
> news:8161D9C9-0466-43CE-BE18-(E-Mail Removed)...
> > I'm working on an address database and some of the addresses and company
> > names are the same. What can I do to avoid typing the same words over and
> > over?(auto fill when I type the first couple of letters)
> >
> > Thank You

For example I"m formatted this way.
Titile 1st name Last name Company Address City
State Zip
Realtor Joan Bass One Realty 222 Can Chicago
IL 60622
Realtor Ben Plano One Realty 222 Can Chicago
IL 60622
As you can see i'm typing some of the same entries. In other programs I type
the beginning of a word and auto fill takes over. What can I do to shorten my
typing time?
>

On Mon, 1 May 2006 09:43:02 -0700, Donald
<(E-Mail Removed)> wrote:

>I'm working on an address database and some of the addresses and company
>names are the same. What can I do to avoid typing the same words over and
>over?(auto fill when I type the first couple of letters)
>
>Thank You

Use a Combo Box on the Form you're using to enter the data.

As requested - a bit more information about your database structure
would help us provide better answers.

John W. Vinson[MVP]

"John Vinson" wrote:

> On Mon, 1 May 2006 09:43:02 -0700, Donald
> <(E-Mail Removed)> wrote:
>
> >I'm working on an address database and some of the addresses and company
> >names are the same. What can I do to avoid typing the same words over and
> >over?(auto fill when I type the first couple of letters)
> >
> >Thank You
>
> Use a Combo Box on the Form you're using to enter the data.
>
> As requested - a bit more information about your database structure
> would help us provide better answers.
>
> John W. Vinson[MVP]
>

It's a basic data base for mail merge, consisting of name, company, address,
city, state and zip. For example in the company column I type Hunter's Realty
and in the next row same column I want the same entry. This maybe typed 7-8
times and then the company name will change

Try typing Control + Quote. That should copy the data from the previous record
into the current record IF there are multiple records in the recordset.

As mentioned elsewhere in this thread, you probably need to look at redesigning
this database to make it more efficient, but ...

Donald wrote:
>
> "John Vinson" wrote:
>
> > On Mon, 1 May 2006 09:43:02 -0700, Donald
> > <(E-Mail Removed)> wrote:
> >
> > >I'm working on an address database and some of the addresses and company
> > >names are the same. What can I do to avoid typing the same words over and
> > >over?(auto fill when I type the first couple of letters)
> > >
> > >Thank You
> >
> > Use a Combo Box on the Form you're using to enter the data.
> >
> > As requested - a bit more information about your database structure
> > would help us provide better answers.
> >
> > John W. Vinson[MVP]
> >
>
> It's a basic data base for mail merge, consisting of name, company, address,
> city, state and zip. For example in the company column I type Hunter's Realty
> and in the next row same column I want the same entry. This maybe typed 7-8
> times and then the company name will change