By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,686 Members | 2,756 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,686 IT Pros & Developers. It's quick & easy.

"Autonumber"

P: n/a
Tom
Is there a way to not display "Autonumber" in the primary key testbox when the
PK is an autonumber in a new record?

Tom
Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
If it is a form, set the Text Box's Visible property to No. Autonumbers are
intended for "internal use", joining related tables, not for display to the
user.

If it is in a Datasheet View of the Table, I don't think there is a way.
Then, again, if you are giving users datasheet view in a developed database
application, you probably ought to reconsider that -- it is not a good idea.

Larry Linson
Microsoft Access MVP

"Tom" <th*******@bellsouth.net> wrote in message
news:4z******************@newsread2.news.atl.earth link.net...
Is there a way to not display "Autonumber" in the primary key testbox when the PK is an autonumber in a new record?

Tom

Nov 12 '05 #2

P: n/a
On Sun, 09 Nov 2003 21:44:32 GMT, "Tom" <th*******@bellsouth.net>
wrote:

Make the field invisible. You shouldn't care what the value is anyway.
-Tom.

Is there a way to not display "Autonumber" in the primary key testbox when the
PK is an autonumber in a new record?

Tom


Nov 12 '05 #3

P: n/a

"Tom" <th*******@bellsouth.net> wrote in message
news:4z******************@newsread2.news.atl.earth link.net...
Is there a way to not display "Autonumber" in the primary key testbox when the PK is an autonumber in a new record?

Tom


Best place to get answers is at the official MVP site:
http://mvp.org
Stuart T. Bingham (MVP)
Nov 12 '05 #4

P: n/a
I think that would be http://mvps.org (http://www.mvps.org also works). The site you gave
opens up an endless stream of pages, and wants to install a control that is not trusted.
Arrrrrrrgghhhhh.

_____________________________________________
"Stuart T. Bingham" <bi*******@yahoo.fr> wrote in message
news:c4******************************@news.teranew s.com...

"Tom" <th*******@bellsouth.net> wrote in message
news:4z******************@newsread2.news.atl.earth link.net...
Is there a way to not display "Autonumber" in the primary key testbox when the PK is an autonumber in a new record?

Tom


Best place to get answers is at the official MVP site:
http://mvp.org
Stuart T. Bingham (MVP)

Nov 12 '05 #5

P: n/a
CDB
Ah, Tom, you have been bitten by this group's bete noir, Don. Can any good
thing come from Teranews? Why they cannot even spell their own name
correctly!

Clive

"Tom Wickerath" <AO***********************@comcast.net> wrote in message
news:Iq********************@comcast.com...
I think that would be http://mvps.org (http://www.mvps.org also works). The site you gave opens up an endless stream of pages, and wants to install a control that is not trusted. Arrrrrrrgghhhhh.

_____________________________________________
"Stuart T. Bingham" <bi*******@yahoo.fr> wrote in message
news:c4******************************@news.teranew s.com...

"Tom" <th*******@bellsouth.net> wrote in message
news:4z******************@newsread2.news.atl.earth link.net...
Is there a way to not display "Autonumber" in the primary key testbox
when the
PK is an autonumber in a new record?

Tom


Best place to get answers is at the official MVP site:
http://mvp.org
Stuart T. Bingham (MVP)

Nov 12 '05 #6

P: n/a
You're right....I was fooled because the username looked somewhat legit (binghamhq). I've
noticed that our resident troll usually uses e-mail addresses with usernames that are
pretty obviously Don, such as: access_morons, ohgumkfarjxv, etc. You got me Don.
(Actually, I noticed the incorrect URL, but I decided to try it out first before reporting
it, just in case it worked too). It looks like the folks that run that web site are
capitalizing on people entering an incorrect URL for a fairly popular site.

________________________________________

"CDB" <al***@delete.wave.co.nz> wrote in message news:bo**********@news.wave.co.nz...

Ah, Tom, you have been bitten by this group's bete noir, Don. Can any good
thing come from Teranews? Why they cannot even spell their own name
correctly!

Clive

"Tom Wickerath" <AO***********************@comcast.net> wrote in message
news:Iq********************@comcast.com...
I think that would be http://mvps.org (http://www.mvps.org also works). The site you gave opens up an endless stream of pages, and wants to install a control that is not trusted. Arrrrrrrgghhhhh.

_____________________________________________
"Stuart T. Bingham" <bi*******@yahoo.fr> wrote in message
news:c4******************************@news.teranew s.com...

"Tom" <th*******@bellsouth.net> wrote in message
news:4z******************@newsread2.news.atl.earth link.net...
Is there a way to not display "Autonumber" in the primary key testbox
when the
PK is an autonumber in a new record?

Tom


Best place to get answers is at the official MVP site:
http://mvp.org
Stuart T. Bingham (MVP)


Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.