Re: [AccessDevelopers] Auto Complete Sequence in Unique Field

[A.D.Tejpal]

SBoone,       My sample db named AppendSequence might be of interest to you. It is available at Rogers Access Library (other developers library). Link - http://www.rogersaccesslibrary.com       You could adapt the underlying approach suitably, for your specific needs.   Best wishes, A.D.Tejpal --------------   ----- Original Message ----- From: sboone1982 To: AccessDevelopers@yahoogroups.com Sent: Friday, September 16, 2005 21:41 Subject: [AccessDevelopers] Auto Complete Sequence in Unique Field Hello Everyone, I'm trying to figure out if there is a way to autonumber a unique key field but to have it autonumber in a specific order.  The issue is that we have inventory stickers that we mark on boxes but I need the auto-complete or auto-number to match with the sticker.  I also need to be able to have the field editable in case we lose a roll of stickers and have to start at a number that isn't part of the current sequence.  The field is alpha-numeric. Any thoughts or suggestions would help greatly! Thanks! SBoone Please zip all files prior to uploading to Files section. YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.