By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,457 Members | 1,301 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,457 IT Pros & Developers. It's quick & easy.

I need some help!

P: n/a
Jim
I am just starting to put together a simple First name, Last name, Address,
City/State, Zip, Phone, & etc. database and I have several thousand entries
to make, many of which will have the same City/State and Zip code. I am
running Access 2000 v 9.0 Is there not an "auto complete" function that will
assist in the repetitive entry of all these same field entries?
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Excel has auto complete functions as well as the ability to drag down the
column for multiple entries. I would enter the data into Excel and then
import the file into Access.
" Jim" <jf***@gvtc.cm> wrote in message
news:x7******************@eagle.america.net...
I am just starting to put together a simple First name, Last name, Address, City/State, Zip, Phone, & etc. database and I have several thousand entries to make, many of which will have the same City/State and Zip code. I am
running Access 2000 v 9.0 Is there not an "auto complete" function that will assist in the repetitive entry of all these same field entries?

Nov 12 '05 #2

P: n/a
On Wed, 7 Jan 2004 15:45:25 -0600, " Jim" <jf***@gvtc.cm> wrote:
I am just starting to put together a simple First name, Last name, Address,
City/State, Zip, Phone, & etc. database and I have several thousand entries
to make, many of which will have the same City/State and Zip code. I am
running Access 2000 v 9.0 Is there not an "auto complete" function that will
assist in the repetitive entry of all these same field entries?

You could use bound combo boxes with the RowSource query using a
SELECT DISTINCT of the field.

For example: For the city create a cboCity the RowSource would be...

SELECT DISTINCT City
FROM tblAddress ORDER BY City;

Do a DropDown in the Change event so the combo will drop-down when the
first character is typed.

Requery the combos in the Form's AfterUpdate event.

- Jim
Nov 12 '05 #3

P: n/a
Hi Jim,

First, I recommend you put City and State in separate fields. Someday you will
be glad you did that!!!

On your data entry form, put the following code in the AfterUpdate event of the
City field:

Me!City.Default = Me!City

In the AfterUpdate event of State field:

Me!State.Default = Me!State

In the AfterUpdate event of Zipcode field:

Me!ZipCode.Default = Me!Zipcode

Enter your data in groups where the City, State and Zipcodes are the same.

For each group, after you enter the first record, you will see the City, State
and Zipcode you entered become the default values. All you have to do then for
the rest of the records in the group is enter the First Name, Last Name, Phone
etc and City, State and Zipcode will be automatically entered in the record. If
they change, just type over what has changed and that then becomes the new
default.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

" Jim" <jf***@gvtc.cm> wrote in message
news:x7******************@eagle.america.net...
I am just starting to put together a simple First name, Last name, Address,
City/State, Zip, Phone, & etc. database and I have several thousand entries
to make, many of which will have the same City/State and Zip code. I am
running Access 2000 v 9.0 Is there not an "auto complete" function that will
assist in the repetitive entry of all these same field entries?

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.