Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access 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 August 2nd, 2011, 08:20 AM
Authorized User
 
Join Date: Apr 2011
Posts: 16
Thanks: 8
Thanked 2 Times in 2 Posts
Default ACCESS: Microsoft 2010 RECORD or SAVE

My problem is that a lot of fields in my access database retain the same details
and only 4 or more fields are changed.

I would like to know if I can use some other method whereby I can either modify an existing record or save as a new record with the altered fields and existing fields.

Please Help thanks

Ringo Starr
 
Old August 2nd, 2011, 01:31 PM
gjgriffith's Avatar
Wrox Author
 
Join Date: Jul 2009
Posts: 110
Thanks: 5
Thanked 14 Times in 14 Posts
Default Why not just copy the record?

Hello RINGO STARR,

I saw your post here and wanted to say thank you for posting your question. Specifically, you said:

Quote:
I would like to know if I can use some other method whereby I can either modify an existing record or save as a new record with the altered fields and existing fields.
So, I would suggest just making a copy of the record, modifying the necessary fields, and then saving the new record. Does this make sense? Will this work for your situation?

Please let me know if there is anything else I can do to help!

Thanks,
__________________
Geoffrey L. Griffith
http://www.ImagineThought.com

Wrox Author of:
Microsoft Access 2010 24-Hour Trainer
Access 2010 Programmer's Reference
Access 2007 VBA Programmer's Reference

*** Please click the THANKS button (to the right) if this post helped you! *** ---------------------------------------------------------------------------------------------------------->
 
Old August 3rd, 2011, 05:52 AM
Authorized User
 
Join Date: Apr 2011
Posts: 16
Thanks: 8
Thanked 2 Times in 2 Posts
Default

Quote:
Originally Posted by gjgriffith View Post
Hello RINGO STARR,

I saw your post here and wanted to say thank you for posting your question. Specifically, you said:



So, I would suggest just making a copy of the record, modifying the necessary fields, and then saving the new record. Does this make sense? Will this work for your situation?

Please let me know if there is anything else I can do to help!

Thanks,

Thanks Sir Gjgriffith,

Actually i have this FORM and only the mileage field (record) i changed. but i could not make the report from the previous input instead i erase them. how can i make a report in weekly or monthly basis report? Thanks in advance.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Beginning Visual Basic 2010 and Microsoft Access QIBusinessGroup BOOK: Beginning Microsoft Visual Basic 2010 4 August 3rd, 2011 09:14 PM
Beginning Microsoft VB 2010 Tony1997 .NET 4 and Visual Studio 2010 General Discussions 2 April 3rd, 2011 11:19 AM
Using Access 2010 and Access Services with SP 2010 kmaford BOOK: Professional SharePoint 2010 Development 0 September 14th, 2010 04:25 PM
Microsoft Technologies Take Center Stage at GIDS 2010 rajesh5575 ASP.NET 3.5 Basics 0 April 7th, 2010 02:31 AM
How to save a picture in Microsoft Access Database Edward King Java Databases 0 January 4th, 2006 01:27 AM





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