How to Print ms access report

Question

0.00/5 (No votes)

See more:

Hi,

I have created an ms access database that has a report that I want to print using vb.net, I'm a new developer and I don't have the idea of how am going to call that procedure. Kindly help

Thnks..

Posted 22-Feb-12 22:44pm

theMoran

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Slacker007 · Answer 1 · 2012-02-22T23:46:00

Solution 1

My suggestion is to create the report via Visual Studio or a similar tool and pull the data from Access into that report. If you are going to use MS Access, then I recommend that you only use it for a back end database and nothing else.

Posted 22-Feb-12 23:46pm

Slacker007

Comments

theMoran 23-Feb-12 7:21am

Hi,
Thanks for ur response but if am to create the report via visual studio or pull it frm the access dbase how do I go about it?

Slacker007 23-Feb-12 7:30am

Try searching the internet. There are a lot of tutorials and samples. Did you try searching this site for information?

My next question would be, how proficient are you with VB.Net and/or .Net programming in general?

A possible way:

1. Create a data connection layer to access the data from the Access database.
2. Create the report based on the database and connection.
3. Generate the report via your application. Probably you will want the user to provide some filter criteria via your UI.

theMoran 23-Feb-12 8:02am

I'm a newbie in VB.Net though I have managed to develop a small program that can save and retrieve records the major problem am facing is how I will call that object so that a user can be able to view a print report from what has been entered,I hav managed to create a connection to the ms dbase.

I'm still searching this site and others for solutions I will appreciate any links that you may have.

Thanks again for your support

Slacker007 23-Feb-12 8:05am

You could look at the link below, provided by Raimis9.

Raimis9 · Answer 2 · 2012-02-23T00:48:00

Solution 2

Take a look here : http://support.microsoft.com/kb/q145707/[^]

Posted 23-Feb-12 0:48am

Raimis9

Comments

Slacker007 23-Feb-12 7:33am

Good link. I have done Office Interop and Automation for a while now and I have decided not to do it anymore unless I absolutely have to. :)