If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Signatures
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 |
#2
|
|||
|
|||
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. -- Steve Schapel, Microsoft Access MVP adrian wrote: 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 |
#3
|
|||
|
|||
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 "Steve Schapel" wrote: 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. -- Steve Schapel, Microsoft Access MVP adrian wrote: 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Security Flaw in Microsoft Outlook and Digital Signatures | [email protected] | General Discussion | 1 | February 18th, 2005 04:26 AM |
How do I set up different signatures for different accounts? | Noelle / Icepc | General Discussion | 0 | February 14th, 2005 04:37 PM |
Signatures | Topgig | Installation & Setup | 0 | February 3rd, 2005 06:51 PM |
Signatures - best practice | Sue Mosher [MVP-Outlook] | General Discussion | 0 | January 23rd, 2005 11:29 PM |
Electronic Signatures | Justin | Setting Up & Running Reports | 0 | August 19th, 2004 06:02 PM |