https://www.webmaster-forums.net/crss/node/1018834 en https://www.webmaster-forums.net/web-database-development/help-next-number-sequence-access#comment-1111341 <p>Cheers Folks.<br /> I'll bear all your advice in mind.<br /> Thanks for the replies<br /> Regards<br /> Andrew</p> Sat, 13 Jul 2002 01:20:29 +0000 Andrew_Samuel comment 1111341 at https://www.webmaster-forums.net https://www.webmaster-forums.net/web-database-development/help-next-number-sequence-access#comment-1111252 <p>Access is painfully inadequate in this area. Once you've defined a field as a certain type you cannot change it to autonumber, and even if you did it would start at 1. With a RDBMS you could easily change the datatype to autonumber (identity) and tell it what number you would like to start at.</p> <p>You will have to do a lookup to see what the last reference number was and create a record with the new reference number.</p> <p>Maybe it's time to upgrade to a better database?</p> Wed, 10 Jul 2002 12:38:17 +0000 Peter J. Boettcher comment 1111252 at https://www.webmaster-forums.net https://www.webmaster-forums.net/web-database-development/help-next-number-sequence-access#comment-1111240 <p>i believe you'd have to handle this in a form with VBA code. if all you wanted were an auto-incrementing number you could create a field of the type 'autonumber', but that would just be a number and wouldnt fit your current CX/YY/** format.</p> <p>with an enterprise databases, you could do it (i think). Access isn't really very ANSII compliant, and doesn't support many SQL features.</p> Wed, 10 Jul 2002 00:21:17 +0000 ROB comment 1111240 at https://www.webmaster-forums.net