473,320 Members | 1,987 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Retrieving Deleted Switchboard form

Hey guys,
I have accidentally deleted the switchboard of the database that I had created. The switchboard form doesn't appear when I click on the Forms section in Access. But heres the deal, when I click the Tools>Database Utilities> Switchboard Manager, the contents of the switch board show up with all the changes . It also allows me to make the changes. I would like to know is there any way to retrieve the switchboard form in the Forms Section or get to it to start on opening the database.

Thank you for the reply
Saurabh
Jul 14 '07 #1
24 22204
NeoPa
32,556 Expert Mod 16PB
Try the Tools / Startup panel and see what is set to start on opening the database.
Jul 14 '07 #2
ADezii
8,834 Expert 8TB
Hey guys,
I have accidentally deleted the switchboard of the database that I had created. The switchboard form doesn't appear when I click on the Forms section in Access. But heres the deal, when I click the Tools>Database Utilities> Switchboard Manager, the contents of the switch board show up with all the changes . It also allows me to make the changes. I would like to know is there any way to retrieve the switchboard form in the Forms Section or get to it to start on opening the database.

Thank you for the reply
Saurabh
Sorry Saurabh, I do believe that you are out of luck. What you see when you open the Switchboard Manger, and what you can make changes to, is the Switchboard Items Table which still exists even after the Switchboard Form is long gone. Sorry!
Jul 15 '07 #3
missinglinq
3,532 Expert 2GB
A question so elemental we often forget to ask is, do you have a backup copy of your database? If you do you can simply import the switchboard from the backup copy into your current copy. If not, you've learned an important lesson the hard way; always back up! For a database in active development, backing up a very minimum of daily is imperitive! More realistically, backup after you've done any major changes!

Good Luck and Welcome to TheScripts!

Linq ;0)>
Jul 15 '07 #4
missinglinq
3,532 Expert 2GB
If you haven't deleted the Switchboard Table from you db, I've figured out how to reconnect it to a switchboard.

Open up a new, blank db.
Create a Switchboard.
Exit this db.
Open your original database.
Goto File - External Data - Import
Import the Switchboard Form (do not import Switchboard Items Table)

You should be set. You'll have to redo any appearance formatting you've done to the Switchboard, but your functionality will be there!

Linq ;0)>
Jul 15 '07 #5
hey all,

Thank you guys for your help. I will surely keep in mind about the golden rule of Back up. Thank you Linq. Import thing really worked. Thanks for your help. Its helped a lot. Nice getting questions answered on "The Scripts"
Jul 16 '07 #6
missinglinq
3,532 Expert 2GB
Glad we could help!

Linq ;0)>
Jul 16 '07 #7
Linq,

THANK YOU, THANK YOU, THANK YOU!!!!! I didn't know you could delete the one and only one switchboard form - YIKES! This saved my hide! : )
Jul 31 '09 #8
NeoPa
32,556 Expert Mod 16PB
It's always good to see happy campers :)

Nice work Linq! Another very helpful answer.
Aug 3 '09 #9
ADezii
8,834 Expert 8TB
Nine job also, Linq. Another notch in the olde belt, I imagine that you'll be needing a new one very soon! (LOL)!
Aug 3 '09 #10
missinglinq
3,532 Expert 2GB
Multiple notches plus expanding waistline does require a new belt, from time to time! Seriously, it is nice to get feed back when someone benefits from a two year old post like this!

Linq ;0)>
Aug 3 '09 #11
ADezii
8,834 Expert 8TB
@missinglinq
Hey Linq, who is this NeoPa character, a new Kid-on-the-Block? (LOL)
Aug 3 '09 #12
NeoPa
32,556 Expert Mod 16PB
@ADezii
I'm away injured for 5 short weeks and this is what I get huh?

Nice to see you guys are still keeping things going nicely without me ;)
Aug 3 '09 #13
ADezii
8,834 Expert 8TB
@NeoPa
Nice to see you guys are still keeping things going nicely without me ;)
Definitely not the same! Glad to have you back.
Aug 3 '09 #14
NeoPa
32,556 Expert Mod 16PB
@ADezii
Thanks ADezii.

I'm a way from being fully fit, but I'll get on as much as I can.
Aug 3 '09 #15
missinglinq
3,532 Expert 2GB
Sorry for your troubles, NeoPa, but glad you're back!

Linq ;0)>
Aug 4 '09 #16
NeoPa
32,556 Expert Mod 16PB
Thanks Linq. I only feel half back (if that) at the moment, but looking forward to fuller involvement again :)
Aug 4 '09 #17
Its working.. thanks a lot.. :)
Dec 15 '13 #18
@missinglinq
just want to say that it's 2019 and you just saved my butt at an internship! Thank you!
Jun 12 '19 #19
NeoPa
32,556 Expert Mod 16PB
Good to hear some of these old threads are still providing the help they're there for. Thanks for posting :-)
Jun 12 '19 #20
twinnyfo
3,653 Expert Mod 2GB
Glad this post hepped someone recently, also, as now I have a little trick in case I come across something like this. Sometimes, the simple tricks are the best.

Great little tidbit, Linq!
Jun 13 '19 #21
Dear Linq,
you are a lifesaver!!!!!
I will forever be grateful for this!!!!
you just saved months of work!!!!
Thank you for being awesome and smart!!!
ILY
Apr 1 '21 #22
NeoPa
32,556 Expert Mod 16PB
Well, I have to say we haven't seen him around here since way back at the start of the last decade, so he may not see this. Nevertheless, we always appreciate being told that we, or one of our colleagues, has been of help even nearly fourteen years later.

Long may these old threads continue to help anyone who needs it :-)
Apr 1 '21 #23
isladogs
455 Expert Mod 256MB
Just to say Linq is definitely still active in a number of forums and still giving out great advice
Apr 1 '21 #24
NeoPa
32,556 Expert Mod 16PB
In that case tell him I said Hi when you see him :-)
Apr 2 '21 #25

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: steve | last post by:
I have a comments form that when filled in posts the comments from a text field into a database. Due to a bit of duff coding (Doh!) the database was not getting updated and i lost 50 or so posts...
2
by: Doug Partridge | last post by:
Does anyone see what is wrong with the below code? File Test1.ASP <HTML> <Form action="test2.asp" method="post" ID="frm1"> <input type = "text" ID="txtname"> <Input type="submit" id="submit"...
1
by: jimwlee | last post by:
Hi all, I mistakenly deleted my switchboard on the Object Forms view. I recreated it again with the database utility, but the switchboard isn't showing up in the forms view. Any ideas? Thanks in...
2
by: Spook | last post by:
Some of the forms set up within the switchboard do not work if the form isn't maximed, scroll bars don't appear properly. So that the users of the database don't have that problem is there a...
5
by: joebin | last post by:
I accidentally deleted the switchboard item in form list. Anyone know where I can get my switchboard back? The Switchboard Items in table list is still there. I can also view all the switchboard...
3
by: Haas C | last post by:
Hey all, Thi question may be simple to most people on this group, but I'm a newbie and can't figure this out. I have created a switchboard form and I've been able to display it on startup of...
2
by: 4Ankit | last post by:
hello all, i am having some difficulty retrieving information from my form. I want to add content in my table but the content i want to add to the table is what the user inputs in my form. ...
1
by: Chris L. | last post by:
Hi, I'm trying to set up a generic mechanism that would allow the following: 1: Run <this_procedure> 2: After that, run <this_review_procedure> 3: If it returns non-zero, open <this_form> ...
12
by: Terryvanduzee | last post by:
Hello I have a form where i have a checkbox. When the checkbox is clicked, it checks to see if the value is true (checked). If it is, it takes the current record in the form, prompts for some...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.