I am getting a data type conversion error. WHY?
strFld is already of data type DateTime.
strFld = "MEMBERCALLEDDTE"
Set rst = db2.OpenRecordset("tblUNION_UserCallResults")
Do While Not rst.EOF
rst.Edit
rst(strFld) = FormatDateTime(rst(strFld), vbShortDate)...
I am tring to find out when data in a table was last modified. I don't want the details from the properties, because I can go from selecting forms to tables and it records the file as being last modified. I just need to know when data was actually modified within the database itself.
Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.