Solved

how to create a report in vb

Posted on 2002-06-18
9
164 Views
Last Modified: 2010-05-02
i want to create a report from vb. i connect to an access database and i would like to generate some reports based on the user's selection on the form.

how do i go about creating the report from scratch and how can i interface it from vb. im using vb6

Thanks
0
Comment
Question by:Sankar030999
9 Comments
 
LVL 2

Expert Comment

by:TrueDrake
ID: 7090297
Hi,

This can be quite complex. You could hire a professional or you can learn VB and Access, try some code and then come back here if you can't find a solution.

Cheap solution, well maybe!
0
 
LVL 18

Expert Comment

by:bobbit31
ID: 7090323
you can use a data report.

first set up a dataenvironment. (project/more activex designers/data environment)

set up your connection to your access db in the wizard.

then add a data report.  

open up your dataenvironment, add a command and you should see the fields from your table.

you can then drag those on to the data report.
0
 
LVL 5

Accepted Solution

by:
rpai earned 33 total points
ID: 7090344
0
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 
LVL 70

Expert Comment

by:Éric Moreau
ID: 7090421
0
 

Expert Comment

by:john1811
ID: 7091622
Hi,
     You can use Data Report for report generation. You have to pass parameters to data report. The parameter is the user selection on the form. If you need further help revert back

Cheers,
John
0
 

Author Comment

by:Sankar030999
ID: 7105520
hi,
sorry for the late response. Your solns worked fine. But I find that bobbit, rpai and emoreau have all posted almost the same soln. Though I used the url provided by rpai, i donno how i should give the pts...
sankar
0
 

Author Comment

by:Sankar030999
ID: 7105560
hi,
sorry for the late response. Your solns worked fine. But I find that bobbit, rpai and emoreau have all posted almost the same soln. Though I used the url provided by rpai, i donno how i should give the pts...
sankar
0
 
LVL 5

Expert Comment

by:rpai
ID: 7105603
Sankar, There is a way to split points. You need to ask for help from the moderator.
0
 
LVL 6

Expert Comment

by:Mindphaser
ID: 7108327
sankar

I reduced the points to 33 and refunded the rest. you can accept now one experts comment as an answer and post 2 more 33p question for the other experts with a title like : "Points for xxx" and a body "For your help with <URL>".

** Mindphaser - Community Support Moderator **
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

772 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