Switchboard forms where are they?

[Morpheus_UK]

I created a Main Switchboard form by mistake. Deleted it. Then I came to create my switchboards using Switchboard Manager, but none are the forms appear in my database window. Or anywhere? But I click on the Switchboard Manager and they appear there. but not in my forms object.

Any Clues?

 

[Morpheus_UK]

I had a backup so I've gone back to that. Shame lost some work, not much. Still dunno why they didn#t appear in the forms tab from the objects pane thingy.

 

[Shadowwolf]

Yeh I have the same problem with mine. The switchboard items still appears in the tables section, but I cannot see or use the switchboards. But they are there in the switchboard manager.

 

[Patho]

Must be a 2000 thing, it's happened to me as well.
Once I get my relationships sorted ( see earlier post) I was going to recreate switchboard in a new db, just a basic one. Then import the form and modify it to current db. don't know if this will fix the problem though.

 

[Rich]

Delete the original table as well and then re-create it

 

[Pat Hartman]

I don't understand the problem you are having but I can explain how the switchboard manager works. When you start the wizard, it looks to see if the [Switchboard Items] table or the [Switchboard] form already exist. If neither exists, the wizard creates them both. The form is static and unless you actually modify it will be identical from db to db. The table holds all the selections you make when working through the wizard. If both exist, the wizard opens filled with the data from the [Switchboard Items] table which you can then add to or modify. No change is ever made to the form.

If when you open the wizard one exists but not the other, you'll have a problem. I am not going to figure out what problem you are going to have, I'll just tell you how to recover. If you have the form but not the table, delete the form. If you have the table but not the form, rename the table if you want to save its data. If you don't care, then you can just delete it. Now when you open the wizard it won't see either of its objects so it will create them both. At that point you can just close the wizard. Then go to the tables tab and delete the newly generated [Switchboard Items] table and rename your old table back to the correct name. Now when you reopen the switchboard manager, you will see your original selects in the switchboard manager.

It is possible to modify the switchboard form. I frequently modify its appearance. I also change the code used to close the application. Currently the wizard generates code that closes your database but doesn't close Access. This is annoying so I just change the code so it closes both.

 

[Shadowwolf]

Well, the problem I have is that I created my switchboard and was working fine. But then I didn't need it anymore so I deleted it from the forms menu. If I go into the switchboard manager it is still there. So i thought that if I created a new switchboard it would solve this problem, but when I created this new switchboard I couldn't access it the normal way, ie from the form menu. I can still edit and do everything in the switchboard manager and the switchboard items table is still there but I cannot open the switchboard anywhere.
So I was wondering if there was any way to open the switchboard without using the forms menu.

 

[Bat17]

delete the table "Switchboard Items"

Edit, perhaps that is a bit too short an answer!
if you get rid of the table and the form you should be able to create a complete new switch board OK. Might be worth a try renaming the existing table, create a new switchboard complete with table, then try swaping the original table back in.

Peter

 

[Shadowwolf]

I've tried deleting the switchboard items table and that did nothing, it then just created a new one when I attempted to create a new switchboard.

Edit, perhaps that is a bit too short an answer!
if you get rid of the table and the form you should be able to create a complete new switch board OK. Might be worth a try renaming the existing table, create a new switchboard complete with table, then try swaping the original table back in.

I don't quite understand what you saying here

 

[Pat Hartman]

If you read my post again you'll see that I mentioned that you will have a problem if you have ONLY the table or ONLY the form. If you want to start again, get rid of them both.

 

[Bat17]

Are you saying that if you delete both the table and form and then recreate them that you get no form in the forms window, or that you get a form but when you open it you are not finding the switchboard items that you have set up in the Manager?

The forms are fairly simple and if you are not seeing what you are expecting it is more likely a problem with the table.

Can you strip a copy of the DB down to the switchboard and post it for us to have a look at?

Peter

 

[Shadowwolf]

Well when I create the switchboard the table appears with the switchboard items in but not the form. I will show a copy of the db at a later date as I do not have a copy of that at the moment, but will be getting one in a couple of days, as I am out of the office at the moment.

 

[Shadowwolf]

Sry bout the double post but I managed to get a copy of the db and then I deleted the switchboard items table again. It works now, so I don't know what i tried doing last time.

Sry for the waste of time and thanks for your help.
Shads

 

[Bat17]

Glad you got it sorted

Peter