[AccessD] Unbound Again

All my classes are self-aware! ;) just kidding.  Honestly Martin, JC pointed
out that a bound form locks records, which is the easiest way to ensure
people aren't working over each other.  In VB, it's much easier to create a
self-aware class, because you can create control arrays on the fly, so
hooking a control to a class property isn't much of a chore.

If you are going completely unbound for data entry, you have to look at the
usage.  In a single user environment, no problem.  In a multi-user
environment, you have to create some sort of data checking method.  Lot's of
ways to do that, but it's complicated, and the bound method should be used.

Drew

-----Original Message-----
From: Martin Reid [mailto:mwp.reid at qub.ac.uk] 
Sent: Friday, December 22, 2006 10:50 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Unbound Again

Just out of interest and the reader would find it very informative dont
suppose you have such a self aware class laying about.
 
Martin
 
Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
 
tel: 02890 974477
 

________________________________

From: accessd-bounces at databaseadvisors.com on behalf of Drew Wutka
Sent: Fri 22/12/2006 16:37
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Unbound Again



Depends how you have the background setup.  If you are using a
class/collection structure, you can build the class so that it is self
monitoring for changes.  It also depends if you want to monitor for changes,
or if you just save when the user presses save.

Drew

-----Original Message-----
From: Martin Reid [mailto:mwp.reid at qub.ac.uk]
Sent: Friday, December 22, 2006 7:10 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Unbound Again

Back to the unbound edit

So the idea I am using is to

1. Click The Edit Button
2. Unlock fields
2. Change edit caption to save

So the suer changes one field. Do you just simply update the whole record ot
do you test each field and only chane the one edited? Or is there any issue
with either?

Martin

Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast

tel: 02890 974477


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