TechnoWeenie
MIS
I'm having problems updating my database and I can't figure out why.
First, I insert a time into the DB. This is the checkout time. This works, no problem.
when the unit comes back I have a check_in_time. This is not working. I'm using the same statement I used to put the checkout time in.
here is my statment for the checkin
strSQL = "UPDATE tblDetailEvents SET check_in_time='" & FormatDateTime(NOW,4) & "' WHERE ID='" & eventID & "';"
When I run this I get the following:
UPDATE tblDetailEvents SET check_in_time='13:07' WHERE ID='15';
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
Both checkout and check_in_time and the same type field, Date/Time. Since I can enter a checkout time You would think that I could enter the check_in_time but I can't. I've tried putting [ ] around the names and it still doesn't work. I've even messed with the type of field I'm trying to put this in (changed it to text or memo, etc.) but still nothing.
First, I insert a time into the DB. This is the checkout time. This works, no problem.
when the unit comes back I have a check_in_time. This is not working. I'm using the same statement I used to put the checkout time in.
here is my statment for the checkin
strSQL = "UPDATE tblDetailEvents SET check_in_time='" & FormatDateTime(NOW,4) & "' WHERE ID='" & eventID & "';"
When I run this I get the following:
UPDATE tblDetailEvents SET check_in_time='13:07' WHERE ID='15';
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
Both checkout and check_in_time and the same type field, Date/Time. Since I can enter a checkout time You would think that I could enter the check_in_time but I can't. I've tried putting [ ] around the names and it still doesn't work. I've even messed with the type of field I'm trying to put this in (changed it to text or memo, etc.) but still nothing.