Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Picking and un-picking jobs for processing.

Picking and un-picking jobs for processing.

Picking and un-picking jobs for processing.

I am updating a form that is now being used to select jobs for processing. When a job is selected the record is marked with the ID number of the system user.

In some situations a record may be unselected. In this case all the other records that have been selected by the user should be unmarked simultaneously. The user ID field should be set back to zero.

If we open the record set of the form directly we get a Write Conflict.

Any ideas?

RE: Picking and un-picking jobs for processing.

Write conflicts are common when you are trying to both manipulate date using the User Interface and an underlying recordset. There is not much information here. Likely need to provide code and define what it means to select/unselect. I would think you "unselect" a record (after update) and run an update query to set all userID to 0 where the userID = the selected userid.

RE: Picking and un-picking jobs for processing.

This is what did it for me:

Set rscl = Me.RecordsetClone


Do While Not rscl.EOF
If rscl!RedTag = UserID Then
Me.Bookmark = rscl.Bookmark
elBox = Me.ElapsedTimeBox
Me.ElapsedTimeBox = elBox + elTime
Me.RedTag = 0
End If


Set rscl = Nothing

RE: Picking and un-picking jobs for processing.

An additional problem. In some cases I get the following error:

update or cancel without addnew or edit

The error occurs here:

Me.ElapsedTimeBox.value = elBox + elTime

This has only happened when I select a record so a job is processed. If I select one record, then scroll down and select another one, and then go back to the first one to unselect it, that is when I get this error.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close