Switchboard at startup

I have the startup options set to display the Switchboard at startup. Unfortunately, the switchboard doesn't display at startup on some PCs. It either works or it doesn't. If it works on a particular PC, it works every time. The converse is also true. On the PCs where it doesn't work, the menu choices at the top of the screen are also limited to File/Window/

Sponsored Links:

Related Topics

Programmatically change default switchboard at startup?
I'm a first-time poster after finding many helpful answers on this forum.

I'm looking for a way to programmatically change the Default Switchboard via vb code.

I want an autoexec macro to do a quick lookup to see which switchboard a user should get, then set that switchboard as default, then open that switchboard form.

Right now what I do is I have a separate copy of my front-end database for each different switchboard, which I think is kind of sloppy and can cause confusion. I'd much rather have justone front end that selected the correct switchboard at startup time.


Programmatically change default switchboard at startup?
I'm a first-time poster after finding many helpful answers on this forum.

I'm looking for a way to programmatically change the Default Switchboard via vb code.

My idea is, I want an autoexec macro to do a quick lookup to see which switchboard a user should get, then set that switchboard as default, then open that switchboard form.

Right now what I do is I have a separate copy of my front-end database for each different switchboard, which I think is kind of sloppy and can cause confusion. I'd much rather have just one front end that selected the correct switchboard at startup time


Question on startup priority
I read that when Access opens it first processes the startup options, THEN it will look for the AUTOEXEC macro to run.

My question is. because it processes the startup options first, and I have my switchboard form to open on startup, will code in my switchboard form's OnOpen event execute before the autoexec macro would be executed


Password protect switchboard startup bypass
I have an access 2010 database all complete with a user friendly switchboard form that open upon clicking an icon. But I don't want any users to press the SHIFT key and enter and alter any design settings. Is there anything I can do so that upon SHIFT [Enter] press, the user encounters a password request to proceed further, and cancel/wrong password to open the switchboard as a normal startup


Modifying Access 2007 Switchboard form
I have a Switchboard form which runs on startup and have chosen to 'Hide Navigation Pane fo'r the current database. I would like a 'for advanced users' button on the Switchboard form toclose the form, leaving the database open, and re-display the navigation Pane?


Access 2003 database with password and switchboard
I'm having problem with Access 2003 database which has tables, forms, reports, macros and automatic switchboard from startup as a menu where users can select the needed action they want to do.

In the beginning .mdb opened directly to the switchboard but we prefer to protect the database with password from Tools -security. So nowadays it asks password before opening the switchboard.

Now we want to set different user group levels as admin, add/change, add/read and limited read. But we cannot reset the main password at all because there is no Tools menu as the switchboard is hiding menu items.
There is only File, Edit, Insert, Records, How we can reset/remove the password?


Switchboard Error
I have a Switchboard defined with 7 rows in the Switchboard table, all generated using the Switchboard Manager. However, when I run the application, opening the Switchboard via Autoexec, I have an 8th button with no label and when I click that button the app returns a Unknown Option error.

Any ideas? I have dropped and re-created the Switchboard a couple of times, with the same result each time.

I am running Access 2007 on Windows


Switchboard OptionLabel7 problems
I recently inherited a database that seemed to be designed by an expert VB coder. After carefully picking through the code for about 2 days I realized the person had just used the Switchboard function.

I made a few small changes in the switchboard (through the switchboard wizard), and everything appeared to be fine. Except the Switchboard refuses to acknowledge OptionLabel7.

No matter what switchboard form, OptionLabel7 does not function. Changing what variables that are attached to that option doesn't help.

I assume the problem is somewhere in OptionLabel7 itself, since nothing in the Switchboard manager makes a difference. How can I troubleshoot this? All of the properties for OptionLabel7match the other 6 (functioning) options.


Switchboard Removed but still there
I have removed the switchboard form, table and the command in AutoExec as well as the startup program. However I still get a.

"The form name "Switchboard" is misspelled or refers to a form that doesn't exist. If the invalid form name is in a Macro, an action failed dialog box will display the macro name and the macro's arguments after you click ok. Open the Macro window, and enter the correct name."

I have deleted the AutoExec and recreated it to open the MainMenu_frm that I am now working with.

Any help in getting rid of this error message is greatly appreciated.


Problems with switchboard size
I used the Switchboard Manager in Access 2003 to create a switchboard. I also created a button on one of my form to exit back to the switchboard. When you return to the switchboard, it is no longer small, but expanded to the entire screen.

I've played around with it, but haven't found any obvious tweak to make it stay the same size.


Switchboard name changing in 2007
I have a switchboard that has 3 sub switchboards in an access 2007 database. The default switchboard displays the wrong name. The others do not. In switchboard manager, the correct name is displayed


Switchboard Examples
Would anyone be willing to share their switchboard designs? I don't want to use the actual switchboard manager but create a form and use it as my switchboard. I'm having a hard time getting a good start and making it look organized


Display in form view from switchboard
I am working with a pre-existing database that launches forms from a switchboard. I believe the switchboard was made via the wizard.

Some of the forms launch in datasheet view through the switchboard even though they have form views available.

I've tried adding the acNormal parameter to the form-opening part of the switchboard code, but have not been successful.


Password protecting a switchboard page that was created using the switchboard manager
Basically I have created a menu using the switchboard manager, and my question is it possible to password protect one switchboard page.

Although the manager accepts the command go to switchboard, I can not enter the same command in the code if for example I will have a form that will open the switchboard after the correct password


Opening Switchboard gives error
Using Access 2007 with mdb file. Open Access database which opens Switchboard at startup. Getting an error when opening Switchboard:
Run-time error '-2147418113(800f)': Method 'connection' of object '_Current Project' failed

Debug puts to code line:
Set con = Application.CurrentProject.Connection

Hover mouse over this line of code and get:
datasource object is already initialized

The database is on a shared drive on our network and works fine for all but 1 person.

Is there a way to make the 1 pc think the object is not initialized? Or what are other options?


Switchboard Pages
Is there a limit to the number of switchboard pages you can have? I have a database and it wont let me add more than three switchboard pages through the Switchboard manager. Is there a setting I can change


Switchboard Corrupted
I am a novice Access user who does not know anything about VBA modules etc, but I am good in databases in general.
So, I have this database at work, which got corrupted when I was out of town. Access asked if we want it to auto repair (or something of that sort). We said yes, and it recovered the database, but then when we now open the database, the switchboard opens, but its just blank.
However, if I go to the switchboard manager, I can see that there is a switchboard there and everything looks just fine.
I can also create a new switchboard, but even that one comes up as blank.

I think its due to some VBA modules which could not be recovered by Access.

However, we do have a backup from about 2 weeks back, in which the switchboard works fine.

I have tried all sorts of tricks, but I am unable to get the switchboard working.


Jumping to another switchboard
Do anyone know how can I write a VBA to open a switchboard?
I know how to jump to the default switchboard by:
DoCmd.OpenForm "Switchboard"

however, I don't know how to write VBA to open another switchboard B which is not the default switchboard


Open database and only display a switchboard
Im new to Access 2007 and am trying to create a form that opens on startup and then displays in the middle of the screen without seeing the database.


Switchboard Question
Using the switchboard wizard I created several switchboard items. For some unexplained reason, "the first switchboard" in the swichboard item list "does not work". All the other switchboard item work. I've double checked the text field, the command and the report fields and they're all ok. What am I overlooking or missing