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 May 2nd, 2005, 05:12 AM
Friend of Wrox
 
Join Date: Mar 2005
Posts: 264
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to generate a report using vba ?

I want generate and load the report using vba when a command button is clicked . (automating the report generation)
For example i have table in access that has name, address and email fields and onced command button is clicked the report is
generated and loaded.I be happy if some one show me working example.Thanks

 
Old May 3rd, 2005, 04:48 AM
Friend of Wrox
 
Join Date: Sep 2003
Posts: 155
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to leehambly
Default

Firstly, write the report and then add a new command button to your form... doing this will fire up the "Command Button Wizard"... simply select "Report Operations" and then select your "Report Preview" or "Print" or whatever.





Similar Threads
Thread Thread Starter Forum Replies Last Post
dynamically generate crystal report s_sanks Crystal Reports 0 March 3rd, 2008 07:19 AM
How can i generate report from OLAP cube manoj_k79 Classic ASP Basics 0 January 25th, 2007 12:42 AM
How can i generate OLAP Report manoj_k79 Classic ASP Basics 0 December 15th, 2006 08:28 AM
Generate 1 report for each record in a recordset grobbo61 VB How-To 5 June 23rd, 2006 01:22 AM





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