I have an older program that uses the following:
DoCmd.RunSQL "UPDATE Last_Update_Date SET Last_Update_Date.LastUpdate = Now()"
It works perfectly. But the old app is MDB
I have a new app That is accdb that uses the following:
DoCmd.RunSQL "UPDATE lastEupdateTbl SET lastEupdateTbl.LastUpdate = Now()"
It compiles but give me " You about to update 0 rows etc.
The code comes from the QBO grid and when it runs in there I get the same result.
Checked the names, all ok.
Could find any reference to this on the web.
Thanks is advance.
jpl
DoCmd.RunSQL "UPDATE Last_Update_Date SET Last_Update_Date.LastUpdate = Now()"
It works perfectly. But the old app is MDB
I have a new app That is accdb that uses the following:
DoCmd.RunSQL "UPDATE lastEupdateTbl SET lastEupdateTbl.LastUpdate = Now()"
It compiles but give me " You about to update 0 rows etc.
The code comes from the QBO grid and when it runs in there I get the same result.
Checked the names, all ok.
Could find any reference to this on the web.
Thanks is advance.
jpl