Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / April 2005

Tip: Looking for answers? Try searching our database.

Autonumber on a form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
KateAccess - 08 Apr 2005 11:47 GMT
Can anyone tell me how to set up an autonumber on a form (I'll hide it)
please? I would also like to know how to make this my primary key. Any
suggestions?
Larry Daugherty - 08 Apr 2005 12:18 GMT
Hi Kate,

You don't set it up on your form.  You would usually make the first
field in your table, say tblPerson, PersonID and give it a type of
Autonumber and click the key icon to make it the primary key..  If you
then include field PersonID in your query for the form, PersonID will
be available on the form.

You're wise to hide it.  That way, people won't wonder what it's all
about nor try to constrain its behavior.

HTH
Signature

-Larry-
--

> Can anyone tell me how to set up an autonumber on a form (I'll hide it)
> please? I would also like to know how to make this my primary key. Any
> suggestions?
Jeff Boyce - 08 Apr 2005 12:27 GMT
In Access, tables store data, forms display it.

Start at the beginning.  Autonumbers are data.  Data lives in tables.  You
need an autonumber type field in a table first.  In the table definition,
make it the autonumber.

Then, use either a query or refer directly to the table to place controls on
a form.

Signature

Good luck

Jeff Boyce
<Access MVP>

> Can anyone tell me how to set up an autonumber on a form (I'll hide it)
> please? I would also like to know how to make this my primary key. Any
> suggestions?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.