S
Steven Burn
I'm curious, I've written a very simple PIS (personal info store) that
allows one to store whatever they wish..... the problem is, when one deletes
an entry, the auto-numbering isn't corrected to account for said
deletion..... for example;
1. entry 1
2. entry 2
3. entry 3
delete entry 2, and #2 is no longer available (i.e. 3 should become 2, 4,
become 3 etc etc).....
Anyone know of a way to tell Access to re-number them when an entry is
deleted?
Apologies if this makes absolutely no sense.... I've been awake for hours
and am absolutely shattered \
--
Regards
Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk
Keeping it FREE!
Disclaimer:
I know I'm probably wrong, I just like taking part ;o)
allows one to store whatever they wish..... the problem is, when one deletes
an entry, the auto-numbering isn't corrected to account for said
deletion..... for example;
1. entry 1
2. entry 2
3. entry 3
delete entry 2, and #2 is no longer available (i.e. 3 should become 2, 4,
become 3 etc etc).....
Anyone know of a way to tell Access to re-number them when an entry is
deleted?
Apologies if this makes absolutely no sense.... I've been awake for hours
and am absolutely shattered \
--
Regards
Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk
Keeping it FREE!
Disclaimer:
I know I'm probably wrong, I just like taking part ;o)