Completely Hiding Access

R

roy_ware

I have a lovely Access VBA application that works like a charm. However,
Access itself never completely disappears (as you can do with Excel in VBA),
and this totally confuses my users (OK, they aren't the sharpest knives in
the drawer!). It also doesn't help that the application shows a minimum of
three bars in the task bar.

All I want to show up are the navigation menu forms and requested reports!
I don't want Access to be noticeable at all. I saw a previous post that
refers to this web site: http://www.mvps.org/access/api/api0019.htm. Would
this accomplish my goal?
 
F

fredg

I have a lovely Access VBA application that works like a charm. However,
Access itself never completely disappears (as you can do with Excel in VBA),
and this totally confuses my users (OK, they aren't the sharpest knives in
the drawer!). It also doesn't help that the application shows a minimum of
three bars in the task bar.

All I want to show up are the navigation menu forms and requested reports!
I don't want Access to be noticeable at all. I saw a previous post that
refers to this web site: http://www.mvps.org/access/api/api0019.htm. Would
this accomplish my goal?
Click to expand...

Tools + StartUp
Set the name of the form in Display Form/Page to the name of whatever
form you want to show when the database opens.
Uncheck the Display Database Window check box.

Close, then open the database.
Is that what you are looking for.
For your own information, hold down the Shift key when you open the
database to show the database window again.
 
R

Rainbow01

from Rainbow01 Hong Kong

I think use AllowByPass properties to disabled the Shift Key may be better
if your application only for end-user


"fredg" 來函：
 
V

Van T. Dinh

Yes but there are other complications, especially with previewing Reports,
IIRC. Read the article carefully before deciding whether you want to go
this route. Personally, I never hid the Access Application window.

For the icons in TaskBar, uncheck the option "Show Windows in TaskBar".
Note also that if you uncheck this option and hide the Access Application
window, there will NO icon in the Taskbar for your Access database
application (another complication!).
 
R

roy_ware

This mostly accomplishes what I want. The main Access window is still
visible behind the project, but most of the options that the user can hit to
screw up the database seem to be hidden. However, can one customize the main
Access menus to eliminate some of the more dangerous choices?
 
R

Rick Brandt

roy_ware said:
This mostly accomplishes what I want. The main Access window is still
visible behind the project, but most of the options that the user can
hit to screw up the database seem to be hidden. However, can one
customize the main Access menus to eliminate some of the more
dangerous choices?
Click to expand...

The startup options allow you to disable the built in menus entirely. Whatr
"dangerous choices" are left?

Customizations that you make to built in command bars on your PC only affect
your PC, not others.
 
R

roy_ware

Once a table record is displayed in a form, the Edit menu bar enables the
"Delete Record" and "Replace" options; the Insert menu enables the "New
Record" option; the Records menu enables the "Apply Filter/Sort", "Remove
Filter/Sort" and "Save Record" options ---all things handled programmatically
that I don't want the user to try to make happen from the menu bar.

The only menu bars that have activated options with which I feel comfortable
are the File (go figure), Window and Help menus.
 
R

roy_ware

That's the next step. Would this lock down the menu options I'm worried about?
 
T

tina

no, but you can disallow default menus and toolbars in the Tools | Startup
options. you can also build your own custom menus and/or toolbars to display
in place of the standard ones.

hth
 
R

Rick Brandt

roy_ware said:
Once a table record is displayed in a form, the Edit menu bar enables
the "Delete Record" and "Replace" options; the Insert menu enables
the "New Record" option; the Records menu enables the "Apply
Filter/Sort", "Remove Filter/Sort" and "Save Record" options ---all
things handled programmatically that I don't want the user to try to
make happen from the menu bar.
Click to expand...

But if you un-check "Allow Built in Toolbars", "Allow Full Menus", and
"Allow Default Shortcut Menus" in the Startup options then none of those
should be getting displayed.
 
T

TimT

Hi all,
I'm trying to do this as well and even though I have unchecked all the boxes
in the tools/startup I still get the File|Edit|View... etc. menus and I would
like to hide them as well. How could I accomplish this?
 
T

tina

create a custom menu bar and don't put anything on it (i usually name mine
mnuBlank). then, in Tools | Startup, uncheck the menu and toolbar options,
and set the custom menu bar as the default for the database.

hth
 
Top