Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Access 2003 Switchboard Form is missing

Posted on 2009-05-03
6
Medium Priority
?
949 Views
Last Modified: 2012-05-06
I created a switchboard in Access 2003.  I wasn't happy with it, so I built a new one that seems pretty nice. However,  I cannot find it in the forms that are in the database or when I set up the startup setup.  Looks to me like the form when away.  So I ran repair and compact and the form did not re-appear.

Yet, the Switchboard manager still shows and allows me to edit my new switchboard and the initial one.

How do I set up the Switchboard, get it to appear in the forms tab and set it up as a startup form?

Thank you
0
Comment
Question by:DLJ
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 31

Assisted Solution

by:hnasr
hnasr earned 500 total points
ID: 24291462
Check the data base proerties for hidden object.
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 24291577
Expanding on what hnasr said ...

Tools>>Options>>View Tab.
Be sure Hidden objects and System objects are checked ... meaning it will show these objects ... in case the Switchboard form Hidden property was accidentally checked.

mx
0
 

Accepted Solution

by:
DLJ earned 0 total points
ID: 24291645
THanks, I will try that.
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
LVL 38

Assisted Solution

by:puppydogbuddy
puppydogbuddy earned 500 total points
ID: 24291913
if you used Tools>Startup Properties to configure the application startup, make sure you set the switchboard form, or set a splash screen that loads the switchboard form as the form that opens at startup.
0
 

Author Comment

by:DLJ
ID: 24292226
I tried checking the database objects for hidden objects, repaired the database and reopened it.  Still do not see the switchboard form in the form collections.  I can modify my form, however, by using the switchboard wizard - appears to be the only way to get to the switchboard.  There remains no switchboard form in my forms collection.

Appreciate your help
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 500 total points
ID: 24312112
You really DO NOT want to mess aorund with anything that the switchboard manager creates.

If you do not like the Switchboard the wizard makes, you really can't simply delete it using the wizard.

If you make your own, DO NOT name it "SwitchBoard"

The switch board is a combination of a Form, Complex VBA code and a Table.

All threee are designed to work together.
I would highly reccommend that you NOT try to customize or modify it on your own.

Can you clarify what you mean when you say"
<I wasn't happy with it, so I built a new one >
...Built a new one "how"?, using the switchboard manager again, or did you make the form from scratch>

What did you name this new switchboard of yours?

I did exactly what you did years ago, screwed it up, just like you, and was forced to create a new database and import all of the Old Objects back in.

Make a backup first
Try running the Compact/Repair utility
Try a decompile. (http://www.granite.ab.ca/access/decompile.htm)

If that does not work, then create a new database and import in all the objects.

JeffCoachman
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

660 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question