Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
Tags:
  1. michael_parry2005@hotmail.co.uk

    Guest

    Hi All

    My access knowledge is not very good, but is possible to make your own
    menu through access and VBA ? (file, edit etc....) thanks for your time
     
  2. Loading...


  3. ldiaz

    ldiaz
    Expand Collapse
    Guest

    maybe this help you.


    On the Tools menu, click Startup.
    Do one or more of the following:
    To set a global menu bar, in the Menu Bar box, click the name of a custom
    menu bar from the current Access database or Access project, or click
    (default) to display the built-in menu bar.

    To set a global shortcut menu bar, in the Shortcut Menu Bar box, click the
    name of a custom shortcut menu from the current Access database or Access
    project, or click (default) to use the built-in shortcut menus.

    To prevent users from switching to the built-in menu bar from the custom
    menu bar by pressing CTRL+F11, clear the Use Access Special Keys check box.




    --
    Lorenzo Díaz
    Cad Technician


    "michael_parry2005@hotmail.co.uk" wrote:

    > Hi All
    >
    > My access knowledge is not very good, but is possible to make your own
    > menu through access and VBA ? (file, edit etc....) thanks for your time
    >
    >
     
  4. Albert D.Kallal

    Albert D.Kallal
    Expand Collapse
    Guest

    You most certainly can, and should hide all of the ms-access interface. The
    options to complete hide and keep people out of the ms-access interface can
    easily be done using the tools->start-up options. Using those options allows
    you to complete hide the ms-access interface (tool bars, database window
    etc). Also, using these options means you
    do not have to bother setting up security.

    Try downloading and running the 3rd example at my following web site that
    shows a hidden ms-access interface, and NO CODE is required to do
    this....but just some settings in the start-up.

    Check out:

    http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm

    After you try the application, you can exit, and then re-load the
    application, but hold down the shift key to by-pass the start-up options. If
    want, you can even disable the shift key by pass. I have a sample mdb file
    that will let you "set" the shift key bypass on any application you want.
    You can get this at:
    http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html


    Note that the above sample has a custom menu, and it was built using the
    "customze" option

    tools->customize


    --
    Albert D. Kallal (Access MVP)
    Edmonton, Alberta Canada
    pleaseNOOSpamKallal@msn.com
    http://www.members.shaw.ca/AlbertKallal
     
  5. michael_parry2005@hotmail.co.uk

    Guest

    Thanks very for both of your replies.
     

Share This Page