Exclusive Editing

  • Thread starter Thread starter Ian Rhodes
  • Start date Start date
I

Ian Rhodes

I have a form that is used by multiple users editing fields to assign
that resource to a customer. Can anyone tell me a way of making the
record field exclusive once it has been clicked to stop double
assigning please
 
Ian Rhodes said:
I have a form that is used by multiple users editing fields to assign
that resource to a customer. Can anyone tell me a way of making the
record field exclusive once it has been clicked to stop double
assigning please
Click to expand...

Every form has a "Record Locks" field on the Data tab of the properties for
the form. Try setting yours to "Edited Record" for this form.

AFAIK Access will not lock by field. The smallest entity is a record.

HTH
 
RuralGuy said:
Every form has a "Record Locks" field on the Data tab of the
properties for the form. Try setting yours to "Edited Record" for
this form.

AFAIK Access will not lock by field. The smallest entity is a record.

HTH
Click to expand...

Thanks Rural Guy. I have set the form field to editing lock. I have
tried to design a table based on a spreadsheet so that it can be
pre-programmed quite easily and then added to the table. This however
gives me the problem that many resources can be on the same record
which is a date and time slot x 30 different resources. So all
resources for that time slot will be locked until it has been entered,
but this is a step in the right direction.
 
Ian Rhodes said:
Thanks Rural Guy. I have set the form field to editing lock. I have
tried to design a table based on a spreadsheet so that it can be
pre-programmed quite easily and then added to the table. This however
gives me the problem that many resources can be on the same record
which is a date and time slot x 30 different resources. So all
resources for that time slot will be locked until it has been entered,
but this is a step in the right direction.
Click to expand...

Hi Ian,

Without knowing more about your database it sounds like you might have
committed "spreadsheet" on it. You may want to google for "normalizing"
data. It would probably eliminate this bottleneck.

HTH
 
RuralGuy wrote:
Rural Guy

The spreadsheet option works well to generate the appointments slots
over a 4 week period using fill and copy so it is worth putting up with
the odd chance of someone trying to double book a resource. I may
revisit this at a later date but for now it gets us up and running

Thanks Ian
 
Ian Rhodes said:
RuralGuy wrote:
Rural Guy

The spreadsheet option works well to generate the appointments slots
over a 4 week period using fill and copy so it is worth putting up with
the odd chance of someone trying to double book a resource. I may
revisit this at a later date but for now it gets us up and running

Thanks Ian
Click to expand...

You're welcome Ian. Good luck on the rest of your project.
 
Back
Top