Unable to hide report using acHidden

M

Matt

I have tried using acHidden to hide my report but after running the
report a couple of times in succession the report window begins
showing up again. Does anyone have any suggestions for keeping a
report hidden. The reason I want to keep the report window hidden is
because I open (output to Word) the report in Word and I don't want to
confuse the user with multiple versions of the report popping up.
Thanks, Matt

Here's the code:

DoCmd.OpenReport "Project History", acViewPreview, , strWhere,
acHidden
DoCmd.OutputTo acOutputReport, "Project History", acFormatRTF,
strpath1, true
 
M

Matt

I have tried using acHidden to hide my report but after running the
report a couple of times in succession the report window begins
showing up again. Does anyone have any suggestions for keeping a
report hidden. The reason I want to keep the report window hidden is
because I open (output to Word) the report in Word and I don't want to
confuse the user with multiple versions of the report popping up.
Thanks, Matt

Here's the code:

DoCmd.OpenReport "Project History", acViewPreview, , strWhere,
acHidden
DoCmd.OutputTo acOutputReport, "Project History", acFormatRTF,
strpath1, true

Figured out the answer. Set the report visible = false.
For example: Reports("Project History").visible = false
Seems to work so far.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top