473,387 Members | 1,532 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,387 software developers and data experts.

MS Access How to open Switchboard / Main Menu at Add-in

102 64KB
Hello Friends

I want to create and use my switchboard / Main Menu at Ribbon / Menu bar.

I have created Switchboard Items and Switchboard Form. Now I want to make it as Default menu.

All the other Access Default Menus should NOT display. Only my Switchboard / Main Menu should be display at Ribbon / Menu Bar.

I have seen at many templates which are used at Add-ins. I don't know how to do it.

Please if any one can help me how to do it step by step.
Thanks
Jan 17 '16 #1
1 2280
zmbd
5,501 Expert Mod 4TB
Which version of Office/Access?

To hide the ribbon >> BE CAREFUL HERE <<
MS>How to: Hide the Ribbon When Access Starts
In the XML that creates your primary ribbon add:
Expand|Select|Wrap|Line Numbers
  1. <customUI xmlns="http://schemas.microsoft.com/office/20xx/xx/customui">
  2.    <commands>...</commands>
  3. <ribbon startFromScratch="true">
  4.    <tabs> .... </tabs>
  5. </ribbon>
  6. <customUI>
ONCE AGAIN>>> USE CAUTION HERE
Once you wipe the built-in menus you'll need to make sure you have a way to get back.

Open your database
Ribbon>File>Options>Current Database
Navigation group
Uncheck "Display Navigation Pane"

You can do this via Maco and/or vba which I often do in the on_load event of the main form. However, this tends to be the easiest.

While you're at it,
Ribbon>File>Options>Current Database
Application Title: [enter an original name]
Display Form: [Enter the name of the form to load on start]

Now you can always use the AutoExec macro to load the form too... this is what I tend to do, In the aforementioned there is a simple splash-screen form that loads, the autoexec checks for trusted stat and if found loads the primary login form, that form handles closing the splash-screen and loading the main switch board.

Of course, keep in mind, that someone like myself can bypass all of this without so much as a blink of an eye. :)
Jan 18 '16 #2

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

Similar topics

0
by: pat.maher | last post by:
I have an application that is not an mdi but rather made up of multiple sdi forms. I am trying to keep a single set of menus and toobars that change contents depending on the form that has...
17
by: GS | last post by:
the main menu in the application seemed to disappeared all together until I click on an control and select mainmenu1 in designer. then the mainmenu1 displays where it should be but running it or...
4
by: sureshpalani | last post by:
Hi Friends, I am new to access. Just creating a simple application now. I want to open a "Main Menu" form once *.mdb is clicked so that the user need not browse for the main menu. Also, is...
8
by: Anekwe | last post by:
I have a form named Main Menu in Access. Instead of openning Access and double click that form to start a session. I would like to have that form start automatically when I double click or open...
2
by: Rainer Queck | last post by:
Hello NG, I am currently working on a addin for VS2005 to have a couple of funtions available I need. Now I would extend/improve my add in, and there I have a couple of questions: 1.)...
3
by: puneetmca | last post by:
hi....i have made a horizontal menu with some of the sub menu items using javascript and CSS...but when i open the sub menu items then the items are opened below the main menu by overlapping other...
1
by: vinayreddy | last post by:
I have a problem while opening an items in switch board in access. Like it is showing an error There was an error executing the command. So can anyone please provide me the possible solution.
3
by: Jeevan83 | last post by:
i am doing an airplain seat booking system. Here I have a main menu of chooseflight() and submenu of printmenu(). Whenever I press 'f' from printmenu's options I should return to mainmenu. But I...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.