[AccessD] Visual Basic Form - Check If Recordset/FieldNeedsUpdating

What version of Visual Basic are you using?  The .Net versions do not have a
"Me.Dirty" property so you will have to build your own.  If you are working
with a form bound to a dataset, you can check the "HasChanges" property of
the dataset to help you build it.

Doris

-----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: Visual Basic Form - Check If Recordset/Field NeedsUpdating
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 No virus found in this incoming
message.
Checked by AVG - http://www.avg.com
Version: 8.0.175 / Virus Database: 270.8.6/1766 - Release Date: 11/4/2008
8:26 AM


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com