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

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 12:52
Joined
Feb 28, 2001
Messages
26,999
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, 17:52
Joined
Sep 21, 2011
Messages
14,045
......................... ? 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

Top Bottom