How to make the right corner closing cross invisible

[Simon van Beek]

Dear reader,

By opening an application I get always the main Access window with the
closing cross [x] in the above right corner. Is there a possibility to make
this closing cross invisible?

All the settings in the Start-up form under Tools are disabled but the
closing cross in the above right corner is still visible.

Thanks for any help.

Kind regards,

Simon

[Tom van Stiphout]

On Tue, 26 Aug 2008 00:13:06 +0200, "Simon van Beek"
<Sv********@Versatel.nlwrote:

That's not impossible, but not easy either. What are you trying to
accomplish? That users can't close your app? There are other ways to
do that (e.g. see Cancel argument of Form_Unload). Remember some of
them will use Task Manager to nuke your app if you go down that way.
You can intercept that as well, but at an even higher cost.

So what are you really trying to accomplish?

-Tom.
Microsoft Access MVP

>Dear reader,

By opening an application I get always the main Access window with the
closing cross [x] in the above right corner. Is there a possibility to make
this closing cross invisible?

All the settings in the Start-up form under Tools are disabled but the
closing cross in the above right corner is still visible.

Thanks for any help.

Kind regards,

Simon

[Simon van Beek]

Tom,

I try to accomplish that users can't close the application with this button
[x] but
they have to close the application via a form.

-Simon
"Tom van Stiphout" <no*************@cox.netwrote in message
news:dv********************************@4ax.com...

On Tue, 26 Aug 2008 00:13:06 +0200, "Simon van Beek"
<Sv********@Versatel.nlwrote:

That's not impossible, but not easy either. What are you trying to
accomplish? That users can't close your app? There are other ways to
do that (e.g. see Cancel argument of Form_Unload). Remember some of
them will use Task Manager to nuke your app if you go down that way.
You can intercept that as well, but at an even higher cost.

So what are you really trying to accomplish?

-Tom.
Microsoft Access MVP

>>Dear reader,

By opening an application I get always the main Access window with the
closing cross [x] in the above right corner. Is there a possibility to
make
this closing cross invisible?

All the settings in the Start-up form under Tools are disabled but the
closing cross in the above right corner is still visible.

Thanks for any help.

Kind regards,

Simon

[Phil Stanton]

I hace a form ( Very Very old switchboard form probably from Access 2.)

This is always sitting behind anything else that is open. Briefly it has a
text box "CloseOK" which is either set to 1 0r 0 and a command button
"CloseDB" I hide the CloseOK Text box by making the border transparent and
the font colour the same as the background ans sometimes lock the control

CloseOK is set to 0 on opening the form

Then there is this bit of code which stops the form and consequently the Db
from closing

Private Sub Form_Unload(Cancel As Integer)

If CloseOK = 0 Then ' Must keep the switcboard open
DoCmd.CancelEvent
End If
End Sub

On pressing the CloseDB button we have

Sub CloseDB_Click
CloseOK = 1 ' OK to close database
RunCommand acCmdExit
Exit Sub

In practice I have all sorts or routines that check whether I am using an
MDB file (for developement purposes) where I can still access the CloseOK
control and an MDE file where it is not accessible .... but there I agree
with Tom , it does get complicated

HTH

Phil

"Simon van Beek" <Sv********@Versatel.nlwrote in message
news:48***********************@news.tele2.nl...

Tom,

I try to accomplish that users can't close the application with this
button [x] but
they have to close the application via a form.

-Simon
"Tom van Stiphout" <no*************@cox.netwrote in message
news:dv********************************@4ax.com...

>On Tue, 26 Aug 2008 00:13:06 +0200, "Simon van Beek"
<Sv********@Versatel.nlwrote:

That's not impossible, but not easy either. What are you trying to
accomplish? That users can't close your app? There are other ways to
do that (e.g. see Cancel argument of Form_Unload). Remember some of
them will use Task Manager to nuke your app if you go down that way.
You can intercept that as well, but at an even higher cost.

So what are you really trying to accomplish?

-Tom.
Microsoft Access MVP

>>>Dear reader,

By opening an application I get always the main Access window with the
closing cross [x] in the above right corner. Is there a possibility to
make
this closing cross invisible?

All the settings in the Start-up form under Tools are disabled but the
closing cross in the above right corner is still visible.

Thanks for any help.

Kind regards,

Simon

[Keith Wilby]

"Simon van Beek" <Sv********@Versatel.nlwrote in message
news:48***********************@news.tele2.nl...

Tom,

I try to accomplish that users can't close the application with this
button [x] but
they have to close the application via a form.

Is this because you want an event to run when the form closes? The easist
way to force this to happen is the hide the database window using the
Tools/Startup options. Also, check out the "popup" and "modal" form
properties.

Regards,
Keith.

[lyle fairfield]

I wonder why MS put that silly close button there anyway.
Why would we want a GUI common to all our applications?
Some developers envision their own GUI that is so superior to the
Windows standard that its implementation makes sacrificing uniformity
quite worthwhile.

What I can't understand is why there is an inverse relationship
between the competence of the poster and this design brilliance. How
can one be sufficiently creative to generate these new design ideas
without actually knowing anything about how the old is effected, or
how the new might be implemented? This is where I fail. Having
struggled with the Windows API extensively for ten or twelve years, I
can pretty much do whatever I want with the GUI but I never feel
motivated to do so. I have this quaint notion that if Sharon can close
a Word document by clicking a red X in its upper right hand corner, it
make sense for Sharon to be able to close Access applications and
forms by clicking red X's in their upper right hand corner.

I suppose a very few might have painted-themselves-into-a-corner
through idiotic design and extraordinarily foolish coding. But you
only see that in 95% of the posts here.

Well ... 99.44% max!

On Aug 26, 1:05*am, "Simon van Beek" <[e-mail]:

Tom,

I try to accomplish that users can't close the application with this button
[x] but
they have to close the application via a form.

-Simon
"Tom van Stiphout" <[e-mail] in messagenews:dv********************************@4ax .com...

On Tue, 26 Aug 2008 00:13:06 +0200, "Simon van Beek"
<[e-mail]:

That's not impossible, but not easy either. What are you trying to
accomplish? That users can't close your app? There are other ways to
do that (e.g. see Cancel argument of Form_Unload). Remember some of
them will use Task Manager to nuke your app if you go down that way.
You can intercept that as well, but at an even higher cost.

So what are you really trying to accomplish?

-Tom.
Microsoft Access MVP

>Dear reader,

>By opening an application I get always the main Access window with the
closing cross [x] in the above right corner. Is there a possibility to
make
this closing cross invisible?

>All the settings in the Start-up form under Tools are disabled but the
closing cross in the above right corner is still visible.

>Thanks for any help.

>Kind regards,

>Simon

[Simon van Beek]

Dear all,

In the form Tools/Startup….. I can’t find a tick box to make the Windows
window invisible.

And now I am look for code how to make the Windows window invisible so the
user can only close the application via a form.

-Simon

"Keith Wilby" <he**@there.comwrote in message
news:48**********@glkas0286.greenlnk.net...

"Simon van Beek" <Sv********@Versatel.nlwrote in message
news:48***********************@news.tele2.nl...

>Tom,

I try to accomplish that users can't close the application with this
button [x] but
they have to close the application via a form.

Is this because you want an event to run when the form closes? The easist
way to force this to happen is the hide the database window using the
Tools/Startup options. Also, check out the "popup" and "modal" form
properties.

Regards,
Keith.

[Tom van Stiphout]

On Tue, 26 Aug 2008 07:05:31 +0200, "Simon van Beek"
<Sv********@Versatel.nlwrote:

Hi Simon,
I would phrase it a bit more elegantly than Lyle, but I do feel he is
right on the substance. It is REALLY unusual to require this sort of
functionality; there usually is a MUCH better and more compatible
alternative.
I hope you won't be offended and will take the criticism to heart.
Perhaps you will post a new message that starts with: "I want to do
ABC and the best way I can think of doing that is to diable the Close
Application button. Can you suggest better alternatives?"

-Tom.
Microsoft Access MVP

>Tom,

I try to accomplish that users can't close the application with this button
[x] but
they have to close the application via a form.

-Simon
"Tom van Stiphout" <no*************@cox.netwrote in message
news:dv********************************@4ax.com.. .

>On Tue, 26 Aug 2008 00:13:06 +0200, "Simon van Beek"
<Sv********@Versatel.nlwrote:

That's not impossible, but not easy either. What are you trying to
accomplish? That users can't close your app? There are other ways to
do that (e.g. see Cancel argument of Form_Unload). Remember some of
them will use Task Manager to nuke your app if you go down that way.
You can intercept that as well, but at an even higher cost.

So what are you really trying to accomplish?

-Tom.
Microsoft Access MVP

>>>Dear reader,

By opening an application I get always the main Access window with the
closing cross [x] in the above right corner. Is there a possibility to
make
this closing cross invisible?

All the settings in the Start-up form under Tools are disabled but the
closing cross in the above right corner is still visible.

Thanks for any help.

Kind regards,

Simon

[Simon van Beek]

Tom,

The only what I can say now is Lyle is a little bit frustrated and he needs
professional help and we are not able to help him.

Kind regards,

Simon

"Tom van Stiphout" <no*************@cox.netwrote in message
news:6l********************************@4ax.com...

On Tue, 26 Aug 2008 07:05:31 +0200, "Simon van Beek"
<Sv********@Versatel.nlwrote:

Hi Simon,
I would phrase it a bit more elegantly than Lyle, but I do feel he is
right on the substance. It is REALLY unusual to require this sort of
functionality; there usually is a MUCH better and more compatible
alternative.
I hope you won't be offended and will take the criticism to heart.
Perhaps you will post a new message that starts with: "I want to do
ABC and the best way I can think of doing that is to diable the Close
Application button. Can you suggest better alternatives?"

-Tom.
Microsoft Access MVP

>>Tom,

I try to accomplish that users can't close the application with this
button
[x] but
they have to close the application via a form.

-Simon
"Tom van Stiphout" <no*************@cox.netwrote in message
news:dv********************************@4ax.com. ..

>>On Tue, 26 Aug 2008 00:13:06 +0200, "Simon van Beek"
<Sv********@Versatel.nlwrote:

That's not impossible, but not easy either. What are you trying to
accomplish? That users can't close your app? There are other ways to
do that (e.g. see Cancel argument of Form_Unload). Remember some of
them will use Task Manager to nuke your app if you go down that way.
You can intercept that as well, but at an even higher cost.

So what are you really trying to accomplish?

-Tom.
Microsoft Access MVP
Dear reader,

By opening an application I get always the main Access window with the
closing cross [x] in the above right corner. Is there a possibility to
make
this closing cross invisible?

All the settings in the Start-up form under Tools are disabled but the
closing cross in the above right corner is still visible.

Thanks for any help.

Kind regards,

Simon

[lyle fairfield]

Speaking of "professional" help someone wrote EnableTitleBarControls
and DisableTitleBarControls procedures and published them in CDMA back
in the previous century.
http://groups.google.com/group/comp....a49834e9e666a1

Oh, what a dilemma this is! He wrote EnableCloseButton and
DisableCloseButton procedures too.
http://groups.google.com/group/comp....49d160dcdcb973

Who could it have been?

They're not exactly what you want as they act on the Access window
instead of a form but they could easily be modified by anyone who
wasn't bone-dead lazy and bucket-of-rocks stupid, to meet your
request. I guess that explains why I didn't suggest them earlier.

Did I mention that the procedure writer said in the same thread, "I
have no idea why anyone Would_Want to do this. (I'm assuming there
must be some way to close, so why not let Access do it in what appears
to be a safe way)"? Right now in 2008 the bucket-of-rocks stupid
hypothesis seems promising.

On Aug 27, 1:48*am, "Simon van Beek" <[e-mail]:

Tom,

The only what I can say now is Lyle is a little bit frustrated and he needs
professional help and we are not able to help him.

Kind regards,

Simon

"Tom van Stiphout" <[e-mail] in messagenews:6l********************************@4ax .com...

On Tue, 26 Aug 2008 07:05:31 +0200, "Simon van Beek"
<[e-mail]:

Hi Simon,
I would phrase it a bit more elegantly than Lyle, but I do feel he is
right on the substance. It is REALLY unusual to require this sort of
functionality; there usually is a MUCH better and more compatible
alternative.
I hope you won't be offended and will take the criticism to heart.
Perhaps you will post a new message that starts with: "I want to do
ABC and the best way I can think of doing that is to diable the Close
Application button. Can you suggest better alternatives?"

-Tom.
Microsoft Access MVP

>Tom,

>I try to accomplish that users can't close the application with this
button
[x] but
they have to close the application via a form.

>-Simon
"Tom van Stiphout" <[e-mail] in message
news:dv********************************@4ax.com.. .
On Tue, 26 Aug 2008 00:13:06 +0200, "Simon van Beek"
<[e-mail]:

>That's not impossible, but not easy either. What are you trying to
accomplish? That users can't close your app? There are other ways to
do that (e.g. see Cancel argument of Form_Unload). Remember some of
them will use Task Manager to nuke your app if you go down that way.
You can intercept that as well, but at an even higher cost.

>So what are you really trying to accomplish?

>-Tom.
Microsoft Access MVP

>>>Dear reader,

>>>By opening an application I get always the main Access window with the
closing cross [x] in the above right corner. Is there a possibility to
make
this closing cross invisible?

>>>All the settings in the Start-up form under Tools are disabled but the
closing cross in the above right corner is still visible.

>>>Thanks for any help.

>>>Kind regards,

>>>Simon

[Phil Stanton]

What a long winded tale this is.

The reason that I have stopped the normal closing of a form (& Db) is that I
am using Peters "ShrinkerStretcher to resize a form and it's controls. If I
have modified a form in design view, switched to form view and save the
form, the size of every control gets changed. So it is essential that a
modified form can only be closed and saved from desigh view, not form view.

Maybe you did in in anticipation of things to come.

Phil
"lyle fairfield" <ly************@gmail.comwrote in message
news:a3**********************************@56g2000h sm.googlegroups.com...
Speaking of "professional" help someone wrote EnableTitleBarControls
and DisableTitleBarControls procedures and published them in CDMA back
in the previous century.
http://groups.google.com/group/comp....a49834e9e666a1

Oh, what a dilemma this is! He wrote EnableCloseButton and
DisableCloseButton procedures too.
http://groups.google.com/group/comp....49d160dcdcb973

Who could it have been?

They're not exactly what you want as they act on the Access window
instead of a form but they could easily be modified by anyone who
wasn't bone-dead lazy and bucket-of-rocks stupid, to meet your
request. I guess that explains why I didn't suggest them earlier.

Did I mention that the procedure writer said in the same thread, "I
have no idea why anyone Would_Want to do this. (I'm assuming there
must be some way to close, so why not let Access do it in what appears
to be a safe way)"? Right now in 2008 the bucket-of-rocks stupid
hypothesis seems promising.

On Aug 27, 1:48 am, "Simon van Beek" <[e-mail]:

Tom,

The only what I can say now is Lyle is a little bit frustrated and he
needs
professional help and we are not able to help him.

Kind regards,

Simon

"Tom van Stiphout" <[e-mail] in
messagenews:6l********************************@4ax .com...

On Tue, 26 Aug 2008 07:05:31 +0200, "Simon van Beek"
<[e-mail]:

Hi Simon,
I would phrase it a bit more elegantly than Lyle, but I do feel he is
right on the substance. It is REALLY unusual to require this sort of
functionality; there usually is a MUCH better and more compatible
alternative.
I hope you won't be offended and will take the criticism to heart.
Perhaps you will post a new message that starts with: "I want to do
ABC and the best way I can think of doing that is to diable the Close
Application button. Can you suggest better alternatives?"

-Tom.
Microsoft Access MVP

>Tom,

>I try to accomplish that users can't close the application with this
button
[x] but
they have to close the application via a form.

>-Simon
"Tom van Stiphout" <[e-mail] in message
news:dv********************************@4ax.com.. .
On Tue, 26 Aug 2008 00:13:06 +0200, "Simon van Beek"
<[e-mail]:

>That's not impossible, but not easy either. What are you trying to
accomplish? That users can't close your app? There are other ways to
do that (e.g. see Cancel argument of Form_Unload). Remember some of
them will use Task Manager to nuke your app if you go down that way.
You can intercept that as well, but at an even higher cost.

>So what are you really trying to accomplish?

>-Tom.
Microsoft Access MVP

>>>Dear reader,

>>>By opening an application I get always the main Access window with the
closing cross [x] in the above right corner. Is there a possibility to
make
this closing cross invisible?

>>>All the settings in the Start-up form under Tools are disabled but the
closing cross in the above right corner is still visible.

>>>Thanks for any help.

>>>Kind regards,

>>>Simon

[CDMAPoster]

On Aug 27, 6:51*am, lyle fairfield <[e-mail]:

Speaking of "professional" help someone wrote EnableTitleBarControls
and DisableTitleBarControls procedures and published them in CDMA back
in the previous century.http://groups.google.com/group/comp..../msg/96a49834e...

Oh, what a dilemma this is! He wrote EnableCloseButton and
DisableCloseButton procedures too.http://groups.google.com/group/comp..../msg/6149d160d...

Who could it have been?

It wasn't this James. C.f.:

http://groups.google.com/group/comp....54712169e1eafe

"I found some code somewhere (perhaps Jeff's site), "

Even though I posted to CDMA in 1994,

http://groups.google.com/group/comp....7bff5d5affd8b8

the code I found was implemented after 1999.

James A. Fortune
CD********@FortuneJames.com