473,322 Members | 1,494 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Automation of key strokes

Hello,

In Excel VBA, using SendKeys in a Sub procedure with a shortcut
running the Sub/macro, I can replace a users's fingers and press keys
for him. How can I do this in Access?

I would like to assign a shortcut key combination, such as Ctrl+e to
the key sequence F10+V+Q.

How do I do that?

Cheers.

Marc R. Bertrand
mr*@goalseek.net
www.goalseek.net
Nov 12 '05 #1
2 10412
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

Access also has SendKeys. From Access Help article "SendKeys
Statement": Syntax: string[, wait]

string Required. String expression specifying the keystrokes to send.

wait Optional. Boolean value specifying the wait mode. If False
(default), control is returned to the procedure immediately after the
keys are sent. If True, keystrokes must be processed before control is
returned to the procedure.

Read the help article for more info.

You don't say where you want this "macro" to run from. If from a form,
see the help article on "KeyPress Event" which describes how to capture
the key combinations.

HTH,

MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP2eZnYechKqOuFEgEQKabwCfQwVrP1TCGgJ7vXd4nNcEmP 1Ax9gAoOfY
x4veXWJAygDbHT3OdKY0kSFW
=DQi0
-----END PGP SIGNATURE-----
"Marc R. Bertrand" wrote:

Hello,

In Excel VBA, using SendKeys in a Sub procedure with a shortcut
running the Sub/macro, I can replace a users's fingers and press keys
for him. How can I do this in Access?

I would like to assign a shortcut key combination, such as Ctrl+e to
the key sequence F10+V+Q.

How do I do that?

Cheers.

Marc R. Bertrand
mr*@goalseek.net
www.goalseek.net


Nov 12 '05 #2
Hi,

I have figured out a scheme that works just fine to toggle between SQL
view and Datasheet view. I am practicing my SQL and I run, as you can
imagine, all sorts of queries, inspecting the results in Datasheet
view.

I use a quick two-strike combination to go from SQL view to Datasheet
view:
I do Ctrl+r using an AutoKeys macro with ^r for name and OpenQuery for
action.
But I don't really have a quick way to go from Datasheet view to SQL
view. All I have figured out so far is a key combination that simply
uses the menu: Alt+v+q.

Perhaps with SendKeys I could build a second shortcut combination to
go from Datasheet view to SQL view. Unless you know of a way that
doesn't use sendkey.
(I read a thread that suggested just that, but it didn't work).

Cheers.

Marc Bertrand

MGFoster <mg***@earthlink.net> wrote in message news:<3F***************@earthlink.net>...
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

Access also has SendKeys. From Access Help article "SendKeys
Statement": Syntax: string[, wait]

string Required. String expression specifying the keystrokes to send.

wait Optional. Boolean value specifying the wait mode. If False
(default), control is returned to the procedure immediately after the
keys are sent. If True, keystrokes must be processed before control is
returned to the procedure.

Read the help article for more info.

You don't say where you want this "macro" to run from. If from a form,
see the help article on "KeyPress Event" which describes how to capture
the key combinations.

HTH,

MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP2eZnYechKqOuFEgEQKabwCfQwVrP1TCGgJ7vXd4nNcEmP 1Ax9gAoOfY
x4veXWJAygDbHT3OdKY0kSFW
=DQi0
-----END PGP SIGNATURE-----
"Marc R. Bertrand" wrote:

Hello,

In Excel VBA, using SendKeys in a Sub procedure with a shortcut
running the Sub/macro, I can replace a users's fingers and press keys
for him. How can I do this in Access?

I would like to assign a shortcut key combination, such as Ctrl+e to
the key sequence F10+V+Q.

How do I do that?

Cheers.

Marc R. Bertrand
mr*@goalseek.net
www.goalseek.net

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Al Bahr | last post by:
H I need to combine Ink strokes with the background image into a bit map. Would appreciate any help Thank A
3
by: Paulers | last post by:
Hello, I need to emulate keyboard strokes from a console application. The console application monitors a textfile and when something is matched in a text file I need the matched string outputted...
1
by: sreenulanka | last post by:
I have five panel each one layout is set to gridbag layout.and also i have one main panel, layout is box layout.all components add to container.my page is larger than screen.it is not moving with...
0
by: abcd | last post by:
Is there a way to capture key strokes on a system using python (other than pyHook)? can wxPython capture keystrokes for the system (not just, say a text box)? thanks
0
by: Sharath | last post by:
Quality Globe is Glad to Offer you the Fast Track course on Automation, QTP Basics and Advanced, and Quality Center Starting Date: June 4th, 2007 Timings: 10 AM to 3:30 PM Duration: 50 Hours ...
0
by: Sharath | last post by:
"Inspired" by the huge success of our first two automation fast track batches We are forced to start third fast track automation batch ...
0
by: Sharath | last post by:
We are glad to inform you that "Inspired" by the huge success of our first three automation fast track batches We are forced to start fourth fast track automation batch ...
0
by: Sharath | last post by:
We are glad to inform you that "Inspired" by the huge success of our first four automation fast track batches We are forced to start fifth fast track automation batch ...
4
by: =?Utf-8?B?QWxleGFuZGVy?= | last post by:
Hi! I am new to C#. I read two C# books in the last two days which only covered the basics. And now I am on my third day. The books were really bad, because they did not cover windows applications,...
1
by: Perl Beginner | last post by:
I have written an automation using Perl (Win32). in a nutshell, it's layered on top of another software and the perl script manipulates the other software's windows and menus by moving around the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.