Hello David:
You wrote in conference microsoft.public.access.adp.sqlserver on Thu, 12
May 2005 10:00:02 GMT:
DLv> Is it possible to change the default behaviour of Access so that when
DLv> you hit "Enter" on a Stored Proc it doesn't Run it, but opens it in
DLv> Design View? This is becoming a big annoyance (not to mention a danger
DLv> to the database) but somehow I just can't seem to train myself out of
DLv> the habit....
Easy. Write an application that hooks up the keyboard systemwide; then
monitor the keystrokes, and if you see "enter" while the active window is
Access (you will also have to check for the child objects of Access window,
to ensure that "enter" is pressed in the right place), then intercept the
keystroke, and instead send the ones that will open Design mode. Or try to
control Access via DDE or OLE, after getobject.
Of course make sure you have a good backup of your system while debugging
the app, 'cause sooner or later it will send "format c:" to the wrong
window.
As you can see, little development fun, and then you will be able to keep
your habit forever. Be careful not to lose it already while working on the
hook app.
Besides the programmatic way, there's also a mechanical one. The table
(form, etc.) will open in design mode if you press ctrl-enter. All you have
to do is put a heavy object on Ctrl key when you start working with Access,
and remember to remove it when you finish, or when you switch to OE to check
this thread for other suggestions.
regards,
Vadim
