By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,996 Members | 884 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,996 IT Pros & Developers. It's quick & easy.

Arranging Data

Ali Rizwan
100+
P: 927
Hi,
If i delete a record let 5 is the sr no.
now i want to do that the records arrange automatically 1,2,3,4,6,7,8 to 1,2,3,4,5,6,7
12345678 are the records.
I m using vb6 msaccess and ADODC
thanx
Sep 11 '07 #1
Share this Question
Share on Google+
3 Replies


Expert 5K+
P: 8,434
If i delete a record let 5 is the sr no.
now i want to do that the records arrange automatically 1,2,3,4,6,7,8 to 1,2,3,4,5,6,7
I think we need more info about what's in the records, and what they are being arranged by. For example, if the "sr no" is an AutoNumber field, then you cannot change the number, therefore once you delete "5" it's gone forever.
Sep 12 '07 #2

Ali Rizwan
100+
P: 927
I think we need more info about what's in the records, and what they are being arranged by. For example, if the "sr no" is an AutoNumber field, then you cannot change the number, therefore once you delete "5" it's gone forever.
Hi,
I'm using ADO, VB6 and MS Access.
The sr field is not an AutoNumber, it is added manually.
Now I have delete it from VB6 app.
Now I want to arrange all sr nos as 1234567 instead of 1234 67
Thanx
Sep 13 '07 #3

Expert 5K+
P: 8,434
... Now I have delete it from VB6 app.
Now I want to arrange all sr nos as 1234567 instead of 1234 67
Well, it seems as though the simplest thing would be to take the record with the highest number (7 in your example) and update it to 5, to fill the gap.
Sep 14 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.