A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Autonumbering



 
 
Thread Tools Display Modes
  #1  
Old October 19th, 2005, 07:21 PM
Camille Burns
external usenet poster
 
Posts: n/a
Default Autonumbering

Is there a way to disable autonumber in Access?
  #2  
Old October 19th, 2005, 07:48 PM
BruceM
external usenet poster
 
Posts: n/a
Default Autonumbering

Choose a different data type in table design view.

"Camille Burns" Camille wrote in message
...
Is there a way to disable autonumber in Access?



  #3  
Old October 19th, 2005, 07:52 PM
Rick B
external usenet poster
 
Posts: n/a
Default Autonumbering

Yes, change the field type to something that is not autonumber.

Your question is very vague. Please explain.

Do you want to prevent your users from building databases with an
autonumber? Do you want to turn of the autonumber feature for an existing
field? Details please.

--
Rick B



"Camille Burns" Camille wrote in message
...
Is there a way to disable autonumber in Access?



  #4  
Old October 19th, 2005, 08:28 PM
Duane Hookom
external usenet poster
 
Posts: n/a
Default Autonumbering

If you are referring to the Autofill mis-feature, then there is no way (that
I am aware of) to turn it off. Data entry should be done through forms where
I believe this is not a problem.

--
Duane Hookom
MS Access MVP
--

"Camille Burns" Camille wrote in message
...
Is there a way to disable autonumber in Access?



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Temporarily switch off records autonumbering, then restore records autonumbering. Joe M Running & Setting Up Queries 3 April 11th, 2005 02:25 AM
Temporarily switch off records autonumbering, then restore records autonumbering. Joe M Database Design 3 April 11th, 2005 02:25 AM
autonumbering thebigmac General Discussion 2 January 12th, 2005 10:05 PM
Autonumbering from 10000 ria New Users 2 November 4th, 2004 01:03 AM
Compact&Repair: Autonumbering NOT Reset Alan Guy General Discussion 3 September 27th, 2004 04:41 AM


All times are GMT +1. The time now is 03:30 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.