A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Switchboard items



 
 
Thread Tools Display Modes
  #1  
Old January 14th, 2009, 04:43 PM posted to microsoft.public.access.tablesdbdesign
Mani
external usenet poster
 
Posts: 54
Default Switchboard items

Ok.. hopefully my question makes sense, but here it goes. I've added a new
item (Student Services) on the main switchboard and when I click on the it
gives me three items (Jane, Joe, and Bob's name). Now when I click on each
of the name, I want it to give me items (school names) for each person (Jane,
Joe, and Bob). But it's not letting me do it. once I get to the names, then
i won't let me creat new items, so I have to give commands for each name,
which I do not want to yet. I want to execute the command after creat new
items (schools). Is there a way I can do that?? Please HELP me!! :-(
  #2  
Old January 27th, 2009, 02:34 PM posted to microsoft.public.access.tablesdbdesign
Mani
external usenet poster
 
Posts: 54
Default Switchboard items

How no one is helping me out? I've been waiting for an answer for about two
weeks now.

"Mani" wrote:

Ok.. hopefully my question makes sense, but here it goes. I've added a new
item (Student Services) on the main switchboard and when I click on the it
gives me three items (Jane, Joe, and Bob's name). Now when I click on each
of the name, I want it to give me items (school names) for each person (Jane,
Joe, and Bob). But it's not letting me do it. once I get to the names, then
i won't let me creat new items, so I have to give commands for each name,
which I do not want to yet. I want to execute the command after creat new
items (schools). Is there a way I can do that?? Please HELP me!! :-(

  #3  
Old February 1st, 2009, 04:18 PM posted to microsoft.public.access.tablesdbdesign
Larry Daugherty
external usenet poster
 
Posts: 1,012
Default Switchboard items

You're much too patient! During the week waiting a day would be
reasonable. Most posts get a response in minutes or hours. Be a
little more patient if your post is late Friday or over the week end.

As given, your question doesn't make sense to me.

For starters, what version of Access are you using?

The Switchboard Manager doesn't offer very many actions. There are
none that implicitly lead to the presentation of results from or on a
switchboard. Usually you'd open another Switchboard or a Form or
Report, etc. from a command button on a Switchboard.

Please respond with the name of the Switchboard and the name or label
of each item on it and the desired action; open another switchboard,
open a Form, open a Report, ??

If, by chance, you opened the table "SwitchboardItems" and entered
data directly into it, that's probably the source of your problem.

If you're creating your own switchboards from scratch then they have
to be addressed simply as Forms with command buttons.

HTH
--
-Larry-
--

"Mani" wrote in message
...
Ok.. hopefully my question makes sense, but here it goes. I've

added a new
item (Student Services) on the main switchboard and when I click on

the it
gives me three items (Jane, Joe, and Bob's name). Now when I click

on each
of the name, I want it to give me items (school names) for each

person (Jane,
Joe, and Bob). But it's not letting me do it. once I get to the

names, then
i won't let me creat new items, so I have to give commands for each

name,
which I do not want to yet. I want to execute the command after

creat new
items (schools). Is there a way I can do that?? Please HELP me!!

:-(


  #4  
Old February 2nd, 2009, 04:37 PM posted to microsoft.public.access.tablesdbdesign
Mani
external usenet poster
 
Posts: 54
Default Switchboard items

Ok. For example.. let's say I have a main switchboard with 8 items and on
one of the items (Counselor switchboard), I want the Counselor switchboard to
give me the names of the Counselors (for example Jane, Joe, Bob, and Jill).
So when I select the names I want i the school names for each counselor. so
if i were to diagram it, it would go as follows... Main Switchboard (which
has the Counselor switchboard)------- then I click on the Counselor
switchboard------- then I have Jane, Joe, Bob, and Jill------- then I click
on one of the names------ then I have the School Names option (ex. South,
East, West). Please help!

"Larry Daugherty" wrote:

You're much too patient! During the week waiting a day would be
reasonable. Most posts get a response in minutes or hours. Be a
little more patient if your post is late Friday or over the week end.

As given, your question doesn't make sense to me.

For starters, what version of Access are you using?

The Switchboard Manager doesn't offer very many actions. There are
none that implicitly lead to the presentation of results from or on a
switchboard. Usually you'd open another Switchboard or a Form or
Report, etc. from a command button on a Switchboard.

Please respond with the name of the Switchboard and the name or label
of each item on it and the desired action; open another switchboard,
open a Form, open a Report, ??

If, by chance, you opened the table "SwitchboardItems" and entered
data directly into it, that's probably the source of your problem.

If you're creating your own switchboards from scratch then they have
to be addressed simply as Forms with command buttons.

HTH
--
-Larry-
--

"Mani" wrote in message
...
Ok.. hopefully my question makes sense, but here it goes. I've

added a new
item (Student Services) on the main switchboard and when I click on

the it
gives me three items (Jane, Joe, and Bob's name). Now when I click

on each
of the name, I want it to give me items (school names) for each

person (Jane,
Joe, and Bob). But it's not letting me do it. once I get to the

names, then
i won't let me creat new items, so I have to give commands for each

name,
which I do not want to yet. I want to execute the command after

creat new
items (schools). Is there a way I can do that?? Please HELP me!!

:-(



  #5  
Old February 14th, 2009, 10:34 PM posted to microsoft.public.access.tablesdbdesign
Larry Daugherty
external usenet poster
 
Posts: 1,012
Default Switchboard items

I've been away for a while.

To achieve your desired outcome you should not be trying to use the
switchboard manager down to the lowest level. Instead, have the
command on the Main Switchboard open a Form that will allow you to
select the counselor and schools. frmCounselorSchools should allow
you to pick a counselor from either a combobox or a listbox. Using
the appropriate event for the type of control you choose, either show
the appropriate schools in a subform on frmCounselorSchools or open an
entirely different Form or Report showing just the selected counselor
and the appropriate list of schools.

There is a huge flaw in what you were trying to do. "Hard wiring"
individual names in command buttons means that you are creating an
application that will require maintenance with every change of
personnel. Using the paradigm suggested above will only require
changing the record in the table that lists the counselors.

HTH
--
-Larry-
--

"Mani" wrote in message
...
Ok. For example.. let's say I have a main switchboard with 8 items

and on
one of the items (Counselor switchboard), I want the Counselor

switchboard to
give me the names of the Counselors (for example Jane, Joe, Bob, and

Jill).
So when I select the names I want i the school names for each

counselor. so
if i were to diagram it, it would go as follows... Main

Switchboard (which
has the Counselor switchboard)------- then I click on the Counselor
switchboard------- then I have Jane, Joe, Bob, and Jill-------

then I click
on one of the names------ then I have the School Names option (ex.

South,
East, West). Please help!

"Larry Daugherty" wrote:

You're much too patient! During the week waiting a day would be
reasonable. Most posts get a response in minutes or hours. Be a
little more patient if your post is late Friday or over the week

end.

As given, your question doesn't make sense to me.

For starters, what version of Access are you using?

The Switchboard Manager doesn't offer very many actions. There

are
none that implicitly lead to the presentation of results from or

on a
switchboard. Usually you'd open another Switchboard or a Form or
Report, etc. from a command button on a Switchboard.

Please respond with the name of the Switchboard and the name or

label
of each item on it and the desired action; open another

switchboard,
open a Form, open a Report, ??

If, by chance, you opened the table "SwitchboardItems" and entered
data directly into it, that's probably the source of your problem.

If you're creating your own switchboards from scratch then they

have
to be addressed simply as Forms with command buttons.

HTH
--
-Larry-
--

"Mani" wrote in message
...
Ok.. hopefully my question makes sense, but here it goes. I've

added a new
item (Student Services) on the main switchboard and when I

click on
the it
gives me three items (Jane, Joe, and Bob's name). Now when I

click
on each
of the name, I want it to give me items (school names) for each

person (Jane,
Joe, and Bob). But it's not letting me do it. once I get to

the
names, then
i won't let me creat new items, so I have to give commands for

each
name,
which I do not want to yet. I want to execute the command after

creat new
items (schools). Is there a way I can do that?? Please HELP

me!!
:-(





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:41 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.