Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 174
  • Last Modified:

how to create a report in vb

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
Sankar030999
Asked:
Sankar030999
1 Solution
 
TrueDrakeCommented:
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
 
bobbit31Commented:
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
 
rpaiCommented:
0
Technology Partners: 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!

 
Éric MoreauSenior .Net ConsultantCommented:
0
 
john1811Commented:
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
 
Sankar030999Author Commented:
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
 
Sankar030999Author Commented:
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
 
rpaiCommented:
Sankar, There is a way to split points. You need to ask for help from the moderator.
0
 
MindphaserCommented:
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now