Auto fill Feature?!?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there some sort of auto fill feature available when creating Access
tables? Something similar to the one used in excel.
Cheers
 
Not really, no. If you have a series of numbers in a column, e.g. 1, 2, 3,
then Access will insert the next number in the series (4 in this example)
when you use the arrow keys to move to the same column in the next row (a
'feature' which drives experienced database developers crazy) but there is
nothing like the click-and-drag auto-fill feature in Excel.
 
As Brendan stated, there is not a feature to auto fill but you can make use
of other features to accomplish what you want. One option is using a default
value for a field so that when a new record is created, the value in the
field will always be the same. Another option is to use an Update query to
update your table.
 
Brendan Reynolds said:
Not really, no. If you have a series of numbers in a column, e.g. 1, 2, 3,
then Access will insert the next number in the series (4 in this example)
when you use the arrow keys to move to the same column in the next row (a
'feature' which drives experienced database developers crazy) but there is
nothing like the click-and-drag auto-fill feature in Excel.
Click to expand...

Yes, this so-called "feature" is driving me mad! How do I turn it off? I've
searched through all the Customize and Option menus but have had no luck...

(Why is this SPREADSHEET "feature" even part of a DATABASE program?!?)
 
Yes, this so-called "feature" is driving me mad! How do I turn it off?
I've
searched through all the Customize and Option menus but have had no
luck...
Click to expand...

There is no Off switch. Solution: don't use datasheets. Continuous Forms can
be made to look like datasheets if you wish, and don't suffer this
misfeature.
(Why is this SPREADSHEET "feature" even part of a DATABASE program?!?)
Click to expand...

Somebody at Microsoft (probably Microsoft Marketing) thought it made sense
(of course they were mistaken). I believe that the developers managed to
persuade the Powers That Be to let them remove this idiocy in A2007.
 
Any idea how what you need to type in the update query to get it to auto fill
numbers like it used to in Access 2000? Other people seem to be driven mad
by this feature, but it is driving me mad that it has been removed!

Thanks!
 
Back
Top