Andy Lacey
andy at minstersystems.co.uk
Thu Feb 8 10:08:19 CST 2007
If it's a bound form then Me.Dirty will tell you if the record is in an edited but not yet saved state. Won't help with the individual fields though. -- Andy Lacey http://www.minstersystems.co.uk --------- Original Message -------- From: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Subject: Re: [AccessD] Visual Basic Form - Check If Recordset/Field Needs Updating Date: 08/02/07 15:35 Hi Paul, I have handled this by binding the Tag property to the same field that the text/value property is bound to. I loop through all the controls on the form and pass the control to a special check revision history process that takes care of the rest. I will send you the code I use offline. Doris Manning Database Administrator Hargrove Inc -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of paul.hartland at fsmail.net Sent: Thursday, February 08, 2007 2:26 AM To: accessd; dba-vb Subject: [AccessD] Visual Basic Form - Check If Recordset/Field Needs Updating Importance: High To all, Firstly my appologies for cross-posting this on the Access site, the reason for this is I haven't seen much (well very very little to be precise) activity on the VB Group. I am after some advice really, basically I would like to know the best way to check if a recordset/field needs updating. Say if a user has a client record in front of them and doesn't make any changes I need to detect this so I don't have to bother to update any recordsets/fields, but if the user does make a change to any textbox/checkbox/dropdown etc I would like to detect this so that : 1. I can update the recordset/field 2. So I can create a log of the record the user changed (plus if possible the name of the field and what they changed it from and to). So any help on this will be appreciated, I have come up with a couple of solutions but the one seems long winded and the other, I just can't get to work quite right. Thanks in advance for any help on this. Paul Hartland -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ________________________________________________ Message sent using UebiMiau 2.7.2