how do i fill down data in access?

[fill down or select more that 1 cell]

I am trying to fill down a number (not formula) for several rows in an access
database. It won't even allow me to select more than one cell to paste. I
am sick of copying and pasting in each cell! If anyone knows a way around
this it would be much appreciated. I am so used to using excel which is much
more user friendly, acces is driving me crazy!

 

[LeAnne]

Hi,

Access is perfectly user-friendly (well...make that "mostly") when used
for its intended purpose. Even though it may look similar, an Access
database table is NOT an Excel spreadsheet. The correct way to fill in
multiple fields (not "cells") in existing records is to use an Update
query. Search Help for "Change records as a group using an update
query."

hth,

LeAnne

 

[Rick B]

Use an update query.


"fill down or select more that 1 cell" <"fill down" or select more that 1
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Padre]

And what would that code be and how would you place it on the form?
Jack Nanz

 

[Jacky]

To fill down the value in the same field column, follow the following steps:
1. Open Excel table
2. On the top cell, input the same name as the field in the database that
you are trying to paste to
3. On the subsequent rows (no. of rows would depends on how many rows of
entry in access that you want to paste the value), duplicate the value for
copying
4. Switch to Access now, and select the rows to be pasted with, can paste in

All should be done correctly. Other fields values would not be affected.