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
24 22204 NeoPa 32,556
Expert Mod 16PB
Try the Tools / Startup panel and see what is set to start on opening the database.
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!
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)>
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)>
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"
Glad we could help!
Linq ;0)>
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! : )
NeoPa 32,556
Expert Mod 16PB
It's always good to see happy campers :)
Nice work Linq! Another very helpful answer.
Nine job also, Linq. Another notch in the olde belt, I imagine that you'll be needing a new one very soon! (LOL)!
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)> @missinglinq
Hey Linq, who is this NeoPa character, a new Kid-on-the-Block? (LOL)
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 ;)
@NeoPa
Nice to see you guys are still keeping things going nicely without me ;)
Definitely not the same! Glad to have you back.
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.
Sorry for your troubles, NeoPa, but glad you're back!
Linq ;0)> 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 :)
Its working.. thanks a lot.. :)
@missinglinq
just want to say that it's 2019 and you just saved my butt at an internship! Thank you!
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 :-)
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!
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
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 :-)
Just to say Linq is definitely still active in a number of forums and still giving out great advice
NeoPa 32,556
Expert Mod 16PB
In that case tell him I said Hi when you see him :-)
Sign in to post your reply or Sign up for a free account.
Similar topics
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...
|
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"...
|
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...
|
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...
|
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...
|
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...
|
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.
...
|
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>
...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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...
|
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)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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
| |