switchboard command buttons

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a switchboard with the manager and I have a button that should
take me to another switchboard and it does nothing. I have done a little
with the coding before but not sure where to start with this issue. Thanks
 
I have created a switchboard with the manager and I have a button that should
take me to another switchboard and it does nothing. I have done a little
with the coding before but not sure where to start with this issue. Thanks
Click to expand...

Post the record details from the Switchboard Items tables so we can
examine them. Also provide the Access version you are using.
 
I am using Access 2003. I may be having a brain clog, but I am not sure
what record options you mean. I build the main switchboard and created a
reports switchboard. On the main switchboard is a selection that should take
you to the reports swithboard so that the reports can be ran, when this
button is clicked, it does nothing.

I have looked for the code behind the switchboard and all I find if the
coding for the form switchboard and not the switchboard buttons.

Thanks for your help
 
The wizard also created a *table* called Switchboard Items along
with the form. The table actually holds the information to be
displayed on the form. Open the table itself and you will see the
records. Post that list here like so:

SwitchboardID ItemNumber ItemText Command Argument
1 0 Main Switchboard 0 Default
etc....
 
Thanks Jeff, here is the info...

SwitchboardID ItemNumber ItemText Command Argument
5 0 Main Menu 0 Default
5 1 System Setup 7 MCR_Clear_and_update_SYS_SETUP_INFO
5 2 Employee Data Wage Entry 3 FRM_Employee_Data_Wage_Entry
5 3 Unemployment and Worker's Compensation Data
Entry 3 FRM_UE_and_WC_Reporting_Sys_Quarter
5 4 Report Processing 1 6
5 5 Exit 6
6 0 Reports 0
6 1 Mail Received 4 RPT_Mailed_Received
6 2 Unemployment and Workers Compensation Reporting 1 7
7 0 UE and WC Reporting 0
7 1 Unemployment Premium Notice 4 RPT_UE_Insurance_Premium_Notice
7 2 Unemployment Payroll Summary 4 RPT_UE_Payroll_Summary
7 3 Unemployment Premium Summary 4 RPT_UE_Premium_Summary

Thanks for your help
 
Hi Jeff, comments below...
Thanks Jeff, here is the info...

SwitchboardID ItemNumber ItemText Command Argument
5 0 Main Menu 0 Default
5 1 System Setup 7 MCR_Clear_and_update_SYS_SETUP_INFO
5 2 Employee Data Wage Entry 3 FRM_Employee_Data_Wage_Entry
5 3 Unemployment and Worker's Compensation Data
Entry 3 FRM_UE_and_WC_Reporting_Sys_Quarter
5 4 Report Processing 1 6
5 5 Exit 6
6 0 Reports 0
6 1 Mail Received 4 RPT_Mailed_Received
6 2 Unemployment and Workers Compensation Reporting 1 7
7 0 UE and WC Reporting 0
7 1 Unemployment Premium Notice 4 RPT_UE_Insurance_Premium_Notice
7 2 Unemployment Payroll Summary 4 RPT_UE_Payroll_Summary
7 3 Unemployment Premium Summary 4 RPT_UE_Premium_Summary
Click to expand...

Ok, now we are getting somewhere. Now we have something to "see."
I've examined your records and everything works on my end. I did notice,
however, that you go two levels "deep" from the main menu into the two
different report menus, but never have any options to bring you back out
to the main menu options. So once you get down to the other levels, you
are stuck there. Your main reports menu takes you to a sub-reports menu
that lists three other reports. At this bottom-most level you cannot go any
place else.

So now for the $64,000 question:
What *exactly* is your problem? What do you wish to see happen?

I guess that was two questions :-)

Describe for me in good detail (using the actual option names you see)
what you would like to see happen.

For example, something like so.
"I want to click on the Report Processing main option and be taken to the
Reports menu. On that menu I should see Mail Received, etc...."

Got it? Just tell me what you want to see happen and we'll get you fixed up.
 
You are right, I do not have any way of getting out of the two switchboards,
but i have not been able to get it to work so I have not completed it. I
want to be able to do exactly what you said, "I want to click on the Report
Processing main option and be taken to the Reports menu. On that menu I
should see Mail Received, etc...." When I click on the Report Processing
button it does nothing, it does not take you anywhere, it is like it is a
dead button. You said it works on yours, but it will not on mine, any idea
why?

Thanks
 
You are right, I do not have any way of getting out of the two switchboards,
but i have not been able to get it to work so I have not completed it. I
want to be able to do exactly what you said, "I want to click on the Report
Processing main option and be taken to the Reports menu. On that menu I
should see Mail Received, etc...." When I click on the Report Processing
button it does nothing, it does not take you anywhere, it is like it is a
dead button. You said it works on yours, but it will not on mine, any idea
why?
Click to expand...

Everything works on my end; no dead buttons.

So it is the option on the main page that is not working??
The one that says Report Processing on the main screen?

Try these steps:
1. Launch the wizard again.
2. Select Main menu from the listbox and then hit Edit.
3. Click on Report processing from the listbox and then press Delete.
4. Now we will recreate it.
5. Hit New.
6. Put these selections into the item:
Text - Report Processing
Command - Go To Switchboard
Switchboard - Reports
7. Hit Ok
8. Close out of the wizard and then try the Report Processing
button again on the main switchboard page.

Does it work now?
 
This is what is driving me crazy. It worked when i first created it and then
I reopened the database
and it suddenly stopped. I have deleted and recreated not only the button,
but
the entire switchboard. I did just as you stated and it still is not
working. Here is the new table information.

SwitchboardID ItemNumber ItemText Command Argument
5 0 Main Menu 0 Default
5 1 System Setup 7 MCR_Clear_and_update_SYS_SETUP_INFO
5 2 Employee Data Wage Entry 3 FRM_Employee_Data_Wage_Entry
5 3 Unemployment and Worker's Compensation Data
Entry 3 FRM_UE_and_WC_Reporting_Sys_Quarter
5 4 Exit 6
5 5 Report Processing 1 6
6 0 Reports 0
6 1 Mail Received 4 RPT_Mailed_Received
6 2 Unemployment and Workers Compensation Reporting 1 7
7 0 UE and WC Reporting 0
7 1 Unemployment Premium Notice 4 RPT_UE_Insurance_Premium_Notice
7 2 Unemployment Payroll Summary 4 RPT_UE_Payroll_Summary
7 3 Unemployment Premium Summary 4 RPT_UE_Premium_Summary

Could something be wrong in the references? I am at a loss, especially
since it works for you.

Thanks for your help.
Jeff
 
Hi Jeff,
This is what is driving me crazy. It worked when I first created it and then
I reopened the database and it suddenly stopped. I have deleted and
recreated not only the button, but the entire switchboard. I did just as
you stated and it still is not working. Here is the new table information.
Click to expand...

Which part exactly is not working?
SwitchboardID ItemNumber ItemText Command Argument
5 0 Main Menu 0 Default
5 1 System Setup 7 MCR_Clear_and_update_SYS_SETUP_INFO
5 2 Employee Data Wage Entry 3 FRM_Employee_Data_Wage_Entry
5 3 Unemployment and Worker's Compensation Data
Entry 3 FRM_UE_and_WC_Reporting_Sys_Quarter
5 4 Exit 6
5 5 Report Processing 1 6
6 0 Reports 0
6 1 Mail Received 4 RPT_Mailed_Received
6 2 Unemployment and Workers Compensation Reporting 1 7
7 0 UE and WC Reporting 0
7 1 Unemployment Premium Notice 4 RPT_UE_Insurance_Premium_Notice
7 2 Unemployment Payroll Summary 4 RPT_UE_Payroll_Summary
7 3 Unemployment Premium Summary 4 RPT_UE_Premium_Summary
Click to expand...

All the buttons work fine in my test database. I have no 'dead' buttons.
Which one is not working for you?
Could something be wrong in the references? I am at a loss, especially
since it works for you.
Click to expand...

Most perplexing to be sure.
I do not believe this is a References issue, but it would not hurt to check
the References dialog box to see if anything is marked as 'Missing.' What
is most odd is that everything else seems to be working fine for you.

Here are some things I would try:

1. Compact the database and then test. Problem solved?

2. Compile the database and then compact the database. Problem solved?

3. Create a new blank database and import ONLY the Switchboard Items
table and form into this new container. Now open the form and test every
button. Yes, you will get an error message for every button that needs to
open a form, run a macro, or opens a report. But what I *really* want to
know is DO you get that error for EVERY button except the ones that
take you to other menus? And do the buttons that take you to other menus
work as well or are you still seeing the same problems? If so, what problems
exactly do you see?

4. You may want to create a new blank database and import all the objects,
relationships, toolbars, and data EXCEPT the switchboard items table and
form. In this new container, re-run the wizard to create a new switchboard
table and form. Start by adding one and ONLY item to the wizard at a time.
Test each new item you add to see if it works before moving on to the next
one. If something stops working, at one point does it stop working?
Thanks for your help.
Click to expand...

Well I haven't helped much so far, but you are welcome.
 
Back
Top