By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,551 Members | 2,741 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,551 IT Pros & Developers. It's quick & easy.

{UNSOLVED} SendKeys In AutoKeys in Windows XP

P: 12
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.
Nov 11 '06 #1
Share this Question
Share on Google+
16 Replies


southoz
P: 24
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
Nov 11 '06 #2

P: 12
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
Nov 12 '06 #3

PEB
Expert 100+
P: 1,418
PEB
In all combinations of keys is it the same or simply in one ot 2 combinations?
Nov 12 '06 #4

P: 12
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.
Nov 12 '06 #5

P: 12
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
Nov 12 '06 #6

PEB
Expert 100+
P: 1,418
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?
Nov 12 '06 #7

P: 12
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
Nov 12 '06 #8

Expert 5K+
P: 8,434
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.
Nov 12 '06 #9

P: 12
Thanks, I appreciate that.
Nov 13 '06 #10

100+
P: 143
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.
Nov 13 '06 #11

P: 12
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.
Nov 13 '06 #12

Expert 5K+
P: 8,434
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.
Nov 13 '06 #13

Expert 5K+
P: 8,434
Leaving work soon, so I should be able to try this out for you in an hour or two.
Nov 14 '06 #14

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Nov 14 '06 #15

Expert 5K+
P: 8,434
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).
Nov 14 '06 #16

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

D
Nov 14 '06 #17

Post your reply

Sign in to post your reply or Sign up for a free account.