Access Screen is Hidden. Works Great! But can't see Reports.

[RetiringSoon]

I am trying to finish off a project before retirement, but it may not happen. I have setup an application using MS Access 2007 so that there is no Access Screen behind the forms. I used the code from the Microsoft Access Forms Forum (Thread 702-487032), and it works GREAT - on forms.

The problem is that there are numerous reports that my users want to review/print and I can't find a way for the reports to show up. It is like nothing was submitted, and the form that requested the report is now locked up so the application has to be blown away.

Anyone have any ideas? Or better yet, a solution?

Thank you.

 

[lameid]

Can't see link with space....

Thread702-487032

Why it is you want to hide the access screen? It may provide insight to an alternative.

 

[lameid]

Ok having a peek at the code it looks like it decalres an api call for a function apiShowWindow.... I think you are going to have to pass it the maximize constant just before or just after you open a report and then hide it again when he report closes (Report Close event).

Do you see what I mean?

 

[RetiringSoon]

Iameid,

Thanks for the suggestion, but I tried that and it doesn't work. That is one of the reasons I am stumped.

Again, thank you.

 

[lameid]

I searched for "ShowWindow Windows API Call" and turned up an MSDN article...

http://msdn.microsoft.com/en-us/library/windows/desktop/ms633548(v=vs.85).aspx

Looks like there are other values to consider passing...
I am guessing the Show is the one to try...

Global Const SW_SHOW = 5