Link to home
Start Free TrialLog in
Avatar of b_yousif
b_yousif

asked on

how can i open an access report in full screen

hi
i wanna ask how can i open an access report from my vb application in a full screen and do know if i can make only the report visible without making all my database visible u know i don't want the user to see my data and entering the data base plz help me
thanx
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image
Add M$ Access Object Library from Reference

Dim ObjAccess As Access.Application

Private Sub Form_Load()
   Set ObjAccess = New Access.Application
End Sub

Private Sub Command1_Click()
   ObjAccess.OpenCurrentDatabase myfilePath
   ObjAccess.DoCmd.OpenReport "my Report Name", acViewPreview
   ObjAccess.DoCmd.Maximized
End Sub

Private Sub Form_Unload(Cancel As Integer)
   ObjAccess.Quit
   Set ObjAccess = Nothing
End Sub

Hope this help
ASKER CERTIFIED SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image
sorry for double post.
Avatar of OJSimpson
OJSimpson
You could use the Access Snapshot viewer.

Programatically export the report as a .snp, then use the snapshot viewer to view the result.