S sunserve Registered User. Local time Today, 18:38 Joined Feb 14, 2006 Messages 11 Mar 14, 2006 #1 I was entering records using a form and all was well until suddenly the autonumbering went from 7 to 14! I went into the table and deleted #14 and tried it again - same thing happened.
I was entering records using a form and all was well until suddenly the autonumbering went from 7 to 14! I went into the table and deleted #14 and tried it again - same thing happened.
KenHigg Registered User Local time Today, 18:38 Joined Jun 9, 2004 Messages 13,310 Mar 14, 2006 #2 Sounds like you are depending on the autonnumber feature to provide you with a record count... And this is generally badd juju...
Sounds like you are depending on the autonnumber feature to provide you with a record count... And this is generally badd juju...
S sunserve Registered User. Local time Today, 18:38 Joined Feb 14, 2006 Messages 11 Mar 15, 2006 #3 Is there a way to make autonumbering consecutive?
RuralGuy AWF VIP Local time Today, 16:38 Joined Jul 2, 2005 Messages 13,824 Mar 15, 2006 #4 The simple answer is *NO*! If you need consecutive numbers then you need to develop your own function.
The simple answer is *NO*! If you need consecutive numbers then you need to develop your own function.
