Solved

how to create a report in vb

Posted on 2002-06-18
9
167 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
[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
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

Suggested Solutions

The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…

735 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