closing a previewed report without closing the database

[nick_faye]

Hi,

I am still a newbie to VB and using MS Access 2000. I am currently
trying to provide a preview of reports before printing them. My
program is simple:

AC.DoCmd.OpenReport "MyReport", acViewPreview
AC.Visible = True
AC.DoCmd.ShowToolbar "Print Preview", acToolbarNo
AC.DoCmd.ShowToolbar "Menu Bar", acToolbarNo
AC.DoCmd.Maximize

The report preview is successfully launched. My problem lies on how
to close the preview without closing the database. With this code,
only the Minimize, Maximize and Close button on the upper right
corner of the window remains. My only means of closing the preview
window is by pressing the Close (X) button. However, when I close my
application, the code that closes my database reports an error that
the database is already closed.

Can somebody show me a better way to do this?

Thanks a lot,
nick_faye

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Don't hide the Print Preview toolbar, it has a "Close" button on it.

Create your own custom toolbar that just has the Print Preview "Close"
button. Set the all the reports' Toolbar property to this custom
toolbar.

You can close any open object (except modal forms) in Access with the
Ctrl-W key combination.

Learn how to distinguish between the report's close button (X in upper
right) from Access' close button (X in upper right above the report's
close button).

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQiykeYechKqOuFEgEQLzCwCeKYD6g5pWMjHUyLj/zfQHkFM2Jc8An0Ug
3M1cyMAtJ12xszBTXQiSWAfB
=e7s0
-----END PGP SIGNATURE-----
nick_faye wrote:

Hi,

I am still a newbie to VB and using MS Access 2000. I am currently
trying to provide a preview of reports before printing them. My
program is simple:

AC.DoCmd.OpenReport "MyReport", acViewPreview
AC.Visible = True
AC.DoCmd.ShowToolbar "Print Preview", acToolbarNo
AC.DoCmd.ShowToolbar "Menu Bar", acToolbarNo
AC.DoCmd.Maximize

The report preview is successfully launched. My problem lies on how
to close the preview without closing the database. With this code,
only the Minimize, Maximize and Close button on the upper right
corner of the window remains. My only means of closing the preview
window is by pressing the Close (X) button. However, when I close my
application, the code that closes my database reports an error that
the database is already closed.

Can somebody show me a better way to do this?

[nick_faye]

Hi,

Thanks for responding.

Create your own custom toolbar that just has the Print Preview "Close"
button. Set the all the reports' Toolbar property to this custom
toolbar. Can you please point me to the right direction where I can find
tutorials on how to do this? Sorry, but I'm on the tight schedule.
Any help that can give me light on how to do this faster is very much
appreciated.

Thank you very much,
nick_faye

MGFoster <[e-mail]> wrote in message news:<Wv*****************@newsread1.news.pas.earth link.net>... -----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Don't hide the Print Preview toolbar, it has a "Close" button on it.

Create your own custom toolbar that just has the Print Preview "Close"
button. Set the all the reports' Toolbar property to this custom
toolbar.

You can close any open object (except modal forms) in Access with the
Ctrl-W key combination.

Learn how to distinguish between the report's close button (X in upper
right) from Access' close button (X in upper right above the report's
close button).

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQiykeYechKqOuFEgEQLzCwCeKYD6g5pWMjHUyLj/zfQHkFM2Jc8An0Ug
3M1cyMAtJ12xszBTXQiSWAfB
=e7s0
-----END PGP SIGNATURE-----
nick_faye wrote:

Hi,

I am still a newbie to VB and using MS Access 2000. I am currently
trying to provide a preview of reports before printing them. My
program is simple:

AC.DoCmd.OpenReport "MyReport", acViewPreview
AC.Visible = True
AC.DoCmd.ShowToolbar "Print Preview", acToolbarNo
AC.DoCmd.ShowToolbar "Menu Bar", acToolbarNo
AC.DoCmd.Maximize

The report preview is successfully launched. My problem lies on how
to close the preview without closing the database. With this code,
only the Minimize, Maximize and Close button on the upper right
corner of the window remains. My only means of closing the preview
window is by pressing the Close (X) button. However, when I close my
application, the code that closes my database reports an error that
the database is already closed.

Can somebody show me a better way to do this?

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Right click on any toolbar. Select Customize.

Under the Toolbars tab of the Customize dialog box either select one of
the current toolbars or click the New button to create a new toolbar.

Under the Commands tab select View in the Categories ListBox. Then in
the Commands ListBox find the word Close. Drag & drop Close onto your
new toolbar.

Close the Customize dialog box.

Open your report in design view.

In the report's Property dialog box under the Other tab, select the new
toolbar's name in the Toolbar property drop-down list.

Close & save the report.

Now the report will pop-up this toolbar whenever it is open.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQi3wQoechKqOuFEgEQKZZACfUsTmiQ8hPKsDQe8uEUheTu aohwEAoLu/
hNjZs0j94zxzFqHDQuhj1PhZ
=xCMc
-----END PGP SIGNATURE-----

nick_faye wrote:

Can you please point me to the right direction where I can find
tutorials on how to do this? Sorry, but I'm on the tight schedule.
Any help that can give me light on how to do this faster is very much
appreciated.

[nick_faye]

Thank you very much! I'll try this tonight.

nick_faye

MGFoster <[e-mail]> wrote in message news:<_e*****************@newsread3.news.pas.earth link.net>...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Right click on any toolbar. Select Customize.

Under the Toolbars tab of the Customize dialog box either select one of
the current toolbars or click the New button to create a new toolbar.

Under the Commands tab select View in the Categories ListBox. Then in
the Commands ListBox find the word Close. Drag & drop Close onto your
new toolbar.

Close the Customize dialog box.

Open your report in design view.

In the report's Property dialog box under the Other tab, select the new
toolbar's name in the Toolbar property drop-down list.

Close & save the report.

Now the report will pop-up this toolbar whenever it is open.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQi3wQoechKqOuFEgEQKZZACfUsTmiQ8hPKsDQe8uEUheTu aohwEAoLu/
hNjZs0j94zxzFqHDQuhj1PhZ
=xCMc
-----END PGP SIGNATURE-----

nick_faye wrote:

Can you please point me to the right direction where I can find
tutorials on how to do this? Sorry, but I'm on the tight schedule.
Any help that can give me light on how to do this faster is very much
appreciated.

[nick_faye]

Hi again,

What you were suggesting was cool! However, my problem is, whenever i
press the "Close" button, the tables, queries and reports are now
accessible which should not be the case. Users should not be allowed
to view the data directly from the database. Is there any other way
to do this without exposing the data of my database after closing the
preview window?

Thanks,
nick_faye

iv******@yahoo.com (nick_faye) wrote in message news:<8a**************************@posting.google. com>...

Thank you very much! I'll try this tonight.

nick_faye

MGFoster <[e-mail]> wrote in message news:<_e*****************@newsread3.news.pas.earth link.net>...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Right click on any toolbar. Select Customize.

Under the Toolbars tab of the Customize dialog box either select one of
the current toolbars or click the New button to create a new toolbar.

Under the Commands tab select View in the Categories ListBox. Then in
the Commands ListBox find the word Close. Drag & drop Close onto your
new toolbar.

Close the Customize dialog box.

Open your report in design view.

In the report's Property dialog box under the Other tab, select the new
toolbar's name in the Toolbar property drop-down list.

Close & save the report.

Now the report will pop-up this toolbar whenever it is open.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQi3wQoechKqOuFEgEQKZZACfUsTmiQ8hPKsDQe8uEUheTu aohwEAoLu/
hNjZs0j94zxzFqHDQuhj1PhZ
=xCMc
-----END PGP SIGNATURE-----

nick_faye wrote:

Can you please point me to the right direction where I can find
tutorials on how to do this? Sorry, but I'm on the tight schedule.
Any help that can give me light on how to do this faster is very much
appreciated.