Smart questions
Smart answers
Smart people
Join Tek-Tips Forums

Member Login

Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

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

RetiringSoon (TechnicalUser) (OP)
11 Apr 12 12:23
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 (Programmer)
11 Apr 12 16:15
Can't see link with space....

thread702-487032: Hide Access Backdrop

Why it is you want to hide the access screen?  It may provide insight to an alternative.
lameid (Programmer)
11 Apr 12 16:19
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 (TechnicalUser) (OP)
12 Apr 12 6:59

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 (Programmer)
12 Apr 12 7:34
I searched for "ShowWindow Windows API Call" and turned up an MSDN article...

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


Global Const SW_SHOW = 5


Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close