Recent content by cindyzhou

Thanks a lot for the reply. But it's still doen't work. The only things works so far is the stop and run the query manually. Has anyone ever seen this problem before?

Thanks a lot for the reply. But it's still doen't work. The only things works so far is the stop and run the query manually. Has anyone ever seen this problem before?

Thanks for your reply. But it's still not working. As I said, the SQL statement runs well by itself. It just doens't work when I put it at the end of other VBA codes. I can make a query by the sql statement given before. The query runs OK by itself, but it doesn't work when I use DoCmd Openquery...

Thanks for your reply. But it's still not working. As I said, the SQL statement runs well by itself. It just doens't work when I put it at the end of other VBA codes. I can make a query by the sql statement given before. The query runs OK by itself, but it doesn't work when I use DoCmd Openquery...

I have a problem about running SQL statement in VBA code. I will appreciate a looot if you can help me solve the problem ASAP. I tried to run the following statement in my VBA code to update a table in my database: DoCmd.RunSQL "UPDATE TBL_GRANTBASEDATA, TBL_QUARTER SET...

I have a problem about running SQL statement in VBA code. I will appreciate a looot if you can help me solve the problem ASAP. I tried to run the following statement in my VBA code to update a table in my database: DoCmd.RunSQL "UPDATE TBL_GRANTBASEDATA, TBL_QUARTER SET...