Solved

Access Reports

Posted on 1998-11-13
5
162 Views
Last Modified: 2013-11-28
I want to know how I can print or display a report Designed in MSAccess from a VB application.
0
Comment
Question by:gerhd
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 4

Expert Comment

by:CraigLazar
ID: 1444704
Hi
The easiest tool to use is Crystal reports which ships with VB.
What version of VB are you using ?
I have used Crystal Reports for invoices ,statements graphs and statistics it works well
hope it helps
Craig
0
 

Author Comment

by:gerhd
ID: 1444705
I have tried to use crystal reports but as soon as I select information from more than one table with parameters the first set of parameters is cancelled. If possible i want know how to create a sub report in crystal.

0
 
LVL 9

Expert Comment

by:Dalin
ID: 1444706
gerhd,
You have a couple of other choices.
1. OLE automation, requires Access on the machine;
2. Get a third party OCX, like VSReport.

Let me know if you like the code using OLE automation.
Regards
dalin
0
 
LVL 4

Expert Comment

by:CraigLazar
ID: 1444707
Hi
Have you had a look at vb6 ?
Apparently it now has it's own Report writter
0
 
LVL 3

Accepted Solution

by:
fguerreiro_inix earned 50 total points
ID: 1444708
You must add the reference to the library Microsoft Access 8.0.
In that procedure you declare a variable as New Access.Aplication

When you  do that you create a new instance of Access.
Then you should open the database window like this:
inst.OpenCurrentDatabase Reports.mdb ,False

The 'inst' is the variable that olds the instance  of access.

Next step is to open the report:
inst.DoCmd.OpenReport sReportName , acViewPreview

Hope this helps
Regards
0

Featured Post

Ready to get started with anonymous questions?

It's easy! Check out this step-by-step guide for asking an anonymous question on Experts Exchange.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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
Course of the Month10 days, 5 hours left to enroll

623 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