I have a problem. I am constructing a database of eople's names and
addresses for business purposes. This requires all of the people to be
numbered eg:
1,2,3,4,5,6,7,8,9,10
But the problem lies here: if I have to ever alter the names, I would have
to alter the numbers, which may require slotting someone in between two
people:
1,2,3,4,5,6,7,8, (new person),9,10
so the new person would become 9, 9 becomes 10, and 10 becomes 11.
Currently I am only capable of doing this renumbering manually. Is there any
way of automating the renumbering process? 2 1424
I have a VBA script that will do that automically. I'd be glad to share it
with you. But I must warn you it is for advanced users.
MS-Office Certified: http://www.microsoft.com/learning/mc...st/default.asp
"Chris Potter" <ch***********@bigpond.com> wrote in message
news:65*****************@news-server.bigpond.net.au... I have a problem. I am constructing a database of eople's names and addresses for business purposes. This requires all of the people to be numbered eg: 1,2,3,4,5,6,7,8,9,10
But the problem lies here: if I have to ever alter the names, I would have to alter the numbers, which may require slotting someone in between two people: 1,2,3,4,5,6,7,8, (new person),9,10 so the new person would become 9, 9 becomes 10, and 10 becomes 11.
Currently I am only capable of doing this renumbering manually. Is there any way of automating the renumbering process?
Thanks a lot.
"DC" <nospam> wrote in message news:Up********************@comcast.com...
I have a VBA script that will do that automically. I'd be glad to share
it with you. But I must warn you it is for advanced users. MS-Office Certified: http://www.microsoft.com/learning/mc...st/default.asp
"Chris Potter" <ch***********@bigpond.com> wrote in message news:65*****************@news-server.bigpond.net.au...I have a problem. I am constructing a database of eople's names and addresses for business purposes. This requires all of the people to be numbered eg: 1,2,3,4,5,6,7,8,9,10
But the problem lies here: if I have to ever alter the names, I would
have to alter the numbers, which may require slotting someone in between two people: 1,2,3,4,5,6,7,8, (new person),9,10 so the new person would become 9, 9 becomes 10, and 10 becomes 11.
Currently I am only capable of doing this renumbering manually. Is there any way of automating the renumbering process?
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Limey Drink |
last post by:
Hi all,
Firstly :-) , is there any where I can search through archived newsgroup
posts so I am not cluttering up the newsgroup with repeated queries ?
And secondly :-), I know this has...
|
by: Charles Banas |
last post by:
weird subject - i hope more than just one curious regular will hear me out.
:)
ok, i've got a bit of a big problem, and i need answers as soon as
possible.
i know this forum is meant for web...
|
by: SunshineGirl |
last post by:
I'm trying to receive events from a running instance of Internet Explorer.
So far I've only been able to receive events from an instance I launch from
code, but I need to receive events from all...
|
by: Erik |
last post by:
I need to verify the availability of a number of fax lines. This needs to be
done on an hourly basis. I have a VB.NET program that reads the numbers from
an app.config file and then stores them in...
|
by: xzzy |
last post by:
I need to automate a report in a different database (and thank yous to Terry
Kreft for pointing me in the right direction).
below is the code with the one line that does not work, marked: 'Does...
|
by: EnriqueM |
last post by:
One question: I created an access database that has been extremely
useful in my work. I dont' even know at what level of knowledge I am
at. I read a lot about how to create a database, created many...
|
by: Supa Hoopsa |
last post by:
I am in the process of rewriting an MS Access application (access front end with SQL 2k database) in VB.NET and one of the things I would like to do is link in to the compiled Access ADE so that I...
|
by: Edgar |
last post by:
Hi,
I need some advise on how to automate record selection on a stored
proc. Here is my situation. I have a stored proc that I used on
Crystal reports with two parameters - Acctcode and...
|
by: richard |
last post by:
http://safer.fmcsa.dot.gov/CompanySnapshot.aspx
From this site I hope I can obtain some basic information I need for a
website.
I have contacted them for assistance but nothing has been offered...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |