Suppress MS-Access Window

  • Thread starter Thread starter JimP
  • Start date Start date
J

JimP

I have a report that runs completely from an autoexec macro (takes awhile) -
would like to prevent the MS-Access window from displaying until the report
appears. Can this be done?
 
Hi,
do you mean database window? then go to menu tools-startup and then uncheck
"display database window" there. If you mean main access window - then not
sure you can completely hide it, I suggest to either show some form or blank
report while your main report is loading

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com
 
Nope - not database window - the entire MS-Access window. I could always
display a blank form with a progress meter, but was interested to know if
the entire MS-Access window could suppressed.
 
Per instructions, I created pop-up form with code to call function on "open"
event - get error message "Cannot hide Access unless a form is on screen"

Am I missing a reference, or do you have any ideas what is causing the
error?
 
In
JimP said:
Per instructions, I created pop-up form with code to call function on
"open" event - get error message "Cannot hide Access unless a form is
on screen"
Am I missing a reference, or do you have any ideas what is causing the
error?
Click to expand...

Two things:

1. Make sure the form is both PopUp *and* Modal.

2. In the form's Open event, explicitly make it visible before hiding
the Access window:

Private Sub Form_Open(Cancel As Integer)
Me.Visible = True
DoEvents
fSetAccessWindow SW_HIDE
End Sub

That should do it.
 
Form works great! But, for some reason when I do SW_SHOWMAXIMIZED the meubar
and toolbars are not visible. Can I explicitly m
 
The form works great! But, when I do SW_SHOWMAXIMIZED, the menubar and
toolbars are not visible. Can I explicitly make them visible via code?
 
Back
Top