blue1914mab
Technical User
I am a beginner at Access, but I am learning.
My database houses patient records and account info. I have full security set up, requiring UserID and password of employees as they log into database. The “frmPatientRecord” displays each individual patients information. I need code that (via. a button on that form) will 1) assign that specific record to the user (based on UserID), 2) change the status of the record, and 3) stamp the current day (short date style). The employee determines what record they would like to be assigned to. Once they have opened the record, they should be able to hit the “Assign” Button.
I have added three fields to the "tblPatientRecord" that deal with assigning the record to and employee. 1) “Assign Date” 2)”Assigned To” 3)”Status”
“Assign Date” – Date field that should be populated with the date the record is assigned.
“Assigned To” – This is a foreign key field related to the “tblEmployee” field “SSN”
"StatusID" -- Foreign key with three options 1)Open 2) Non-Qualify 3)Assigned. The default is "Open". The status should change form Open to Assigned.
I also need for them to be able to select another button on the same form. That does just the opposite. Once the employee has done their part, when they select the “Done” button, it un-assigns the record and puts it back to “Open” status, removes their UserID and stamping the date again.
My database houses patient records and account info. I have full security set up, requiring UserID and password of employees as they log into database. The “frmPatientRecord” displays each individual patients information. I need code that (via. a button on that form) will 1) assign that specific record to the user (based on UserID), 2) change the status of the record, and 3) stamp the current day (short date style). The employee determines what record they would like to be assigned to. Once they have opened the record, they should be able to hit the “Assign” Button.
I have added three fields to the "tblPatientRecord" that deal with assigning the record to and employee. 1) “Assign Date” 2)”Assigned To” 3)”Status”
“Assign Date” – Date field that should be populated with the date the record is assigned.
“Assigned To” – This is a foreign key field related to the “tblEmployee” field “SSN”
"StatusID" -- Foreign key with three options 1)Open 2) Non-Qualify 3)Assigned. The default is "Open". The status should change form Open to Assigned.
I also need for them to be able to select another button on the same form. That does just the opposite. Once the employee has done their part, when they select the “Done” button, it un-assigns the record and puts it back to “Open” status, removes their UserID and stamping the date again.