I.T. Discussion Community!
-Collapse +Expand
Access
Search Access Group:

Advanced
-Collapse +Expand Access To/From
To/FromCODEGuides
-Collapse +Expand Access Store
PRESTWOODSTORE

Prestwood eMagazine

April Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyMicrosoft Access BoardMS Access Interactive Topic   Print This     

HOW DO YOU GET AN PRIMARY KEY ON A FORM TO FILL IN

HOW DO YOU GET AN PRIMARY KEY ON A FORM TO FILL IN in MS Access Interactive topic (part of our Microsoft Access group).

Quick Search: PRIMARY   HOW DO   HOW DO YOU   GET PRIMARY   KEY FORM   FILL IN  
stuwaddy
 (Inactive)
UK
ORDER_ID FIELD ON A FORM HAS TO BE FILLED IN BEFORE YOU CAN ENTER A SUBFORM OR LINKED FORM, I WANT THE ORDER_ID FIELD TO FILL IN AUTOMATICALLY WITH A AUTONUMBER (AS IT IS A PRIMARY KEY FIELD) WITHOUT YOU HAVING TO ENTER DETAILS IN ANOTHER FIELD AND WAITING FOR THE AUTONUMBER TO FILL IN,

THANKS//.
 Posted 19 years ago (Thread Starter)
Comment Quote
About stuwaddy -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #1473, 1 replies
Thread Started 3/21/2001 12:45:00 PM
View Counter=2116
Last Reply Posted 1/31/2010 9:26:26 AM)
Location=UK  
Joined=19 years ago   MB Posts=1  
Most Recent Post
Moderator
Mike Prestwood
Prestwood IT
Prestwood IT office in Citrus Heights, CA

The answer to this old question is to use an Autoinc field. Restructure the table (select Design mode) and change the field to an Autoinc field. Alternatively, you could spin your own auto incrementing key fields with code.

--
Mike Prestwood
Prestwood IT Solutions

 Posted 10 years ago
Comment Quote
About Mike Prestwood -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Mike Prestwood

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.

Web Presence
Facebook, Prestwood IT Facebook page -- fan page. (Visit Me)
Twitter, Follow Prestwood IT on Twitter. (Visit Me)
LinkedIn, Prestwood IT company page on LinkedIn. (Visit Me)
YouTube, Prestwood IT YouTube Channel (Visit My Channel)
Website, My drum website where I sell my drum books. (http://www.play-drums.com)

Post ID #13904 (Level 1.1)  Reply to 1473
Thread Started 1/31/2010 9:26:26 AM
Location=Prestwood IT office in Citrus Heights, CA 
Joined=20 years ago   MB Posts=1410   KB Posts=1805   KB Comments=69   BLOG, Topics=4  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P184A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #1473 Counter
2116
Since 4/2/2008

Follow PrestwoodBoards on: 


©1995-2020 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech