Send keys

[Guest]

Is there a list of the sendkeys in ms access?

I want to replace in one field (column) all the "0" with "-1" (this is
yes/no field, replace No by Yes).
Is there somebody who have an simple macro for it.

Thanks.
Michel

 

[Fred Boer]

Dear Michel:

I don't know about a list of sendkeys, but I think that this sounds like a
job for.....<cue superhero music..> an update query! An update query can
easily be created to do just what you want. If you want to automate it, then
I suppose you can create a macro that runs the update query (although I know
nothing about macros, actually).

If you need help creating the update query, post back!

HTH
Fred Boer

 

[Nikos Yannacopoulos]

Fred is absolutely right, it's an update query job all the way.

To your other question, there is a full list of SendKeys arguments in
Access help. What it doesn't say in there is you should avoid SendKeys
at any cost, if at all possible! SendKeys is notorious for doing one
thing when you expected it to do another, and sometimes you realize when
it's too late... that's because it doesn't have the ability to
understand what it was supposed to do and check if that's what it's
acually doing, it just keeps on sending the key sequence instead!
Whatever you might use it for can be done in a much more efficiemt and
robust way.

HTH,
Nikos