Hi,
And thanks for replying,
Code:
Me![txtUserId] = GetCurrentUserName()
that particular field Me![txtUserId] is actually text (alphanumeric) as it captures who ever is logged on at that time of the update, (I know its a bad naming convention), but I did not create the tables.:0
Oddly, though my insert Strsql works just fine:
Code:
strSql = "INSERT INTO Attend ( AttStudent, AttDate, AttType, LogOnUser, LastAmendedDate ) VALUES (" & _
Me![scrStudent] & ", #" & Format(TDate, "mm/dd/yy") & "#, " & TypeAttend & _
", '" & Me![txtUserId] & "',#" & Format(Now, "mm/dd/yy h:m AM/PM") & "# );"
So I thought the update should work similarly..Oddly, though my insert Strsql works just fine:
Code:
strSql = "INSERT INTO Attend ( AttStudent, AttDate, AttType, LogOnUser, LastAmendedDate ) VALUES (" & _
Me![scrStudent] & ", #" & Format(TDate, "mm/dd/yy") & "#, " & TypeAttend & _
", '" & Me![txtUserId] & "',#" & Format(Now, "mm/dd/yy h:m AM/PM") & "# );"
So I thought the update should work similarly..
Oddly, though my insert Strsql works just fine:
Code:
strSql = "INSERT INTO Attend ( AttStudent, AttDate, AttType, LogOnUser, LastAmendedDate ) VALUES (" & _
Me![scrStudent] & ", #" & Format(TDate, "mm/dd/yy") & "#, " & TypeAttend & _
", '" & Me![txtUserId] & "',#" & Format(Now, "mm/dd/yy h:m AM/PM") & "# );"
So I thought the update should work similarly..