Automate Numbers

[Guest]

I am looking for advice for the best way to solve a problem.

I am developing a system of telephony extensions etc at a
workplace, some sites may have 200+.

I am trying to automate entering all the extension numbers, rather than
manually inputting them. I also have a format for the range of extensions,
but don't know if Access will allow me to give an example and then create the
extension for me automatically in sequence.

Thanks,
Lisa W.

 

[Guest]

Sounds simple enough.. what is your format?

 

[Guest]

The format will be something like 256 0 00 00.

I hope you can help!!

THANKS SO MUCH IN ADVANCE!

Lisa W.

 

[Guest]

Also Lance, I want to give you the range for my extensions:

1st set of numbers ( up to 256)
2nd number (can be 0 or 1)
3rd set of numbers (0 to 15)
4th set of numbers (0 to 31)

**Not sure how difficult this will be, but very necessary because we have
several ranges of numbers that would have to be manually entered.**

Lisa W.

 

[Guest]

How are these numbers assigned now?
Are you trying to do something like click a button and have it assign the
next available number? Or choose a department, then click a button and have
it assign the next available number within the range defined for that
department?

 

[Guest]

Lance,

Presently the numbers are not assigned. We are trying to assign a range of
numbers to a particular branch/department. Clicking a button to show what's
available would be great.

I'm excited to find out if this is possible.

 

[Guest]

What I meant was what is the current process for assigning them. If you were
going to assign a single number by hand, what steps would you go through to
determine what number to give them?

I see you broke up the number into sections, what do each of the sections
represent? And yes, it should be possible to do this through a couple combo
boxes to select departments and then displaying a list of available numbers.

 

[Guest]

We don't have a current process because this is a new project. We want them
automated. Again I hope it's a way to give an example of the starting
extension range and the last possible extension range and have the system
create all other in between.

I'm jumping around but don't know where to begin. It doesn't matter what
numbers are assigned to the various branches/departments, it's just that we
want to keep track of the range of extensions we assign and ensure we know
what branch has that assignment.

Thanks!

 

[Guest]

By the way, the sections represent Loop, Shelf, Card and Unit respectively.

 

[Guest]

So.. extension 5000-5999 is finance. 5000-5200 is accounting, 5201-5400 is
credit, 5401-5800 is dancing bears or whatever?

Is that all you're looking for?

 

[Guest]

With accounting, credit and the ever popular dancing bears being sub-groups
of finance.. if that was clear.

 

[Guest]

OK.. not idea what those mean, and I'm not sure it matters. What does matter
is the process involved.

John Doe from Accounting needs a phone. How do you decide what values to
assign to loop, shelf, card and unit? The actual number doesn't matter..
just the decision making process.

I can help with working out the technical stuff.. but you need to define
some rules first.

 

[Guest]

Ok. Let me know what else I need to clarify.

OK.. not idea what those mean, and I'm not sure it matters. What does matter
is the process involved.

John Doe from Accounting needs a phone. How do you decide what values to
assign to loop, shelf, card and unit? The actual number doesn't matter..
just the decision making process.

I can help with working out the technical stuff.. but you need to define
some rules first.

 

[Guest]

You also had an 8 character code in your earlier example.

256 0 00 00

I could be missing something obvious.. but how does that translate to an
extention?

 

[Guest]

Lance,

The TN is what we call a terminal number that relates to an extension.
The 8-digit number is accurate.

 

[Guest]

OK. Not familiar with that.

When you get the other part figured out, we'll get on with setting a DB up
for it.

 

[Guest]

What else do you need from me to get started?

OK. Not familiar with that.

When you get the other part figured out, we'll get on with setting a DB up
for it.

 

[Guest]

"John Doe from Accounting needs a phone. How do you decide what values to
assign to loop, shelf, card and unit? The actual number doesn't matter..
just the decision making process."

 

[Guest]

We are going to go sequencially based on the range of extensions as well as
what has already been assigned. For example if we have 256 0 00 01 already
assigned, the next number will be 256 0 00 02.

 

[Guest]

So John Doe from accountings gets 256 0 00 01
Joe Blow from Marketing gets 256 0 00 02
Jerry Scarry from Warehouse gets 256 0 00 03
..
..
..
Marge Large from HR gets 256 0 00 99
Fred Dead from Transportation gets 256 0 01 00


Department doesn't matter? If so.. I was over-complicating this a lot.