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 29th, 2011, 12:44 PM
Registered User
 
Join Date: Sep 2007
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default Problem with deleting a record in Access2003

I have an Access2003 MDB database. It includes a delete button with VBA code for the onclick event. The code asks for confirmation of the delete, and if confirmed, it obeys Me.RecordSet.Delete, followed shortly by me.Requery.

Recently, on an increasing number of occasions (but not always), the requery gives an error message "record is deleted". The requery does appear to have worked, and by ignoring the error the program can continue successfully.

Please can anyone suggest what is happening, and why? Surely it is necessary to use requery after delete to get the data upated.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with DoCmd.Printout (Access2003) John Deutsch Access VBA 4 January 22nd, 2008 12:45 PM
Problems In Deleting Record nkrust ASP.NET 1.0 and 1.1 Professional 2 January 12th, 2007 11:52 PM
chapter 6 deleting a record problem mustafa BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 0 November 6th, 2006 12:08 PM
Deleting A Record sirmilt BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5 1 July 31st, 2006 07:12 PM
Confirm before deleting record jgrasso BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 0 March 30th, 2005 12:03 PM





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