How to avoid user to close my Access program?

E

Egg

Dear All,

I am using Access XP (Access 2002) to make my program and use the developer
run time program to delivery my program. In my main form, I can set the
close button to "No" to avoid user to quit the program, but the user can
still use the Access close button (on the top right cross button) to close
the program.

Any way to avoid use close the program? Any suggestion will be highly
appreciated. Thank you.


Daryl
 
R

Rick Brandt

Egg said:
Dear All,

I am using Access XP (Access 2002) to make my program and use the
developer run time program to delivery my program. In my main form, I
can set the close button to "No" to avoid user to quit the program,
but the user can still use the Access close button (on the top right
cross button) to close the program.

Any way to avoid use close the program? Any suggestion will be highly
appreciated. Thank you.


Daryl
Click to expand...

If you cancel the Unload event of a form that is always open (or a hidden one
used just for this purpose) then Access will not close. At least not until the
user opens TaskManager and kills it that way.
 
T

Tony Toews [MVP]

Egg said:
Any way to avoid use close the program? Any suggestion will be highly
appreciated. Thank you.
Click to expand...

Why? What's the problem with the user closing the Access app?

If you have some logic that must be done before closing the app then
put it in the OnClose event of a hidden form you open on startup.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
E

Egg

Because my program need to run 24 hours, and at night time some tasks will
be done automatically. So if user close the program, it might be some
problem.

Daryl
 
T

Tony Toews [MVP]

Egg said:
Because my program need to run 24 hours, and at night time some tasks will
be done automatically. So if user close the program, it might be some
problem.
Click to expand...

Gotcha. Good reason.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
V

Vladimír Cvajniga

Hi, Daryl,

don't forget to add a routine that enables you to interrupt program
execution, eg. when you want to install new version. :)

Vlado
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlink fails to open on the first click 0
How does one detect when an application is bieng close BY closing a window? 1
Word 2003 won't exit 8
Crash on Close from 2 stable Access forms after unsolicited install of VS 2015 0
InfoPath 2013 crashes when trying to connect to Access 2016 DB 0
How to avoid Access corrupt? 2
How to avoid user open the same "mde" file more than 1 time? 2
My computer will print from ALL other programs except MS publisher 2007 4

Top