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
Solved

how to create a report in vb

Posted on 2002-06-18
9
166 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
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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…

809 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