K
Ken Hubbard
I am new to using ADO, but familiar with Visual Basic.
I use customer numbers to organize delivery routs, and
after adding customers in the middle, I run out of room.
I would like to have a button to renumber the record ID.
I am picturing using ADO to retrieve the records, and
update SQL to change the numbers, but what I am not sure
of is, can I retrieve the records and manipulate them
with out putting them in a Form.Recordsource?
Any Direction is Greatly Appreciated.
I use customer numbers to organize delivery routs, and
after adding customers in the middle, I run out of room.
I would like to have a button to renumber the record ID.
I am picturing using ADO to retrieve the records, and
update SQL to change the numbers, but what I am not sure
of is, can I retrieve the records and manipulate them
with out putting them in a Form.Recordsource?
Any Direction is Greatly Appreciated.