SendKeys codes

[raskew]

Hi -

There are various codes used in conjunction with SendKeys, e.g. SendKeys "%(FMC)", False to Compact.

Where are these codes found? Have checked the Help File, the Microsoft site and have come up zero.

Your wisdom appreciated.

Bob

 

[gemma-the-husky]

funny that

A97 help, which I find easiest to use gives

The plus sign (+), caret (^), percent sign (%), tilde (~), and parentheses ( ) have special meanings to SendKeys. To specify one of these characters, enclose it within braces ({}). For example, to specify the plus sign, use {+}.

but doesnt enlighten further!

 

[raskew]

Thanks Dave for the quick response.

What you found is exactly what I came up with, which still doesn't answer the question.

Best Wishes - Bob

 

[namliam]

You mean the FMC part?? FMC are just the letters that are beeing send...

% is the ALT key
+ Shift key
^ CTRL key

The () mean keep the previous key pressed while pressing these keys.

so in this case press and hold ALT, then press FMC, release ALT

 

[namliam]

Full explenation on MSDN:
http://msdn.microsoft.com/en-us/library/8c6yea83(VS.85).aspx

Also FYI, it is a known feature that Access Sendkeys function tends to mostly also toggle your Numlock and/or Capslock keys on the keyboard....

 

[raskew]

Hi -

Understand that it's sending keystrokes. But, the referenced site still doesn't explain that Alt-FMC will initiate the Compact action. That's what I'm attempting to find.

Thanks for your response.

Bob

 

[namliam]

It is sending the keystrokes to the active window... I.e. to your access database...

You probably have a custom menu in the database, where typing (on the keyboard too) is sending the database to compact...
In my default menu that would be %TDC
For Tools > Database Utilities > Compact database

Alt (if you dont know) in most/all windows apps will send you to the menu.

 

[raskew]

Thank you!

That solves the mystery! Just couldn't see what those seemingly random letters represented.

Best wishes - Bob

 

[namliam]

The trick to remember is that these here keys are send to the active database window. If you dont know where they are, what they are doing, just repeat what the sendkeys does and you can find it too

 

[gemma-the-husky]

you would think the help would be more informative

it gives a full list of the {} type keystrokes

 

[raskew]

you would think the help would be more informative

Yeah, for sure! That's what I thought.

An explanation as simple as what Namliam provided could clear up a whole bunch of confusion.

Bob

 

[namliam]

you would think the help would be more informative

Erm... We are talking M$ right??? Informative help is not one of their specialities...

I have been suggested the very thing that Bob is saying... Thanks for the complement, I love to keep things KISS