[AccessD] VBA Unbound data entry / update form

Charlotte Foust cfoust at infostatsystems.com
Tue May 27 14:52:29 CDT 2008


John,

There's a sample at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Foust,%20Charlotte
called Persisted Recordset Sample Database that does this, except that
it uses a persisted recordset rather than a database.  It might give you
a few ideas, at least.

Charlotte Foust

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




More information about the AccessD mailing list