View Single Post
  #6  
Old November 24th, 2004, 05:32 PM
Tim Ferguson
external usenet poster
 
Posts: n/a
Default

John Vinson wrote in
:

If you care what the value is, or want to see it, you
should use a Long Integer field instead, and maintain its value
manually or in VBA code.


To be fair, John, I read the OP message as wanting to restore two records
that had been accidentally lost. If the autonumber has been propagated onto
other records (eg paper forms, remote database, spreadsheet etc) then it's
reasonable to want to put them back as they were. It's not necessarily a
cosmetic don't-want-gaps-in-the-numbers scenario.

B Wishes


Tim F