Improve company productivity with a Business Account.Sign Up

x
?
Solved

Access 2003 Switchboard Form is missing

Posted on 2009-05-03
6
Medium Priority
?
966 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
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 Access MVP)
DatabaseMX (Joe Anderson - Microsoft Access MVP) 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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
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

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
If you need to implement application level security in an Access database application or other VBA code, I strongly encourage you to take advantage of Active Directory groups.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

580 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