Search results

Hmm pretty good idea. Never cross my mind...Not bad solution if this technical issue cant be fixed. Thanks for the input. As you said, the report already open (in normal view), why switching to print preview mode make MSAccess lose focus?

I wait for like 5 mins and focus never get back :( Yes normally we dont put buttons on report. But the users request it because they are very computer basic users. Hope somebody could figure it out.

Hi Gina, thanks for taking a look at my app. At step 8, when I click "Print Preview" button. MSAccess lose focus. Yes, the print preview displayed but I cannot click anything on MSAccess, I must click somewhere else outside MSAccess and get back to MSAccess. You did not face this issue?

@gemma-the-husky Sure we can do it that way. But as I said earlier. This app is for basic users. So it is easier for users if we prepare a button for them to print preview it. @GinaWhipp Thanks a lot for your generosity spare your time and effort to look at it. Don't worry I won't take it that...

Hi Ginna, I'm using Access 2007 SP 2 on Windows 7. Yes, once the report opens via the code it has the focus. However, when I trigger the print preview mode via a button (executed from macro expression) Access lost its focus. I must click somewhere else outside Access then get back to it. If...

Hi, Sorry if my question was unclear. The essential question is MSAccess lose focus when print preview a report when I open the report using the code. And yes this is the same report. I need to do this since the user of my application is very basic. When the report opens using DoCmd.OpenReport...

Tried it but no effect

Strange issue ... starts to frustate me

Anyone faceing the same issue here?

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...