sendkeys to another application

[mac521]

I would like use access to update another application by using the sendkeys method.

What I'm looking for is how to set the focus to the other application window and then use sendkeys to type in the account number and update the account with new information that will be stored in the access table.

Can anyone help me get started with the correct code? I've done this before but its been like 5 - 6 years and are totally drawing a blank.

[ADezii]

I would like use access to update another application by using the sendkeys method.

What I'm looking for is how to set the focus to the other application window and then use sendkeys to type in the account number and update the account with new information that will be stored in the access table.

Can anyone help me get started with the correct code? I've done this before but its been like 5 - 6 years and are totally drawing a blank.

The following code should point you in the right direction and will:

1. Open Notepad
2. Type the text George W. Bush into the Window
3. Close Notepad
4. At the Save prompt, click on Yes
5. Save the Filename as George W. Bush (.txt will automatically be added)
6. Click on the Save Button

Dim retVal As Variant
 
retVal = Shell("Notepad", vbNormalFocus)    'Run Notepad
 
SendKeys "George W. Bush"           'Type George W. Bush in Notepad Window
 
SendKeys "%{F4}", True              'Send ALT+F4 to close Notepad
 
SendKeys "{ENTER}", True            'Yes at the Save Prompt
 
SendKeys "George W. Bush", True     'Type Filename to Save Document to
 
SendKeys "%S"                       'Activates the Save Button