[AccessD] VBA Unbound data entry / update form

John:

Won't dbPessimistic in the LockEdits parameter of the OpenRecordset do what
you need to have done with regard to multiple users attempting to edit the
same record?

dbSeeChanges may also bee what you need.  From the help:

Use the dbSeeChanges constant in a Microsoft Jet workspace if you want to
trap changes while two or more users are editing or deleting the same
record. For example, if two users start editing the same record, the first
user to execute the Update method succeeds. When the second user invokes the
Update method, a run-time error occurs. Similarly, if the second user tries
to use the Delete method to delete the record, and the first user has
already changed it, a run-time error occurs.

Typically, if the user gets this error while updating a record, your code
should refresh the contents of the fields and retrieve the newly modified
values. If the error occurs while deleting a record, your code could display
the new record data to the user and a message indicating that the data has
recently changed. At this point, your code can request a confirmation that
the user still wants to delete the record.

HTH


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 1:05 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] VBA Unbound data entry / update form

LOL, I do want to do a lot with an unbound form.  It should open a record,
display that record, allow it to be edited, and save the record back again
once edited, all without corrupting data, honoring data saves before it
saves etc. 
Bound forms do all of that, and the unholy alliance of unbounders have
always indicated that they could also do all of this stuff.

Now I need to do all that stuff and just thought those UAU members would
have their expertise to share.

8-0

John W. Colby
www.ColbyConsulting.com


Drew Wutka wrote:
> LOL.  Sorry, JC wants to do a lot with an unbound form.  I don't have 
> a preset class to handle that.  Also, I tend to make web or VB 
> interfaces, so I don't use unbound Access forms very often.
> 
> Drew
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow
> Sent: Tuesday, May 27, 2008 12:13 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] VBA Unbound data entry / update form
> 
> OK, sorry for the diversion, back to the topic. 
> 
> Drew, help my poor fellow bounder out, eh?
> ;o)
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> 
--
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/1469 - Release Date: 27/5/2008
13:25