M
myseven123
I am currently working on a database that would act like a ledger tracking
minimal data on existing purchase orders. I am fairly new at this so please
let me know if you need more info.
I have created a form that I want to give different access to various users.
One user will be allowed to add records, one user will be able to update data
(records) on the previous users data, and the rest will have view only status
(which I believe I can control through the network).
My question: How can I lock the existing records after the first user has
added records and then unlock those records when updates are required?
Basically I have four fields that need to be available for updates every time
the second user accesses the form (preferably without the ability to delete
or update the first user’s records).
Brief overview of the Data (fields):
To be locked:
Ref ID (autonumber)
Ref# (text)
Date issued (date/time)
Description (text)
Vendor ID (combo box/subform)
Requester Name (combo box/subform)
To be unlocked at a later time:
Received (Check box - yes,no)
Date received (date/time)
PO amount (currency)
Notes (memo)
Also, there are 2 subforms (vendor ID and requester name) available as a
label on the main form for updating vendor info and names. Not sure how
relevant to my issue but I do need the data from these subforms locked after
the first user adds a new Ref.
Thanks,
Laura
minimal data on existing purchase orders. I am fairly new at this so please
let me know if you need more info.
I have created a form that I want to give different access to various users.
One user will be allowed to add records, one user will be able to update data
(records) on the previous users data, and the rest will have view only status
(which I believe I can control through the network).
My question: How can I lock the existing records after the first user has
added records and then unlock those records when updates are required?
Basically I have four fields that need to be available for updates every time
the second user accesses the form (preferably without the ability to delete
or update the first user’s records).
Brief overview of the Data (fields):
To be locked:
Ref ID (autonumber)
Ref# (text)
Date issued (date/time)
Description (text)
Vendor ID (combo box/subform)
Requester Name (combo box/subform)
To be unlocked at a later time:
Received (Check box - yes,no)
Date received (date/time)
PO amount (currency)
Notes (memo)
Also, there are 2 subforms (vendor ID and requester name) available as a
label on the main form for updating vendor info and names. Not sure how
relevant to my issue but I do need the data from these subforms locked after
the first user adds a new Ref.
Thanks,
Laura