I have a primary key in a table that is not autonumbered. It is in this format, C000001. On my form, I want a textbox to show what the next number will be. How would I go about doing this?
Show next number in sequence
Competent Performer
Windows 7 32bit 
Access 2010 32bit
I have a primary key in a table that is not autonumbered. It is in this format, C000001. On my form, I want a textbox to show what the next number will be. How would I go about doing this?
VIP
Windows 7 64bit Access 2010 32bit
Generating custom unique ID requires VBA.
Common topic, search forum: unique identifier
Start with:
https://www.accessforums.net/access/...ers-21361.html
http://forums.aspfree.com/microsoft-...ta-403208.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Find First number in sequence of numbers
Create a sequence number for each record associated to a foreign key
Posting Permissions
Reply With Quote