Send Keystrokes

[Guest]

I have a macro that runs when a button is pushed, this appends some tables
with fresh information, but it will not allow the information to be
duplicated. I get the normal message that says x number or records could not
be appended due to duplication. I have sent a sendkey y in the macro to try
and make this seamless for the operators but it does not seem to work, is
there something else I can do. Thanks

 

[Steve Schapel]

Akrt,

You didn't mention what your macro does. Assuming you are using an
OpenQuery action to run an Append Query, you can put a SetWarnings/No
action in the macro before the OpenQuery action, which will suppress the
display of the action query confirmation prompts.

 

[Guest]

You are a good guesser, thanks Steve.

Akrt,

You didn't mention what your macro does. Assuming you are using an
OpenQuery action to run an Append Query, you can put a SetWarnings/No
action in the macro before the OpenQuery action, which will suppress the
display of the action query confirmation prompts.