Hi everybody!

Basically, if I use:

Private Sub cmdButton_Click()
    MsgBox "Test"
    SendKeys "~"
End Sub

Why doesn't the system click Ok on the Message Box? Instead, it sends the enter key to the Command Button resulting in a loop!

Does anyone know how to set the active dialog to take the keys?

I am asking in the hope that I can apply the same thing to the RunReportAsPDF function that is floating around - I don't want my users to have to use the Save As Dialog that opens...

Thanks in advance,

Warren

I would avoid using sendkeys. You are asking for issues.

There is another free solution that will do exactly what you want already. No Prompts! Check out:

http://www.lebans.com/reporttopdf.htm





Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com