I have used this code before. I copies an pasted it so I don't understand way is does not work.
When I execute it I got no error but nothing updates either. I have added and ending ";" and removed it, nothing. I haved changed the table name then field name by one letter I get an error so I know it at least sees the table and field but no joy on actually doing anything.
The table has only a couple of fields,only one record and no primary key so this should work, and seems to be working fine on another db.
Am I missing something?
Thank you for anything you can do.
When I execute it I got no error but nothing updates either. I have added and ending ";" and removed it, nothing. I haved changed the table name then field name by one letter I get an error so I know it at least sees the table and field but no joy on actually doing anything.
The table has only a couple of fields,only one record and no primary key so this should work, and seems to be working fine on another db.
Am I missing something?
Code:
MySql = ""
MySql = "UPDATE tbl_Report_Info SET "
MySql = MySql + "tbl_Report_Info.Report_Update = " + "'" + Left$(Now(), InStr(Now(), " ") - 1) + "'"
DoCmd.RunSQL MySql
Thank you for anything you can do.