A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Choosing unlocked new record



 
 
Thread Tools Display Modes
  #1  
Old March 2nd, 2010, 05:51 PM posted to microsoft.public.access.queries
rwtrader
external usenet poster
 
Posts: 8
Default Choosing unlocked new record

I am trying in a multi-user environment to have each user able to add data to
the next available, unlocked record. I am thinking this is a query, but not
sure. I am set to share the database with record-level locking. I have a
query that finds the next available record, but when another user runs the
query, it chooses the same record even though another user is entering data.
Obviously it creates an error later, but I want to avoid the error altogether
by having each sequential user that runs that query to enter data on the
next, unlocked (unused) record. Can anyone help? I am not sophisticated in
Access, so the simpler the solution, the better...thanks!
  #2  
Old March 2nd, 2010, 08:45 PM posted to microsoft.public.access.queries
Jerry Whittle
external usenet poster
 
Posts: 4,732
Default Choosing unlocked new record

Are these records actually new or records already created and needing
updating or something?

If already there, I'm assuming that there's something in the query that
looks for a field which shows the record complete or something. If someone is
working on the record, but it isn't complete yet, that field will be open or
something and the query will pick on it. You may have to immediately save the
record with the field in question populated to stop this from happening.
However if someone opens the record then changes their mind, you may have a
problem with records getting skipped over.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"rwtrader" wrote:

I am trying in a multi-user environment to have each user able to add data to
the next available, unlocked record. I am thinking this is a query, but not
sure. I am set to share the database with record-level locking. I have a
query that finds the next available record, but when another user runs the
query, it chooses the same record even though another user is entering data.
Obviously it creates an error later, but I want to avoid the error altogether
by having each sequential user that runs that query to enter data on the
next, unlocked (unused) record. Can anyone help? I am not sophisticated in
Access, so the simpler the solution, the better...thanks!

  #3  
Old March 4th, 2010, 01:31 AM posted to microsoft.public.access.queries
rwtrader
external usenet poster
 
Posts: 8
Default Choosing unlocked new record

This helped a lot. My solution was not too eloquent. I made a query that
found the next record in the series and then I used SetValue on the form to
populate a field, had it go to a new record and then back to the record in
question. That caused the next person to run the query to look to the next
record because the query thought that one was already populated. If you have
a better solution I am all ears...this one seems a bit clumsy to me.

"Jerry Whittle" wrote:

Are these records actually new or records already created and needing
updating or something?

If already there, I'm assuming that there's something in the query that
looks for a field which shows the record complete or something. If someone is
working on the record, but it isn't complete yet, that field will be open or
something and the query will pick on it. You may have to immediately save the
record with the field in question populated to stop this from happening.
However if someone opens the record then changes their mind, you may have a
problem with records getting skipped over.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"rwtrader" wrote:

I am trying in a multi-user environment to have each user able to add data to
the next available, unlocked record. I am thinking this is a query, but not
sure. I am set to share the database with record-level locking. I have a
query that finds the next available record, but when another user runs the
query, it chooses the same record even though another user is entering data.
Obviously it creates an error later, but I want to avoid the error altogether
by having each sequential user that runs that query to enter data on the
next, unlocked (unused) record. Can anyone help? I am not sophisticated in
Access, so the simpler the solution, the better...thanks!

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:01 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.