Search results

Hello, Im designing a key management system. Basically I have a key table and a keyActivity table. I need a way to manage lost keys. So what I did was add a yes/no attribute called lost_key. Now I don't know how to remove from my keys table the key which was lost. From my research there is no...

I have a keys table and a keysctivity table. I need keys to not be available if they are currently signed out (return_date is null) or if they have been marked as lost (lost_key = true) This is my activity table. http://jumpshare.com/v/6ID9bi?b=D7NY0X If for example signin_id 1 was not...

I have a form/subform. Im trying to set up the button code to add/update records in the subform. Add works fine but when I update it always updates the first record. Here's my code for update: Private Sub cmdAdd_Click() If Me.roomName.Tag & "" = "" Then CurrentDb.Execute "INSERT INTO...

I have a main and subform. I have text boxes in the main form that will allow me to add/edit information into the subform. Add works fine but when I try to edit a record, the information of the selected record shows up in the textbox like I want to but when I try to update, I get datatype error...