?
Solved

How do I print & preview an access report

Posted on 2000-05-05
1
Medium Priority
?
177 Views
Last Modified: 2013-11-28
I would like to preview and print an access report using VB6 interface.  Thank you for your help.
Chris
0
Comment
Question by:cdesla1
1 Comment
 
LVL 1

Accepted Solution

by:
manchula earned 400 total points
ID: 2783593
The syntax is
AccessObject.DoCmd.OpenReport <"REPORTNAME">,[view type]

Dim objAccess As New Access.Application
Set objAccess = New Access.Application
    objAccess.OpenCurrentDatabase "C:\program files\microsoft visual studio\vb98\biblio.mdb"

'Give acViewPreview to preview the report.
 
objAccess.DoCmd.OpenReport "AuthorReport", acViewPreview


The View Type has 3 options:
acViewDesign
acViewNormal(Default)
acViewPreview


acViewNormal prints the report immediately. If you leave this argument blank, the default constant (acViewNormal) is assumed.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question