Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 15th, 2005, 03:59 AM
Authorized User
 
Join Date: Mar 2005
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default auto generate an number

hi,
I am creating a system by using A2k. I want to assign a document number (sample : A001) to each record that has been added. Is there any way to auto generate a document number in access? which means i do not want the user to key in, the document number will be generated when / after the add button is pressed.

thanks
 
Old March 22nd, 2005, 08:14 AM
Registered User
 
Join Date: Dec 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Rogers Access Library --- Excellent compendium of Access 2000 routines from Roger Carlson. Here >>> http://www.rogersaccesslibrary.com/TableOfContents3.asp

Roger provides a particular example, http://www.rogersaccesslibrary.com/d...berProblem.mdb
if you are going to have multiple users of your database, there is one issue you should be aware of. And that is it is possible that two users could create the same number at the same time. One of Rogers' samples shows a method of handling this problem.

 
Old March 28th, 2005, 02:24 AM
Authorized User
 
Join Date: Mar 2005
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks a lot for your help Uncle Gizmo







Similar Threads
Thread Thread Starter Forum Replies Last Post
C# Auto Generate Codes lasith C# 0 February 23rd, 2007 02:25 AM
how to auto generate date? okboy SQL Server 2000 3 December 12th, 2006 08:17 PM
Auto generate no mateenmohd Classic ASP Basics 3 June 11th, 2006 07:06 AM
Auto generate? nikryden BOOK: Beginning VB.NET Databases 2 December 19th, 2005 12:43 PM
How to create auto generate variables? yikchin JSP Basics 1 December 19th, 2005 07:27 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.