need help with DoCmd.OpenReport stDocName, acViewPreview, , strWhe

[Ted]

Am using A2K.

I have a switchboard form with a docmd.maximize command that has a button
which opens to a form that gets some dates (starting and stopping) which
limit the range of records of the report to be seen via the “Preview Reportâ€
command’s OnClick event. That command incorporates the

DoCmd.OpenReport stDocName, acViewPreview, , strWhere

Command above.

I had read somewhere that setting the PopUp property in the SB form to True
would have the desired ‘effect’ I wanted (to absent some of the command
buttons), but the problem I found when trying to use the Preview Report
button from the said form above was that I was no longer able to view the
report L

Its occurred to me that if I could somehow use VBA judiciously in my
underlying code I could find the right space/time to insert a command to set
the PopUp property off just before the report was needed and then to enable
the property following that.

Am I offbase with this?

-Ted

 

[Klatuu]

You will not find a way to do this. Copied from Access Help:
The PopUp property can be set only in form Design view.

 

[fredg]

Am using A2K.

I have a switchboard form with a docmd.maximize command that has a button
which opens to a form that gets some dates (starting and stopping) which
limit the range of records of the report to be seen via the ¡§Preview Report¡¨
command¡¦s OnClick event. That command incorporates the

DoCmd.OpenReport stDocName, acViewPreview, , strWhere

Command above.

I had read somewhere that setting the PopUp property in the SB form to True
would have the desired ¡¥effect¡¦ I wanted (to absent some of the command
buttons), but the problem I found when trying to use the Preview Report
button from the said form above was that I was no longer able to view the
report L

Its occurred to me that if I could somehow use VBA judiciously in my
underlying code I could find the right space/time to insert a command to set
the PopUp property off just before the report was needed and then to enable
the property following that.

Am I offbase with this?

-Ted

Gee! You could exercise a bit of patience. You posted the exact
message less than an hour ago. See your previous message for a reply.

 

[Ted]

It was not impatience so much as the feeling something or other had gone awry
in the process of uploading/posting it to the group.

Thanks much for the bandwidth!

Ted