How do I duplicate words in Access?

D

Donald

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
 
R

Rick B

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.
 
D

Donald

Rick B said:
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.
Click to expand...

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?
 
J

John Vinson

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
Click to expand...

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]
 
D

Donald

John Vinson said:
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]
Click to expand...

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
 
J

John Spencer

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 ...
 
Top