adammorrisey
New member
- Local time
- Today, 19:05
- Joined
- Nov 20, 2012
- Messages
- 8
Hey guys, I am having trouble here and can't seem to find the problem.
I am trying to add a new record to a table called "SIGN_OUT" Where an employee can sign out a tool from an inventory of tools.
The SIGN_OUT table has the following properties
SignOutID (PK) - autonumber
EmployeeCode (FK)
InventoryID (FK)
ConditionID (FK)
SignoutDate
ReturnDate
After a user logs in using a form and password (storing the employee code as a tempvar)
The user can then use form to select an inventory item from a combo box, select a date in a text box, and choose a condition from a combo box, then when they click submit on the button, it sends the tempvar to employeecode.
It appears everything runs fine, but it doesnt show up in any records on my table, however values in my SignOutID are assigned to whatever I submitted because when I manually start entering values in the table I can see the ID has increased.
Anyways, I attached my database for you guys to get a better look at, and hopefully help me solve my problem, thanks in advanced.
I am trying to add a new record to a table called "SIGN_OUT" Where an employee can sign out a tool from an inventory of tools.
The SIGN_OUT table has the following properties
SignOutID (PK) - autonumber
EmployeeCode (FK)
InventoryID (FK)
ConditionID (FK)
SignoutDate
ReturnDate
After a user logs in using a form and password (storing the employee code as a tempvar)
The user can then use form to select an inventory item from a combo box, select a date in a text box, and choose a condition from a combo box, then when they click submit on the button, it sends the tempvar to employeecode.
It appears everything runs fine, but it doesnt show up in any records on my table, however values in my SignOutID are assigned to whatever I submitted because when I manually start entering values in the table I can see the ID has increased.
Anyways, I attached my database for you guys to get a better look at, and hopefully help me solve my problem, thanks in advanced.
