how to open report as pop up?

[MdHaziq]

Hello ,
Forum

I am having trouble w/ opening my report in pop up mode.

I am following this websites tutorial on how to make MS Access more secure.
https://accessexperts.com/blog/2015/...cess-tutorial/



TIA

Haziq

[ranman256]

you can either set the report to POPUP
or open it via:

docmd.OpenReport ,acViewPreview ,"report",,acDialog

[isladogs]

Hello ,
Forum

I am having trouble w/ opening my report in pop up mode.

I am following this websites tutorial on how to make MS Access more secure.
https://accessexperts.com/blog/2015/...cess-tutorial/

TIA

Haziq

You might be interested in the example database here which explains various ways of making a database more secure.
https://www.accessforums.net/showthread.php?t=69856

It covers everything in the link you provided & more
It also includes an answer to your specific question about a report

[Mehvan]

You can use this code

Docmd.OpenReport "ReportName",acViewPreview, , , acDialog

[isladogs]

You can use this code

Docmd.OpenReport "ReportName",acViewPreview, , , acDialog

That does indeed give you a popup report but it also means you have no print preview toolbar

[MdHaziq]

Thank you guys,

The database is working just fine now.

@ridders52,

Thanks for the file.

I have taken a look.

Great example, thanks!

-------
Haziq