Access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Currently I have a form that reads from a appended table and pulls in new
records every time the "Next" button is clicked.

My problem is that there may be multiple users using the same database and I
want to avoid the problem of two people pulling in the same record on their
form.

I am assuming the easiest way to handle this problem is through writing code
based on a the "Next" button click. Maybe by creating another table that
contains those records that have been pulled, but not yet revised. Then
having a query that checks that table first before pulling the records from
the appended table.

Does anyone have an example of VBA code that could do this?

Thanks!
 
Could you add a field to the append table "select" and put/mark an X in this
field when that record is selected by the user? Then the form could filter
on "non X" records only.

When a record have been edited, don't for get to remove the "X" when the
record is returned to the table (so that it becomes available again).

Ross
 
Ross,

Thanks so much for your quick reply. I think that would work perfectly. My
problem is that I have very little experience with VBA, do you have any idea
how to approach it? I would have to have the "Next" click uncheck the record
I just finished, check for the next "non x" then apply an "x" to the record
that was pulled. Is this possible with just code or do I have to run any
queries?

Thanks again!
 
. . . I would have to have the "Next"
click uncheck the record I just finished,
check for the next "non x" then apply an
"x" to the record that was pulled. Is this
possible with just code or do I have to
run any queries?
Click to expand...

I am not quite certain I understand all your use of "x", "non-x", and
"record that was pulled". If you could clarify, that would help... for
example, "Records to be processed are identified by a Yes in the Yes/No 'To
be processed' field in the Record. [Multiple users | A single user] will be
processing these records, and when the Record is updated after the user
processes it, the 'To be processed' field should be set to 'No'." This is
the kind of detail that will be helpful... "pulled" is not a term that has a
specific meaning in Access, AFAIK, and you need to be specific.

Larry Linson
Microsoft Access MVP
 
Back
Top