Lost Focus !

A

Andrew

Hi All,

I have a control button on a report that should open up Print Preview for
the report so the user can select print parameters (for local or network
printing selection etc...) but when the Print Preview window opens up, it
doesn't have any focus.
You can not select anything, the screen is frozen.


Private Sub Command79_Click()

DoCmd.OpenReport "My Report", acViewPreview

End Sub


Of course, if you refresh it manually (F5) or minimize/maximize, no problem,
you have focus again.

What is wrong here? How do I add focus to the Print Preview window after it
opens up?

Andrew
 
A

Andrew

AWESOME. Thanks.
--
Thank You.

Andrew


Crystal (strive4peace) said:
Hi Andrew,

"I have a control button on a report"

If the button is on a report and you want it to work, it needs to be in
Report view, not Print Preview

use --> acViewReport
not acViewPreview


Warm Regards,
Crystal
remote programming and training

http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page tutorial that covers essentials in Access

*
:) have an awesome day :)
*
Click to expand...
 

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

Similar Threads

Print Preview still visible 1
Printing from an "Event Procedure". 3
Report Missing Data 2
Close on Lost Focus 2
Disable cmd button - focus problem 2
Print prompt in a form not working 2
Script crashes my machine 1
ReportToPDF - Leban's Method 1

Top