Short Cut Keys To Run Query

[orcinus]

Besides using:



alt+v s

To run a query without using the mouse, is there any other shortcut keys that can be used?

Thanks for any help..

[boblarson]

You can create an AutoKeys macro which then can be defined to do whatever you want to do (subject to not duplicating some system key combinations I believe).

[orcinus]

You can create an AutoKeys macro which then can be defined to do whatever you want to do (subject to not duplicating some system key combinations I believe).

So, I know how to create an autokeys macro, but want to be able to open any query from design view, not a specific query. However using the macro command OpenQuery requires entry of a specific query and so does DcCmd in VB.

Or is there a way to bypass this by, in affect, entering a wildcard for the query name argument (I know asterix won't work - I tried it)..

Thanks..

[boblarson]

So, I know how to create an autokeys macro, but want to be able to open any query from design view, not a specific query. However using the macro command OpenQuery requires entry of a specific query and so does DcCmd in VB.

Or is there a way to bypass this by, in affect, entering a wildcard for the query name argument (I know asterix won't work - I tried it)..

Thanks..

I've do not know of a way to actually do that.

[orcinus]

I've do not know of a way to actually do that.

ok, so I found a way to do this using SENDKEYS

In the AUTOKEYS macro, you add what you want to be the shortcut, say:

^s

and in the Action column, you choose SENDKEYS and include the following (for running a query):

%v s

For going back into design mode:

%v d

It looks as if whatever you choose for this will overide what already exists as default shortcuts in ACCESS. I chose CTRL+S and CTRL+D because I never use those shortcuts.

Thanks for your help!

[boblarson]

Just an FYI but you will probably end up with a problem once you either go to Vista or Windows 7.