Making the database window, filter by form button grayed out

[Jack]

Hi,
I need to build a application with couple of forms. However the restriction
is that the database window and the filter by form button needs to be grayed
out. I will appreciate any help on this. The idea is to have the users not
to go to the database window. I am building custom security and cannot use
the security feature of Access. Thanks.

 

[Richnep]

Hi,
I need to build a application with couple of forms. However the restriction
is that the database window and the filter by form button needs to be grayed
out. I will appreciate any help on this. The idea is to have the users not
to go to the database window. I am building custom security and cannot use
the security feature of Access. Thanks.

Hi Jack,

In our database (Access03) we have the DB open to a form called
frmMenu. You can assign startup options in TOOLS, STARTUP. We disabled
the default toolbar and made a custom toolbar. The other option is you
can choose not to show the database window. This of course (And almost
any other lockdown) can be overridden by holding the SHIFT key down as
you double click the app to open. You can disable that override but
then you will not be able to get in yourself.

 

[Richnep]

Hi Jack,

In our database (Access03) we have the DB open to a form called
frmMenu. You can assign startup options in TOOLS, STARTUP. We disabled
the default toolbar and made a custom toolbar. The other option is you
can choose not to show the database window. This of course (And almost
any other lockdown) can be overridden by holding the SHIFT key down as
you double click the app to open. You can disable that override but
then you will not be able to get in yourself.

Also in your form properties DATA tab make sure ALLOW FILTERS is set
to no. Any subforms will have to be similary set