Re: Quuestion about SendKeys

SendKeys "Y", True
SendKeys "J", True
SendKeys {Enter}, True or SendKeys ~, True

You could also use DoCmd.SetWarnings False to turn off message boxes and

Search help for SendKeys Statement for a complete list. That being said, SendKeys is just about the absolute worst thing you can use in a program. In order for it to work everything must be identical to the environment it was set up in. Focus on controls, menus, forms. VBA is the way to go. Good Luck Duff
"R. Groot Beumer" <Info_at_RGBplus.nl> wrote in message news:uPZ_6.150926$u5.2971454_at_zwoll1.home.nl...
> Hello,
>
> Within my database i'm using a query which adds new combinations to a
> certain table. I only want to add new combinations (not existing, which
> isn't possible because of the primary keys) with this query.
> Now i've made this query, but when I run it I obviously get the message
> regarding the key conflicts (because a lot of the combinations already
> exists). I want to tackle this problem by using the sendkey command. When
 i
> start this query (in VB) i want the following line to contain this SendKey
> command
>
> My question:
> Whats the syntax of the SendKey command for the Return(Enter)-key. The
 same
> I need for the Y and the J keys.
>
> thanx already,
>
> Remco Groot Beumer, Holland
>
>
Received on Sun Jul 22 2001 - 01:32:31 CEST