{UNSOLVED} SendKeys In AutoKeys in Windows XP

[mddrains]

I recently purchased a laptop with Windows XP. I installed Access 2000 and find that SendKeys does not work in my AutoKeys Macro. I get a message at the bottom of the screen when I close the Macro that says "Setting Up Wizards".

SendKeys does work in modules. Please help.

[southoz]

Good ay ,
tell us exactly what you are trying to do - eg: why are u trying to use sendkeys and we maybe able help with a clearer understanding

southoz

[mddrains]

I use AutoKeys in Access much like I would use a Macro in Word - i.e., to automate keystrokes for repetitive tasks. For example I have one autokeys function that copies the first line in the box that appears when you place the cursor on a macro command line into the comments field of the command line. I have another that will change the unicode compression option in a table to yes (for imported data). Another will insert code to create a specific output field in queries that displays a concatenation of the name fields.

Thanks,
D

[PEB]

In all combinations of keys is it the same or simply in one ot 2 combinations?

[mddrains]

Some of the functions send multiple keystrokes (e.g., {F6}{Down}{Down}{Down}{Down}{Down}{Down}{Down}{Dow n}{Down}No{F6}{Down} ) and others send only one (e.g., {F6} followed by a RunCommand Copy, etc. The RunCommand Copy works, just not the SendKeys.

I'm pretty sure the problem is with Access 2000 running in the Windows XP operating environment. The functions worked perfectly well in Windows 98. They also work in Access 97 in the Windows XP operating environment. It's just that they don't work in Access 2000 under Windows XP. I was hoping someone had had this problem and resolved it.

I've tried everything I know to do, including uninstalling and reinstalling Access 2000. I can't find the problem in the Microsoft Knowledge database.

Thanks for any help you can offer.

D.

[mddrains]

If there is someone out there who runs Access 2000 in the Windows XP Pro operating system, could you try this for me?

Set up a macro named AutoKeys if you don't have one already.

Open AutoKeys in design mode and
Enter ^6 in the MacroName column
Enter Sendkeys in the action column
Enter {F6} in the Keystrokes window in the lower part of the window
Save the macro

Open any table in design mode
Position your cursor on any field name
Hold down the CTRL key and press the 6 key on the keyboare (not the keypad)
Let me know if the cursor branches to the lower part of your screen or if you get the message Setting up Wizards on the message bar

That will at least tell me if it's something on my computer of if it's a Microsoft problem.

Thanks.

D

[PEB]

Sorry i'ven't this configuration available..

But have you tried to use SendKeys by VB?

If it works it should be very easy to create a function MySendKeys() for exemple

And transmit to this function all of your combinations... And it should works :)

So you will always use your macro and should be easy to modify your combinations of keys but using your user defined function?

Is it suitable for you?

[mddrains]

I have thought about setting up a VB function but don't know how to activate it (possibly multiple times in a row) from inside a table design view (for example). The advantage, as I see it, of AutoKeys is that it is activated by pressing the CTLR key and one other key.

Thanks,

D

[Killer42]

If there is someone out there who runs Access 2000 in the Windows XP Pro operating system, could you try this for me?
...

I have, at home. Will be there in around 8 hours (it's Monday morning here now). If I can remember, I'll be happy to give it a try.

[mddrains]

Thanks, I appreciate that.

[Tanis]

As an aside, SendKeys is one of those functions that should come with health warning, "use at your own risk". Sendkeys can be unstable, which is why Microsoft don't advocate the use of them.

[mddrains]

Do you know another way to automate keystrokes and functions (like macros in Word and Excel)? I seldom use sendkeys in applications but often use AutoKeys with the SendKeys Action during development.

[Killer42]

Do you know another way to automate keystrokes and functions (like macros in Word and Excel)? I seldom use sendkeys in applications but often use AutoKeys with the SendKeys Action during development.

Sorry, I've just got back to work - I completely forgot to try the AutoKeys at home.

I'll e-mail myself a reminder right now, but once again, it's going to be a good 8 hours or more before I'm there to read it.

[Killer42]

Leaving work soon, so I should be able to try this out for you in an hour or two.

[MMcCarthy]

Leaving work soon, so I should be able to try this out for you in an hour or two.

Wasn't commenting on your resposnse just testing the new tagging.

Mary

[Killer42]

Wasn't commenting on your resposnse just testing the new tagging.
Mary

I have no idea what you mean. Anyway...

mddrains, I just created the AutoKeys entry for ^6 as requested, in Access 2000 under Windows XP. It worked. (I must file that away for future reference - looks handy).

[mddrains]

Thank you very much. At least I now know it's my setup and can work from that position.

D