Switchboard form is not created

[Jody]

We are using Access 2002 and we are creating a switchboard using the
Switchboard Manager. We select the switchboard and click "Make Default".
The Switchboard Items Table is created but no form is created. The contents
of the Switchboard table are below. This worked properly in Access 2000 at
home but we are using Access 2002 at work.

Switchboard Item
ID Nbr ItemText
Cmd Arg
2 0 ECP Database MAIN MENU
0 Default
2 1 ECP Formats (DOD)
1 3
2 2 ECP Formats (BAE SYSTEMS) 1
4
2 3 RFD/RFW Formats (DOD)
1 5
2 4 Terminate Database Application
6
2 5 RFD/RFW Formats (BAE SYSTEMS) 1
6
3 0 ECP Formats (DOD)
0
3 1 Creat ECP Cover Page - DD Form 1692 3
Form_1692
3 2 Return to MAIN MENU
1 2
4 0 ECP Formats (BAE SYSTEMS)
0
4 1 Return to MAIN MENU
1 2
5 0 RFD/RFW Formats (DOD)
0
5 1 Return to MAIN MENU
1 2
6 0 RFD/RFW Formats (BAE SYSTEMS) 0

6 1 Return to MAIN MENU
1 2
7 0 Reports
0
7 1 Return to MAIN MENU
1 2

 

[Jeff Conrad]

Hi Jody,

Humm..that's odd.

Try these steps listed below from a past post of mine to
create a new Switchboard form.If you need to create a new Switchboard Form, but wish to
save the existing data in the Switchboard Items table then
follow these steps:

1. Backup your database (always a good thing).
2. Since you deleted the form go ahead and compact the
database to clear out any dust bunnies.
3. Right click on the Switchboard Items table and rename
it to "zSwitchboard Items" (no quotes though).
4. Run the Switchboard Manager Add-in again. The wizard
will say it cannot find a valid one and ask if you wish to create
a new one. Say Yes. After the first wizard form comes up
just close the wizard. You will notice that another new
Switchboard Items table and Switchboard form have been created.
5. Delete the new Switchboard Items table.
6. Rename the table "zSwitchboard Items" back to just
Switchboard Items.
7. Compact the database once again.
8. You should be back in business. Make any adjustments
to the items by running the wizard again if needed.
Does a new form get created from the above steps?

--
Jeff Conrad
Access Junkie
Bend, Oregon

We are using Access 2002 and we are creating a switchboard using the
Switchboard Manager. We select the switchboard and click "Make Default".
The Switchboard Items Table is created but no form is created. The contents
of the Switchboard table are below. This worked properly in Access 2000 at
home but we are using Access 2002 at work.

<table details snipped>

 

[Jody]

Thanks, Jeff. I have a switchboard now and it looks like the correct buttons
are on it.
Thanks again,
Jody

 

[Jeff Conrad]

You're welcome, glad to help.

 

[ANDY]

Thanks a lot Jeff. We have a major assignment due in Access and the same
thing happened. I searched and luckily found this! Thanks a ton!

 

[Jeff Conrad]

in message:

Thanks a lot Jeff. We have a major assignment due in Access and the same
thing happened. I searched and luckily found this! Thanks a ton!

You're very welcome Andy, I'm glad I could help.
Good luck with your project and welcome to the Access Collective.
;-)