Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access Reports in VB
- Thread starter jasek78
- Start date
Hi!
Try this.
Sub ViewReport()
Dim ac As Access.Application
Set ac=New Access.Application
ac.OpenCurrentDatabase (Your Path To The DB)
ac.Visible=True 'preview!! (coment if don't want!)
ac.DoCmd.OpenReport "NameOfYourReport", acViewPrevew 'replace with acViewNormal for printing
'ac.CloseCurrentDatabase 'Uncoment for preview!
Regards!
Ales Zigon
Try this.
Sub ViewReport()
Dim ac As Access.Application
Set ac=New Access.Application
ac.OpenCurrentDatabase (Your Path To The DB)
ac.Visible=True 'preview!! (coment if don't want!)
ac.DoCmd.OpenReport "NameOfYourReport", acViewPrevew 'replace with acViewNormal for printing
'ac.CloseCurrentDatabase 'Uncoment for preview!
Regards!
Ales Zigon
- Status
Similar threads
