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?

On Tue, 6 Dec 2005 17:41:03 -0800, roy_ware wrote:

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

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

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" 來函：

> On Tue, 6 Dec 2005 17:41:03 -0800, roy_ware wrote:
>
> > 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.
>
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail
>

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

--
HTH
Van T. Dinh
MVP (Access)



"roy_ware" <(E-Mail Removed)> wrote in message
news:CF8F76B5-EB7D-4E3D-995C-(E-Mail Removed)...
>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?
>
>

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?


"fredg" wrote:

> On Tue, 6 Dec 2005 17:41:03 -0800, roy_ware wrote:
>
> > 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.
>
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail
>

roy_ware wrote:
> 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.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Further to everyone else's answers, why don't you make an
mde out of your application as well?

--
Nick Coe (UK)
http://www.alphacos.co.uk/ AccHelp + pAnimal
http://www.pjandcoe.co.uk/ Online Store
http://www.mrcomputersltd.com/ Repairs Upgrades

In news:CF8F76B5-EB7D-4E3D-995C-(E-Mail Removed),
roy_ware typed:
> 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?

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.


"Rick Brandt" wrote:

> roy_ware wrote:
> > 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.
>
> --
> I don't check the Email account attached
> to this message. Send instead to...
> RBrandt at Hunter dot com
>
>
>

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

"Nick Coe (UK)" wrote:

> Further to everyone else's answers, why don't you make an
> mde out of your application as well?
>
> --
> Nick Coe (UK)
> http://www.alphacos.co.uk/ AccHelp + pAnimal
> http://www.pjandcoe.co.uk/ Online Store
> http://www.mrcomputersltd.com/ Repairs Upgrades
>
> In news:CF8F76B5-EB7D-4E3D-995C-(E-Mail Removed),
> roy_ware typed:
> > 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?
>
>
>

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" <(E-Mail Removed)> wrote in message
news:102C9E49-0FDD-4072-ADDF-(E-Mail Removed)...
> That's the next step. Would this lock down the menu options I'm worried
about?
>
> "Nick Coe (UK)" wrote:
>
> > Further to everyone else's answers, why don't you make an
> > mde out of your application as well?
> >
> > --
> > Nick Coe (UK)
> > http://www.alphacos.co.uk/ AccHelp + pAnimal
> > http://www.pjandcoe.co.uk/ Online Store
> > http://www.mrcomputersltd.com/ Repairs Upgrades
> >
> > In news:CF8F76B5-EB7D-4E3D-995C-(E-Mail Removed),
> > roy_ware typed:
> > > 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?
> >
> >
> >