Re: New twist on preventing closure by clicking the 'X'
- From: "Scott McDaniel" <scott@xxxxxxxxxxxxxxx>
- Date: Fri, 15 Jun 2007 06:15:23 -0400
"Todd K." <todd.kirby-delete-@xxxxxx> wrote in message news:2B575363-77EC-4F30-85C8-923274032EC6@xxxxxxxxxxxxxxxx
The setting works great, when the 'X' is clicked you can't see anything. Now
how do I see it when I need to make changes? I tried the <Shift> key open,
but I still can't see the forms.
You'd need to re-enable the "See Database Window" option, then close and re-open the database, or re-enable the shift key bypass and then close and re-open the database with the shift key held down.
"Scott McDaniel" wrote:
"Todd K." <todd.kirby-delete-@xxxxxx> wrote in message
news:D5280FCB-0030-4855-B3CE-208C9C8B9820@xxxxxxxxxxxxxxxx
>I don't mind users closing Access by using the big red 'X', but I don't
>want
> them to be able to close individual forms by using the little black > 'X'.
> I
> once saw a database where if you clicked that 'X' on any form, the > whole
> database closed down. The only way to get to the 'guts' of the > database
> was
> to hold down the <Shift> key while opening, how do I get mine to do > that?
You can do this by setting various Startup options (Tools - Startup) ... for
example, you'd uncheck the Show Database Window option to NOT show the
forms/reports etc listing. Of course, you must then provide a menuing system
for your users for them to navigate through your app.
Only way I know to cause the db to shut down when a form is closed is to
issue a DoCmd.Quit or similar command in the form's Close event (or other
similar event). Also, you can provide code in the form's Close event to take
the user where you want ... for example, if you have a main Menu form, then
perhaps you could throw the user to the Main Menu when they close certain
forms ...
.
- Prev by Date: Re: I'm glad I asked
- Next by Date: Re: Prevent Linking to Access Tables with (or without) the Security of a Workgroup
- Previous by thread: Re: Linking to Access from SQL Server (linked server)
- Next by thread: Re: Unlock database
- Index(es):
Relevant Pages
|
