[AccessD] VBA Unbound data entry / update form

John:

IIRC DAO (which I use) does record locking and/or page locking (been a while
since I needed it).  So you get an error when you are the second user to
access a record that's already being  accessed. Real rigorous checking for
update conflicts has never been an issue in my apps.  

Re: field properties and data checking - I just hard code.  Date fields, of
course take care of themselves through the format and/or input mask.  

And usually there are not so many fields that it's easier to just hardcode
the transfer from the recordset to the unbound data fields field by field
and put them back the same way - one sub to load, one sub to write back.
 

Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, May 27, 2008 6:19 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] VBA Unbound data entry / update form

As you folks know, I am a "bound" kinda guy.  However I need to develop an
unbound form to get the data from a record, display it in a form, allow the
user to edit the data, then write the data back to the database.

Since I know some of you have gone through the heartbreak of doing this, I'm
looking for clues on how to approach this.

Do you use an ADO recordset which you disconnect?  How do you perform the
checking to discover if the data has been changed by another user while you
had a record open and disconnected?  Do you attempt to do form level checks
that the user is entering (for example) a date in a date field, integer in
an integer field etc.?  If you do this, do you do so using the field
properties to "discover" what data type or do you just "hard code it"?  IOW
has anyone attempted to "match" controls on a form to fields in a recordset
by using a control naming convention kind of thing?

This sounds like a "class" system.  Does anyone have classes they would like
to share to demonstrate how you go about this?

TIA for your assistance.

--
John W. Colby
www.ColbyConsulting.com
--
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. 
Version: 8.0.100 / Virus Database: 269.24.1/1464 - Release Date: 24/5/2008
08:56