Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 30th, 2003, 01:29 AM
Registered User
 
Join Date: Dec 2003
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default how to generate reports from access using queries

Hi
I'm a student.I'm using vb6 and access 2000.I want to generate some vb data reports by dynamically passing two parameters.I'm using data reports without data environment.I hvae created queries in access and i can call it through vb.I want to generate reports with group header.is there any option other that shape command
hoping for a favourable reply
thnx in advance
Nebu
 
Old November 17th, 2005, 03:18 PM
Authorized User
 
Join Date: Sep 2003
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Matthew
Default

Use Sorting and grouping to specify how the data will be displayed.
It has some properties you has to set.
Set group header and group footer to yes.

On the design view place your Data on the detail and title on the item header

Good luck!



Quote:
quote:Originally posted by nebujacob2000
 Hi
I'm a student.I'm using vb6 and access 2000.I want to generate some vb data reports by dynamically passing two parameters.I'm using data reports without data environment.I hvae created queries in access and i can call it through vb.I want to generate reports with group header.is there any option other that shape command
hoping for a favourable reply
thnx in advance
Nebu

Matthew Ikechukwu
Email: [email protected]
 
Old November 18th, 2005, 04:59 AM
Registered User
 
Join Date: Nov 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

hi
do u have the solution with u...
my requirement is same as urs...could u pls reply


Quote:
quote:Originally posted by nebujacob2000
 Hi
I'm a student.I'm using vb6 and access 2000.I want to generate some vb data reports by dynamically passing two parameters.I'm using data reports without data environment.I hvae created queries in access and i can call it through vb.I want to generate reports with group header.is there any option other that shape command
hoping for a favourable reply
thnx in advance
Nebu

 
Old November 18th, 2005, 05:11 AM
Registered User
 
Join Date: Nov 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

hi,

Can u Explain the procedure to do it with out using the data Environment and passing parameters to the query

Thanks

Quote:
quote:Originally posted by Matthew
 Use Sorting and grouping to specify how the data will be displayed.
It has some properties you has to set.
Set group header and group footer to yes.

On the design view place your Data on the detail and title on the item header

Good luck!



Quote:
quote:Originally posted by nebujacob2000
 Hi
I'm a student.I'm using vb6 and access 2000.I want to generate some vb data reports by dynamically passing two parameters.I'm using data reports without data environment.I hvae created queries in access and i can call it through vb.I want to generate reports with group header.is there any option other that shape command
hoping for a favourable reply
thnx in advance
Nebu

Matthew Ikechukwu
Email: [email protected]





Similar Threads
Thread Thread Starter Forum Replies Last Post
Crystal Reports migration 8.5 to 11 - SQL Queries? boe_d Crystal Reports 0 May 24th, 2006 07:38 PM
How to generate sequence reports VBA Baby Access VBA 1 May 12th, 2005 06:55 AM
How to generate data reports gandhichirag Pro VB 6 0 July 5th, 2004 08:08 AM
ASP snapshots and reports with parameter queries Yeldarb15 Classic ASP Databases 8 December 4th, 2003 06:36 PM
Generate reports from Listbox Or WhereClause help nkrukovsky Access VBA 1 November 6th, 2003 06:36 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.