Auto populate field with 100 different number range

E

emerlita

I wan to be able to auto populate my subform(datasheet) with the data
below whicj is more than 100 number ranges...
1-24
25-48
49-72
73-96
97-120
121-144
and so on.

How do i do this?
 
J

Jeff Boyce

You have described HOW ("...populate ...with ... more than 100 number
ranges"), but left out the WHAT or WHY.

If you'll describe what you plan to do with the data, the newsgroup readers
may be able to offer alternate approaches.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
E

emerlita

You have described HOW ("...populate ...with ... more than 100 number
ranges"), but left out the WHAT or WHY.

If you'll describe what you plan to do with the data, the newsgroup readers
may be able to offer alternate approaches.

Regards

Jeff Boyce
Microsoft Office/Access MVP







- Show quoted text -
Click to expand...

I want to be able to choose from a combo box (it is a switch for this
example) and then will autofill this subform (stated above) with the
possible ranges under this switch. Right now if there is only up to 20
choices, i can just easily type it in the combo box but this case has
hundreds. Maybe i can just create a table just for this one and do a
lookup?
 
J

Jeff Boyce

I'm still getting a sense of HOW you've chosen to do this.

I'm not asking out of curiosity, but rather, having a fuller understanding
of the underlying business purpose or need can help clarify what needs to
happen. The way you've chosen to do something (still unclear) may not be
the "best" way, or even a "good" way.

Why do you need pre-filled ranges? What will you or your users be selecting
one of them for (i.e., for what purpose)?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
E

emerlita

I'm still getting a sense of HOW you've chosen to do this.

I'm not asking out of curiosity, but rather, having a fuller understanding
of the underlying business purpose or need can help clarify what needs to
happen. The way you've chosen to do something (still unclear) may not be
the "best" way, or even a "good" way.

Why do you need pre-filled ranges? What will you or your users be selecting
one of them for (i.e., for what purpose)?

Regards

Jeff Boyce
Microsoft Office/Access MVP







- Show quoted text -
Click to expand...

normally when we(user) create a switch, the switch should
automatically have upto 4095 TCICs (one of the fields in this table)
assigned to it. But this TCIC is divided into ranges of 24 (24 TCICs
per DS1). Doing this manually per switch will take time and maybe
mistakes.

Hope this makes more sense, let me know :)
 
J

Jeff Boyce

So, you've said that a "switch" may have up to 4095 TCICs. What determines
how many?

You've said TCIC is a field in a table. What kind of data is stored in that
field? A number? If so, what does that number represent? A count of
something? A code number? ...?

You said a TCIC is divided into ranges of 24 TCICs ...?! How can a TCIC be
both the container AND the contents? There are ranges of TCICs in each of
24 TCICs?

And you mention 24 TCICs per DS1. What's a DS1? Are there DS2's?

I'm having trouble visualizing the entities and relationships that make up
your domain.

More info, please!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
E

emerlita

So, you've said that a "switch" may have up to 4095 TCICs. What determines
how many?

You've said TCIC is afieldin a table. What kind of data is stored in thatfield? Anumber? If so, what does thatnumberrepresent? A count of
something? A codenumber? ...?

You said a TCIC is divided into ranges of 24 TCICs ...?! How can a TCIC be
both the container AND the contents? There are ranges of TCICs in each of
24 TCICs?

And you mention 24 TCICs per DS1. What's a DS1? Are there DS2's?

I'm having trouble visualizing the entities and relationships that make up
your domain.

More info, please!

Regards

Jeff Boyce
Microsoft Office/Access MVP





- Show quoted text -
Click to expand...

OK. I have a table called TCIC with 2 fields (switch & TCIC). This is
the table where we reserve TCICs or you can say number of DS0s in a
switch.
When we reserve a TCIC, we reserve a range...say 1-24, 25-40 and so
on, really depends on how many DS0s a user want to reserve.
Right now i still don't know if i should have my TCIC field be divided
into 2 or not. Should i have it one field where user will enter "1-24"
or two fields (start & end TCIC)?
Anyways, You've asked "How can a TCIC be both the container AND the
contents? This is the other dilemma i'm having. For this, i was
thinking of having a table populated at the back and when i create a
switch to populate that table with numbers from 1 to 4095.
Hope this makes sense :)
 
Top