Access Tables

[Ed Wyche]

When inside the table if I start numbers in a field and then arrow down to
the next record put another sequential number and I arrown down it
automatically puts the next number in. Is there away of stopping that.

Example
1
2
3 is automatically put in
4 is automatically put in

 

[Joseph Meehan]

Why do I think you are putting number in an Excel Spreadsheet not number
in a Access database table???

Access should not be doing it that way. It does have autonumbers but
they don't act exactly like that. I suspect you need the Excel newsgroup.
When you get there, be sure to tell them what version of Excel you are
using, they are not all the same.

Sorry. This is a newsgroup dedicated to questions about Access, a
Microsoft database program. It appears your question may not be related to
these subjects. The Microsoft help system is not all that clear and may have
misdirected you here.

It is best to ask your questions in a newsgroup dedicated to the
subject of your question. You should find people better able to address
your problem there.

Note: It is always best to indicate the name and version of any
program(s) you may be using when asking a question and also indicate the
operating system (like Windows XP or 98) when you ask a question.

 

[John Vinson]

Why do I think you are putting number in an Excel Spreadsheet not number
in a Access database table???

Because it's behaving like Excel. Reasonable supposition but...

Access should not be doing it that way. It does have autonumbers but
they don't act exactly like that.

We all agree with you, Joseph - however, since A2000 came out, this
inappropriate behaviour has been happening in Access as well. Somebody
at Microsoft thought (wrongly!) that "it would be helpful". It's a
misfeature, and quite a few MVP's have yelled loud and clear to the
Access development group about it. It's still in 2003 though.

John W. Vinson[MVP]

 

[John Vinson]

When inside the table if I start numbers in a field and then arrow down to
the next record put another sequential number and I arrown down it
automatically puts the next number in. Is there away of stopping that.

Example
1
2
3 is automatically put in
4 is automatically put in

This is a misfeature introduced with A2000. You're right, it should
not be happening. Unfortunately there is no way to turn it off *in
datasheets*.

The solution is to create a Form (preferably a Continuous Form made to
look like a datasheet, if you like that view). It happens in
datasheets but *not* in such forms. This is just one of many reasons
to use Forms for data entry rather than directly updating tables.

John W. Vinson[MVP]

 

[Joseph Meehan]

Because it's behaving like Excel. Reasonable supposition but...


We all agree with you, Joseph - however, since A2000 came out, this
inappropriate behaviour has been happening in Access as well. Somebody
at Microsoft thought (wrongly!) that "it would be helpful". It's a
misfeature, and quite a few MVP's have yelled loud and clear to the
Access development group about it. It's still in 2003 though.

John W. Vinson[MVP]

Thanks John. I will try to remember that. I am working with 2000 now
and I expect I may be moving to 2003 soon.