How to Primary Key begin 1 after "delete all data". (1 Viewer)

The_Doc_Man

Happy Retired Curmudgeon
Local time
Today, 08:16
Joined
Feb 28, 2001
Messages
16,766
Tera, the trick is that the table must be de-populated for the reset to occur. Otherwise, as Pat pointed out, it just resets to the next available number after the highest extant number currently in the table.
 

Gasman

Enthusiastic Amateur
Local time
Today, 14:16
Joined
Sep 21, 2011
Messages
5,686
......................... ? Sub ResetTableNumber(pstrTable As String, pstrID As String)
What is code in the blank dot place...
can you attached a db please
I have no idea as to what you are talking about.?
I cannot see any text before the sub? I even copied it using the clipboard button and it displays to me as it does in the thread.?

If you have it for some strange reason just delete everything before the sub. ?
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom