hiding access window and opening Report preview (1 Viewer)

[nelson]

Hi,

I successfully made this work, but when opening a report to preview it (using a button click) . it doesn't show up, is there a workaround with this? Thanks in advance.

Kind Reagrds.
Nelson

 

[Vassago]

You'll have to make the access window visible while the report is showing and then when the report is closed, have it hide the access window again. This is the only way I have found to make this work.

 

[nelson]

hehehe ok ok..thanks !!!

 

[nelson]

ok, I've done it but how to I make the preview for the report to be on top ? Any idea ? Thanks in advance.

 

[nelson]

DoCmd.OpenReport "Labels-Bishops", acPreview, , , acDialog
, it's ok...done it... hehehe

 

[Vassago]

Glad I could NOT help.

 

[rahulgty]

Hey .....
I don’t think its compulsory to show access window just for report. You can use Snapshot Viewer Control to display and print report.

rahulgty

 

[nelson]

can u show me an example in VB code ? thanks...

 

[nelson]

i got the SNAPSHOT viewer...but I have no xp on using Snapshot viewer... this will really make things looks really nice...when a normal user logs in it hides all the Access Window...but when an admin logs in..everything is there...

 

[rahulgty]

Yea sure

you can view directory in this application without maximizing access.

rahulgty

 

[nelson]

yay ! thanks !!! this is very helpful !! will study the code and implement this to my project !

 

[nelson]

yay !!! no more access window!!! muahahaha using Snapshot viewer now!!! *yay* !!! thanks heaps !!!