how do i fill down data in access?

[Guest]

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

 

[Peter R. Fletcher]

A database isn't a spreadsheet! The Datasheet view of a Table or Query
may look like what you see when you look at a spreadsheet, but the
underlying data structure is very different, and, in a database, will
not support what you are trying to do.

There are various ways of entering data efficiently when there is a
lot of repetition in one or more of your fields - most of them require
you to set up a data entry form and write some code to make the
default value for each of the repetitive field(s) equal to what is put
in that field for the previous record.

Another possibility is that you are doing something that would
actually be better an/or more easily done in spreadsheet - you can
always link the spreadsheet to Access if you wish to manipulate the
data in it later.

On Mon, 27 Sep 2004 11:13:07 -0700, ""fill down" or select more that 1
cell" <"fill down" or select more that 1

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!

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher

 

[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]...

 

[Guest]

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.