sendkeys action

M

Megan Olarte

Please Help! When I set up a macro to use the "sendkeys"
action, it says I require the utilities add-in. When I
go to the add-in manager and install it, the correct add-
in appears, but as soon as the add-in manager is closed
and re-opened, it is no longer listed; thus, the macro
still won't run properly. How do I get the add-in to
stick? I am running Access 2000 on a WinXP machine;
although, I have had this problem with Access 2000 on an
NT machine as well. Alternatively, if anyone knows how
to get a macro to copy all records from one table into
another without using the sendkeys function, please let
me know. Thanks!
 
S

Steve Schapel

Megan,

It sounds like you need to use an Append Query to copy your records
from one table to another. If you want this to be part of a macro,
use an OpenQuery action in the macro to make the Append Query happen.

- Steve Schapel, Microsoft Access MVP
 
C

corey777

Megan said:
*Please Help! When I set up a macro to use the "sendkeys"
action, it says I require the utilities add-in. When I
go to the add-in manager and install it, the correct add-
in appears, but as soon as the add-in manager is closed
and re-opened, it is no longer listed; thus, the macro
still won't run properly. How do I get the add-in to
stick? I am running Access 2000 on a WinXP machine;
although, I have had this problem with Access 2000 on an
NT machine as well. Alternatively, if anyone knows how
to get a macro to copy all records from one table into
another without using the sendkeys function, please let
me know. Thanks! *

Megan,
Don't know if you're still around or not, and this is way off topic
but did you by any chance attend high school in Georgetown, TX


-
corey77
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top