How to determine what view a report is being opened in

[DreewToo]

I'd like to add a conditional to the On_Activate event to examine what view a report is opening in, and bring up the print dialogue if the rpeort is opening in acViewNormal.&nbsp;&nbsp;Is there an easy way to do this?<br><br>TIA,<br>Drew

 

[DougP]

Easiest way is make the user open your report is with a command button only. Don't allow them an option.<br>Make 2 buttons, One for Viewing and one for Printing.<br>Then in each button put what ever you want to look for.<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[DreewToo]

That's what I have, but I'd like to test if the report's being called for printing, so I can bring up the print dialogue.

 

[DougP]

Why do you want to bring up the print dialog box?<br>Are they printing to the wrong printer?<br>if so see my FAQ: <br><br><A HREF="

http://www.tek-tips.com/faq.cfm?spid=703&page=1&CFID=4719042&CFToken=64483187#169"

TARGET="_new">

http://www.tek-tips.com/faq.cfm?spid=703&page=1&CFID=4719042&CFToken=64483187#169</A><br><br>this

saves all settings so it prints correctly everytime.<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[desiboy]

Use the following:<br>SendKeys &quot;^{p}&quot;, False<br> <p>Sandeep Anand<br><a href=mailto:sandeep@matatechnologies.com>sandeep@matatechnologies.com</a><br><a href=

http://www.matatechnologies.com>Mata

Technologies</a><br>visit

http://www.matatechnologies.com

 

[DreewToo]

Dang, forgot to check the thread...<br><br>It's that I'm developing off-site, and can't be sure what type/port of printer will be used for printing.&nbsp;&nbsp;I've read of prtdev(sp?) strings, and their manipulation, but haven't ventured there yet. <br><br>desiboy - I'm somewhat concerned over using sendkeys due to multiple postings on the newsgroup regarding their efficiency.<br><br>Thank you for your responses,<br>Drew