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: 28 Mar 2024 at 4:55am
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


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" rel="nofollow - 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 2010-2019 accdb:  uploads/5/AutonumberProblem_2010.zip" rel="nofollow - AutonumberProblem_2010.zip
Access 2000-2010 mdb (262 KB): http://www.rogersaccesslibrary.com/forum/uploads/5/AutonumberProblem2k.zip" rel="nofollow - AutonumberProblem2k.zip
Access 97 (25 KB): http://rogersaccesslibrary.com/download3.asp?SampleName=AutonumberProblem.mdb" rel="nofollow - 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: 17 Mar 2020 at 7:17pm
Added 2010-2019 accdb version

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



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 - http://www.webwizforums.com
Copyright ©2001-2019 Web Wiz Ltd. - https://www.webwiz.net