Completely Hiding Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?

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.
 
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" 來函:
 
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!).
 
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?
 
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?

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.
 
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.
 
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
 
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.

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.
 
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?
 
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
 
Back
Top