How To Auto-Increment A Field In MS Access 2007?

[Mr Access]

I'm accustomed to Access 2003 where you can enter a number in field 1 - say
100, then below that enter 110 and just arrow down from that point as the
program automatically detected you are incrementing and were sequencing by
ten - it would automatically enter 120 in the next field and 130 in the next
and so on until you stop arrowing down... Access 2007 does not have this
feature called out in any of it's help screens or online searches. Is this
feature lost in 2007?

 

[Gina Whipp]

Mr. Access,

That feature is gone in 2007. For myself, I am thrilled as it drove me
crazy but I see you miss it... sorry

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Paul Shapiro]

Are you sure that was in Access? I've only seen it in Excel. Too bad I
missed it, if it used to be available.

 

[Gina Whipp]

Paul,

Yep, it was Access... drove me nuts!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[John W. Vinson]

On Wed, 25 Feb 2009 12:38:01 -0800, Mr Access <Mr

I'm accustomed to Access 2003 where you can enter a number in field 1 - say
100, then below that enter 110 and just arrow down from that point as the
program automatically detected you are incrementing and were sequencing by
ten - it would automatically enter 120 in the next field and 130 in the next
and so on until you stop arrowing down... Access 2007 does not have this
feature called out in any of it's help screens or online searches. Is this
feature lost in 2007?

They finally got rid of this misfeature... ooops, sorry, you liked it <g>

Seriously, in a properly normalized database you'ld never need this; and you
should not be working in table datasheets in any case. You can write code in a
Form to autoincrement a field if you need that capability.