yunnipembokat
Registered User.
- Local time
- Tomorrow, 02:40
- Joined
- Jul 27, 2011
- Messages
- 10
I have a form that has field and button to query a report.
User fill in the field and hit the button to view the report.
I use this command to open the report.
DoCmd.OpenReport sReportType, acViewReport, , sQuery, acWindowNormal, sQuery
On the report itself it has a print preview button, which I use a macro to code it.
Action : OpenReport
Report Name : Import Rpt
View : Print Preview
Filter Name & Where Condition : Left Empty
Window Mode : Normal
It could trigger to open the print preview view of the report. But MSAccess has lost the focus. So user must go somewhere else then go back to MSAccess to have control to the mouse.
I am using MSAccess 2007 SP 2 with Windows 7 OS.
Hope somebody could help me out here.
Regards
User fill in the field and hit the button to view the report.
I use this command to open the report.
DoCmd.OpenReport sReportType, acViewReport, , sQuery, acWindowNormal, sQuery
On the report itself it has a print preview button, which I use a macro to code it.
Action : OpenReport
Report Name : Import Rpt
View : Print Preview
Filter Name & Where Condition : Left Empty
Window Mode : Normal
It could trigger to open the print preview view of the report. But MSAccess has lost the focus. So user must go somewhere else then go back to MSAccess to have control to the mouse.
I am using MSAccess 2007 SP 2 with Windows 7 OS.
Hope somebody could help me out here.
Regards