[AccessD] Visual Basic Form - Check If Recordset/Field NeedsUpdating

Jack and Pat drawbridgej at sympatico.ca
Tue Mar 3 07:22:26 CST 2009


Paul,

I think you are looking for the Me.Dirty that shows if a change has been
made.
You may wish to confirm this on Help.

Jack

-----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





More information about the AccessD mailing list