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

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




More information about the AccessD mailing list