report preview

  • Thread starter Thread starter steve a
  • Start date Start date
S

steve a

hi.
I have a modal popup form, which has a comand button to preview a report,
howeevr the preview always sits behind everything....
Is there anyway i can get it to come to the front? so you can see it?
Thanks
 
Steve

"Modal" means "keep on top". Try changing how that form displays
(de-modal-ize it).

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Hi jeff.
I've made it so that the forms are now not modal, however th epreview is
still behind the popup's (there is 3 in total, one is maximised to full
screen, the others are still visible). ANy ideas? I was thinking maybe that
there would be some code to include in the preview command which would bring
it to front or select it (like ? setfocus?)
looking forward to your reply.
Thanks again
stev
 
One ?what? is maximised, 3 ?what? in total? Forms? Reports? Preview or
previews?

When I use a form to gather criteria, then open a report (maximized) in
preview, it always comes to the front (i.e., hides the form).

Can you describe a bit more about what your design is doing that's
different?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Hi
Sorry reading the post back it was quite confusing!!

I have a series of forms, three in total, one of the forms is a
maximised popup which is unmoveable. The other two are just as normal
popup's. one to select the type of report, the other to input data into the
report from combo / text boxes.
on the last of these forms is a preview report command button. and the
preview opens behind all the other reports and isn't "active", the last form
remains active.

it would be good to maximise the preview how do i do this, the current code
i use for the preview button is:

Dim stDocName As String

stDocName = "rptptias"
DoCmd.OpenReport stDocName, acPreview


hope that clears things up a little....
thanks for your input jeff,
steve
 
Rather than putting the "maximize" in the preview code, consider adding it
to the Report's OnOpen event.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top