Hi,
I need your help! I have a good knowledge on Excel and VBA but I'm a newbie on Access.
I'm currently working on a database on Access 2010 where there should be 4 types of users (Admin, Approvers, Inputters, Readers). I've followed the instructions to create a login that worked perfectly (
Creating Login Security using Access VBA | ScottGem's space).
The problems is the following:
Inputters should be able to access "frmTransferFCA" and enter data there. After Inputters finish entering information, Approvers should have access to a button "authorizing" the information. I was thinking about using a simple date stamp after pressing the button. Also, the Inputter should be able to modify the information in the form BUT once the Approver pressed the button Inputters shouldn't be able to modify that record.
I've set "Allow Deletions = No" so records can't be deleted by anyone, and I've also added a check box in the same form so if the transfer is cancelled it won't appear in reports but we would still have the record. This check box should be able to be modified only by Approvers.
I really hope you can help me!
I've tried several options and codings but none of them worked as I needed.
If you have any doubt or you need information please let me know.
THANKS!!