Solved

How do I print & preview an access report

Posted on 2000-05-05
1
169 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 100 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Access 2016 5 54
Access 2016 - query 23 59
how to Classify of email (pdf attachments) 7 36
Archiving Access table older than 6 months 9 39
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

770 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