Show a Form all by itself, without any Access tools

B

BethMc

I need to show my Form on-screen for users to fill out, without giving them
access to anything else. How do I hide the Ribbon, the Navigation Pane -
preferably, hide all of Access except the form itself?
All suggestions gratefully received - I'm really new at this. Thanks in
advance!
 
A

Albert D. Kallal

The options to hide the navigation pane can be found
under the access options (office button ->access options-> current
database),

You will see the options to hide the navigation pane there....


For hiding the ribbon, the help has instructions on how to do this. You
simply build a blank custom ribbon, and specify that for the application
ribbon (again in the access options).

From the access code editor (hit ctrl-g) to bring up the code development
system, and then go help, and type in ribbon...

The 1st hit in the help will be title

How to hide the ribbon when ms-access starts..
 
B

BethMc

Thank you! Clearing the Navigation Pane was easy - don't know how I missed
that!
The USysRibbons table is an odd duck (doesn't show anywhere under the All
Objects list), and it didn't really hide the ribbon, only grayed it out - but
that serves the purpose, nobody can mess with the tools themselves. THANK
YOU!!

BethMc
 
K

Ken Warthen

Beth,

Create a new record in your USysRibbon table. In the RibbonXML field (or
whatever the field name is for your ribbon code add the following.

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="true">
</ribbon>
</customUI

Enter a name for the ribbon in the RibbonName field (or whatever the field
name is in your USysRibbon table).

In the Access options, click on Current Database. In the toolbars options
set the custom ribbon ID to the name of the ribbon you just created.

When you restart your database you should have a blank ribbon.

Ken Warthen
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top