A
A. Smart
Is there some sort of auto fill feature available when creating Access
tables? Something similar to the one used in excel.
Cheers
tables? Something similar to the one used in excel.
Cheers
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Brendan Reynolds
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.
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.
X
xRoachx
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.
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.
D
David Nolin
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.
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?!?)
J
John W. Vinson/MVP
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...
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?!?)
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.
P
Penny
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!
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!