Access 2003 SendKeys Question

[Tom]

My apologies if this is a common question or I have the wrong forum.

I have an db designed in Access 97 that I have converted to Access 2003. I
have several Access Macros that use the SendKeys function to input
information for the printing of Reports. My Macro does as follows:

SendKeys - 01* - wait
OpenReport - Print Monday - Print (view)
SendKeys - 02* - wait
OpenReport - Print Monday - Print (view)
..
..
..
..
..

Not the most efficent, but it worked.


Is there another Macro Function that I can use to get around the SendKeys
issues? Or, do I need to do a VBA script? If so, what would the
appropriate newsgroup to post a VBA/Access question?



Thank you for your time and assistance,
Tom

 

[Howard Kaikow]

See
http://www.standards.com/index.html?SetVBAProjectPassword

 

[Steve Schapel]

Tom,

It is difficult to answer your question without knowing the purpose of
the SendKeys. Where is the "01*" etc being sent to, and what does it
do? What is the difference between the various outputs of the "Print
Monday" report? There is sure to be a better way of doing it. This may
involve macro or VBA, or it may involve the design of your report and
its underlying query.