Send Keystrokes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Akrt48 - 27 Apr 2006 19:29 GMT

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

Reply to this Message

Steve Schapel - 27 Apr 2006 21:03 GMT

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.

Signature

Steve Schapel, Microsoft Access MVP

> 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

Reply to this Message

Akrt48 - 28 Apr 2006 00:11 GMT

You are a good guesser, thanks Steve.

> Akrt,
>
[quoted text clipped - 9 lines]
> > and make this seamless for the operators but it does not seem to work, is
> > there something else I can do. Thanks

Reply to this Message