G
GMC -LSND
Using Access 2007 and receiving data from SQL server 2008
Hello all,
I am having problems with a data type mismatch in criteria expression (3464)
error. I am taking an integer value and passing it from one table into a
field that is set as an integer in another table. I then have an access
form with that field in it. I have a double click function on the field that
says (in part) as follows:
If Me!ErrorMsg = "Time Records Wrong" Then
DoCmd.OpenForm "inpTime", acNormal, , "TTIME.TIMEID ="" & Me!TIMEID & """
The records show up just fine, but when I go to open the record it gives me
the error above. I believe the problem is in this part: "TTIME.TIMEID = "" &
Me!TIMEID & """
Can someone straighten me out?
Hello all,
I am having problems with a data type mismatch in criteria expression (3464)
error. I am taking an integer value and passing it from one table into a
field that is set as an integer in another table. I then have an access
form with that field in it. I have a double click function on the field that
says (in part) as follows:
If Me!ErrorMsg = "Time Records Wrong" Then
DoCmd.OpenForm "inpTime", acNormal, , "TTIME.TIMEID ="" & Me!TIMEID & """
The records show up just fine, but when I go to open the record it gives me
the error above. I believe the problem is in this part: "TTIME.TIMEID = "" &
Me!TIMEID & """
Can someone straighten me out?