Print Page | Close Window

AutonumberProblem.mdb (beginner)

Printed From: Roger's Access Library
Category: Roger's Access Library
Forum Name: Roger's Download Samples
Forum Description: A compendium of Microsoft Access 97 and 2000+ routines, each separated into its own sample database.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=395
Printed Date: 22 Oct 2017 at 3:12pm


Topic: AutonumberProblem.mdb (beginner)
Posted By: Roger Carlson
Subject: AutonumberProblem.mdb (beginner)
Date Posted: 04 Aug 2008 at 3:40am
Please consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm - find out why here .
 
 
This sample illustrates a number of ways to simulate your own Autonumber primary key.

Form1 illustrates how to use the DMax function to simulate the action of the Autonumber field.

Form2 does much the same as the Products form, but allows for multi-user collisions.
 
Download:

Access 2000-2010 mdb (262 KB): http://www.rogersaccesslibrary.com/forum/uploads/5/AutonumberProblem2k.zip - AutonumberProblem2k.zip
Access 97 (25 KB): http://rogersaccesslibrary.com/download3.asp?SampleName=AutonumberProblem.mdb - AutonumberProblem97.zip
 
.


-------------
Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<



Replies:
Posted By: Roger Carlson
Date Posted: 23 Dec 2010 at 6:40am
Update: Added documentation to AutonumberProblem2k.zip

-------------
Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<



Print Page | Close Window