Hello
I have just completed the development of a turn-key Access2k
application. I am using MS Access 2000k application, not the RunTime.
I have compiled it, split it (FE & BE), set all the StartUp Options to
Off, and created the FE MDE. My problem is that the MS Access
(File->Edit->Insert->Records->Window->Help) Menu still appears at the
top
of the screen, which allows the user to Exit without using the CLOSE
BUTTON in my application. Is there a way to shut this Menu OFF ???
ThankYou Greg 8 1899
Allow me to answer my own question:
Application.CommandBars("Menu Bar").Enabled = False
'Place this in the OnOpen of the form, solves my problem.
BUT
I still get the MS Access bluebar (for lack of better expression) at
the top of
the screen. This has a close button that the user can press to quit
access,
instead of using my CLOSE BUTTON.
How do I get rid of this, or at least shut off that X (access bluebar
close button) ? Ap******@gmail.com wrote: Hello
I have just completed the development of a turn-key Access2k application. I am using MS Access 2000k application, not the RunTime. I have compiled it, split it (FE & BE), set all the StartUp Options to Off, and created the FE MDE. My problem is that the MS Access (File->Edit->Insert->Records->Window->Help) Menu still appears at the top of the screen, which allows the user to Exit without using the CLOSE BUTTON in my application. Is there a way to shut this Menu OFF ???
ThankYou Greg Ap******@gmail.com wrote: Allow me to answer my own question: Application.CommandBars("Menu Bar").Enabled = False 'Place this in the OnOpen of the form, solves my problem.
BUT
I still get the MS Access bluebar (for lack of better expression) at the top of the screen. This has a close button that the user can press to quit access, instead of using my CLOSE BUTTON. How do I get rid of this, or at least shut off that X (access bluebar close button) ?
If you have a form that is opened at start up and stays open the entire time
that your app is running then you can execute whatever code you are running
now in your [Close] button in the Close or Unload event of that form. That
way you don't have to concern yourself with how they close the app.
If you don't have such a form then create one explicitly for that purpose
and open it hidden at startup.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Thankyou for the response.
The suggestion of OnUnload or OnClose of the form does not work
for me, because my VARIABLES LOSE THEIR VALUES in those
states? These two publicly defined Variables get assigned in the
Module1 module and work perfectly throughout the app, but lose
their value without reason, in the unload of the form? This is not an
option. Any other ideas? Can't I shut off the [X] close button of the
MS Access BlueBar?
Rick Brandt wrote: Ap******@gmail.com wrote: Allow me to answer my own question: Application.CommandBars("Menu Bar").Enabled = False 'Place this in the OnOpen of the form, solves my problem.
BUT
I still get the MS Access bluebar (for lack of better expression) at the top of the screen. This has a close button that the user can press to quit access, instead of using my CLOSE BUTTON. How do I get rid of this, or at least shut off that X (access bluebar close button) ?
If you have a form that is opened at start up and stays open the entire time that your app is running then you can execute whatever code you are running now in your [Close] button in the Close or Unload event of that form. That way you don't have to concern yourself with how they close the app.
If you don't have such a form then create one explicitly for that purpose and open it hidden at startup.
-- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
* Ap******@gmail.com: Thankyou for the response. The suggestion of OnUnload or OnClose of the form does not work for me, because my VARIABLES LOSE THEIR VALUES in those states? These two publicly defined Variables get assigned in the Module1 module and work perfectly throughout the app, but lose their value without reason, in the unload of the form? This is not an option. Any other ideas? Can't I shut off the [X] close button of the MS Access BlueBar?
Rick Brandt wrote: Ap******@gmail.com wrote: Allow me to answer my own question: Application.CommandBars("Menu Bar").Enabled = False 'Place this in the OnOpen of the form, solves my problem.
BUT
I still get the MS Access bluebar (for lack of better expression) at the top of the screen. This has a close button that the user can press to quit access, instead of using my CLOSE BUTTON. How do I get rid of this, or at least shut off that X (access bluebar close button) ? If you have a form that is opened at start up and stays open the entire time that your app is running then you can execute whatever code you are running now in your [Close] button in the Close or Unload event of that form. That way you don't have to concern yourself with how they close the app.
If you don't have such a form then create one explicitly for that purpose and open it hidden at startup.
-- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
You can drive a nail in with a bowling ball but your time might be
better spent looking for your hammer. Ap******@gmail.com wrote: Thankyou for the response. The suggestion of OnUnload or OnClose of the form does not work for me, because my VARIABLES LOSE THEIR VALUES in those states? These two publicly defined Variables get assigned in the Module1 module and work perfectly throughout the app, but lose their value without reason, in the unload of the form? This is not an option. Any other ideas? Can't I shut off the [X] close button of the MS Access BlueBar?
So leave the form open the whole time the app is running. Just hide
it. Then who cares if the variables go out of scope when the form
closes?
"Ap******@gmail.com" <Ap******@gmail.com> wrote in
news:11**********************@y41g2000cwy.googlegr oups.com: Thankyou for the response. The suggestion of OnUnload or OnClose of the form does not work for me, because my VARIABLES LOSE THEIR VALUES in those states? These two publicly defined Variables get assigned in the Module1 module and work perfectly throughout the app, but lose their value without reason, in the unload of the form? This is not an option. Any other ideas? Can't I shut off the [X] close button of the MS Access BlueBar?
No you cannot shut off that X, without some very serious hacking of
the operating system.
You say you lose some publically defined variables. Variables have
to be initialized and set to a value to be any use. You may want to
store those values in a table somewhere, so that they can be
restored when you reopen the database.
--
Bob Quintal
PA is y I've altered my email address.
--
Posted via a free Usenet account from http://www.teranews.com Ap******@gmail.com wrote: Thankyou for the response. The suggestion of OnUnload or OnClose of the form does not work for me, because my VARIABLES LOSE THEIR VALUES in those states? These two publicly defined Variables get assigned in the Module1 module and work perfectly throughout the app, but lose their value without reason, in the unload of the form?
There is no specific reason for a public variable to lost its value in these
events. In an MDB though public variables can lose their value when an
unhandled error occurs. Many developers avoid this problem by using hidden
TextBoxes or TextBoxes on hidden forms instead of public variables.
Since you need a hidden form for its Close/Unload event then you have a
perfectly logical container for such TextBoxes.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
You're correct Rick.
I discovered that my Variable values were lost because I had left
the "DoCmd.Quit" statement in "MyCloseButton", so when the
Unload of the form took place my Variable values had already been
discarded. I corrected the problem.
Thankyou All for your advice.
Greg
Rick Brandt wrote: Ap******@gmail.com wrote: Thankyou for the response. The suggestion of OnUnload or OnClose of the form does not work for me, because my VARIABLES LOSE THEIR VALUES in those states? These two publicly defined Variables get assigned in the Module1 module and work perfectly throughout the app, but lose their value without reason, in the unload of the form?
There is no specific reason for a public variable to lost its value in these events. In an MDB though public variables can lose their value when an unhandled error occurs. Many developers avoid this problem by using hidden TextBoxes or TextBoxes on hidden forms instead of public variables.
Since you need a hidden form for its Close/Unload event then you have a perfectly logical container for such TextBoxes.
-- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: chart43 |
last post by:
I have question about the technique for css dropdown menus described in
http://www.alistapart.com/articles/horizdropdowns/. Based on an html list,
it has a few items in a 1st order list and further...
|
by: Marci |
last post by:
I found this script for cascading menus, however, I cannot reach the
author to solve the bug I am having when I add a second menu to it.
My problem is this:
If I click on the first link, the...
|
by: Pete |
last post by:
In Access 95/97 I used to be able to create pull down menus (File,Edit
...) from a macro. It seems there used to be some wizard for that.
However in Access 2000 it seems you have to build your...
|
by: cefrancke |
last post by:
I have set the Startup properties to the following...
All menus, toolbars, etc are turned off plus these are unchecked
Allow Full Menus
Allow Built-in Toolbars
Allow Default Shortcut Menus...
|
by: cefrancke |
last post by:
The only reason I ask is that no one has made this subject clear or
given a definitive answer.
What I would like to do is, after turning off all the menus/tbars/etc
using the startup options.
...
|
by: cefrancke |
last post by:
I recently discovered, that if you set the startup options for
"security", you will have alot of work do to get Access back to
"normal".
If you disable the built-in menus/toolbars you'll have to...
|
by: Karl Irvin |
last post by:
I distribute an A 2000 app as a mde.
On a few customers, my custom menus are overwritten. The top menu is
generally there but the choices on the menus are gone or replaced by
something else.
...
|
by: Steven Smith |
last post by:
the way I'm undersatnding the MSDN documentation when
creating parent and child forms the main menu for the
child form should not be displayed on the child form
itself but instead be incorporated...
|
by: ARC |
last post by:
Hello all,
For right-click (shortcut) menus in access 2007, I've been using a
round-about method of opening access 97 on an old computer, modifying my own
custom shortcut menus, then importing...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |