In Access, I Can't Believe No One Can Figure An Easy Way To Do This!

[3dmap1]

A department at my office uses an old MS-Works database. The employees there like it because it is simple to use. I designed a database in MS-Access (2000) that essentially works the same and is easy to use (which is what they want and need).
The one problem I have which works better in Works than in Access is that when they are entering customer information in the Works database table (like mailing addresses),if the city is the same for 60 records, they can type the city in the 1st cell, hit copy, highlight the other 59 cells and hit paste. In Access, if you copy one cell, you can only paste to one cell, if you copy 3 cells, you can paste to three cell and so on.
Is there a way to rectify this that will be easy for these employees to use? They could use Excel to enter the information and import it to Access but that would be more hassle for them and they would just rather keep using Works.
Any help or advice would be appreciated.

 

[Dreamboat]

Is it almost always the same city?

Set the field in the table to have that city as default.

Make the field a listbox, while allowing them to add to the list?

How many cities are we talking?

Also, Ctrl+' repeats the last record's entry.

Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[3dmap1]

Not always the same city, sometimes in 400 records you may have 2 or 3 groups of 60 each of the same city. The cities may vary, sometimes 20 or 30 cities, depending on the job.

 

[Dreamboat]

Then my suggestion is to have them use Ctrl+' unless you can find a coder who can perhaps code that control to default to the last entry, and if it's changed by the user, then it defaults to the new one. Maybe even a little command button next to the box that says "lock" so the user can turn the default on and off...

Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX