puase needed for SendKeys action

P

Phil M

I am using the SendKeys action to callup MSword MailMerge
in order to print a record. Unfortunately the delay
while MSWord is opening causes the ^p (ie, the "print"
command) keystroke to arrive too early. Nothing happens.

I've tried breaking up the SendKeys action into various
length segments and seting the 'Wait" argument to "yes"
for the relevant segments, but this strategy has failed
completely. The macro just stalls after the "Wait: Yes"
segment.

I need some way for the macro to pause for three seconds
while it is running. Any suggestions?

Yes, I know that I can break the macro into separate
macros and use the timer on a form. Is there any other way
to handle this problem?

(I am using MSWord MailMerge because Access Reports can't
handle the complicated formatting that I require.)
 
S

Steve Schapel

Phil,
Yes, I know that I can break the macro into separate
macros and use the timer on a form. Is there any other way
to handle this problem?

No.

- Steve Schapel, Microsoft Access MVP
 

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