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 April 14th, 2005, 03:50 AM
twt twt is offline
Registered User
 
Join Date: Apr 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to edit report data after previewing report

how to edit data in report using mic.access 2003 after previewing ? it needs to use VBA?thanks

 
Old April 14th, 2005, 05:54 AM
Friend of Wrox
 
Join Date: Nov 2004
Posts: 248
Thanks: 0
Thanked 1 Time in 1 Post
Default

You cannot edit data in a report. A report is display only. If you need to edit data you'll have to use a form.

If you use VBA to display the Preview of the report, you can also display a form that could be used to edit the data.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org
 
Old April 14th, 2005, 06:35 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Build a form using the same record source as the report. If you are passing parameters to the report, pass those same parameters to the form.

You could open the form first, view your data, and once it is the way you want it, generate the report. That way you don't have to open the report, find changes to make, open the form, make changes, then re-open the report.

HTH


mmcdonal





Similar Threads
Thread Thread Starter Forum Replies Last Post
Error on previewing a Report penta Access 7 January 9th, 2006 06:17 AM
Edit field in Cristal report lpastor Crystal Reports 0 December 5th, 2005 07:15 AM
data environment in data report- error?Why myth12345 VB How-To 0 February 18th, 2005 03:08 AM
Login fail Err when view report on Report Server dillig BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 1 July 22nd, 2004 05:31 AM
VB6 Data Report (without data environment) woodie100 Beginning VB 6 1 April 15th, 2004 09:11 AM





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