Switching Modes at Runtime

[ZooBaby]

Is there a way to dynamically (using VBA) switch RUN mode
in Access97 to EDIT/Design mode without holding down the
SHIFT Key upon start up?

Reason for asking: I am annoyed by having to remember to
hold the SHIFT key down upon startup. I also want to
disable the SHIFT key and some other 'special' keys. I
have code to do this keys disabling, but during run mode I
seem to have very limited ability to editting and changing
stuff. I tried changing the "Menu Bar" so I can control
what the users see, but enabling and setting the Edit,
View, Debug, and Run controls of the default menubar
doesn't make them appear during run mode - even if I try
forcing simulation of holding the SHIFT key using
SENDKEYS "+" as the very first command (after validating
member of group "Admins"). Anyone have a solution to this?

ZooBaby

 

[Albert D. Kallal]

Is there a way to dynamically (using VBA) switch RUN mode
in Access97 to EDIT/Design mode without holding down the
SHIFT Key upon start up?

Reason for asking: I am annoyed by having to remember to
hold the SHIFT key down upon startup.

Yes, but now you will have to remember to hit some button to un-do the shift
key stuff anyway? How does this save you anything. You still have to go and
hit some option? I mean, either way..you have to hit some key, or do
something. How long does it take to exit and re-enter?

I mean, during the day I often exit..and re-run my application during
development...I try a few things..and exit..and then hold down shift while I
re-enter to get back into "development" mode.

.. So, this flipping between testing as a user and development occurs
very fast (about 1 second on my computer).

Quick exit...then re-enter ..how long does that take?

In fact,I whack alt-f4 to exit..then whack
enter to re-enter as a "user" with all of ms-access interface hidden etc.

This is ONLY two keys strokes..and occurs in flash! Of course..I can hit the
enter key...since the mdb file is still
highlighted in the explore window.

When you are finally done, and ready to distribute...then you can disable
the shift key

So, my only point here was then you ONLY need disable the shift key stuff
WHEN YOU create the mde...not during regular development (since, as per
above...is very quick to test start-up options..and then go back to
development mode and use the shift-bypass).

So, alt-f4....shift-enter to get back in (or, don't hold down the shift key
to see how it works for your users). I flip back and fort all day. I mean,
if you do this 30 times in one day..you are still talking well under 1
minute of time you waste.

How much of a hurry are you in..and how many times in a day do you switch
between "test" user mode with ALL of the start up options, and then exit and
go back to your "development" mode? I mean, often a good portion of your
development and testing of forms will NOT require you to exit the database
and re-enter with OUT holding the shift key to see how it will work in user
mode. So, I am somewhat at a loss to understand the problem here...

And, if you start disabling the shift key...then only disable the shift key
by-pass in the mde that you create (you do use a split database..and ALWAYS
distribute a mde to your users...right?).

 

[david epsom dot com dot au]

Is there a way to dynamically (using VBA) switch RUN mode

in Access97 to EDIT/Design mode without holding down the

No, you have to switch each action individually, and

Are you talking about the 'startup code' or are you talking
about the 'runtime switch'?

(david)