Signatures

[adrian]

I am in charge of some stores in my school and it is my responsibility to
make sure that all items are accountable at all times. Before now, we have
used a book which the user signs to acknowledge that they have taken the item
out, and then I have to sign when the item is returned. I have recently tried
to design an access database to replace the book, but am unsure how to have
signatures in the forms, possibly as a sort of password that needs to be
unique for every user.

Thanks, Adrian

 

[Steve Schapel]

Adrian,

The password idea seems like a good one. You could have a table with
the Users and their authorised passwords. When they want to check out
an item, they have to select their UserID and name from a combobox, and
their password into a textbox on the form. The user's authorised
password could be included as a hidden column in the row source of the
User combobox. The password entered would be recorded in the Borrowings
table (or whatever it's called). On the After Update event of the
Password control, you could have code like this...
If Me.Password = Me.User.Column(2) Then
MsgBox "Take Out is authorised"
Else
MsgBox "Invalid password"
End If
.... or some variation on the theme.

Hope this makes sense. There are actually many approaches you could
take to this from a user interface point of view. For example, you
might want to actually cancel the entry of the Borrowing record if a
valid password is notr entered. Or you might want code on the Curent
event of the form, as well as the code suggested above, to toggle the
Caption and/or the colour of a label on the form that says Authorised or
Unauthorised as the case may be. Etc.

 

[adrian]

sorry its been a while but only just really got round to trying it

so far i've got the following code:
Private Sub Password_AfterUpdate()
If Password = "Me.Name.Column(4)" Then
Exit_AddItem_Click:
MsgBox "Issue Authorised"
Else
MsgBox "Invalid Password"
End If
End Sub

so far, whenever i try to use it, it always comes up with the "Invalid
password" message. I have a users combo box with school year, full name,
first name, surname, and signature columns. I also have a table with users
and their signature. The problem is probably with the "Me.Name.Column(4)" as
I don't know what this should be exactly.

Thanks, Adrian