Sign in Join Now. New Post. I recently purchased a laptop with Windows XP. SendKeys does work in modules. Please help. Follow Post Reply. 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. 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. In all combinations of keys is it the same or simply in one ot 2 combinations?
Some of the functions send multiple keystrokes e. I'm pretty sure the problem is with Access running in the Windows XP operating environment. The functions worked perfectly well in Windows They also work in Access 97 in the Windows XP operating environment. It's just that they don't work in Access 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 I can't find the problem in the Microsoft Knowledge database. Thanks for any help you can offer. If there is someone out there who runs Access 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. 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 Could anybody please help me with this? S: I tried installing auto keyboard software but I couldn't install them since I was at work. I need this program to work on my office PC. Mean this that you must learn a different programming language just to send two keys to the keyboard? There are simpler ways for you to achieve the same thing.
The Batch file below is an example that start another program cmd. The Batch file is simple enough to be understand with no problems, so you may modify it to fit your needs. A search for "batch file sendkeys" and further revision returned this list of answers for similar questions:. Works a charm! Last night I was working on this project at home and had some interesting things.
I put in a do while loop, basically while a variable equaled the text of the form window or till intCount was It failed every time in the loop but every single time it went to the "second chance" code which is exactally the same as the first I cut and pasted it it worked 10 for 10 times.
If this is simply to bring another window to the foreground, then maybe you should look at another bit of Karl's code. This one I've already converted to C for my own use It would be a matter of minutes to convert it to VB.
NET :. This is some truly great functionality Ok if I tab over to the "Go" button and use the Keyboard to click "Enter" the application works fine. If I use the mouse to click on the "Go" button, it does not work. Now I have 2 attempts in there after the first failure it brings up a message box.
If I mouse click the ok button it does not work, if I use the keyboard and hit the enter key to get through the messagebox it does work. This described functionality is happening all the time now I'll take another look at Karl's code again to see what I can come up with. Are you having issues with the conversion? Or understanding how to use this code?
I have been using that ForceForegroundWindow function for a long time Always works for me I just ran it through the upgrade wizard, and it worked without change - though, the api declares are wrong, and would likely cause issues if not properly upgraded.
Actually yes and no Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:.
0コメント