DoCmd.RUNSQL Insert 1

[cranebill]

DoCmd.RunSQL "INSERT INTO Task_list_History (Select * from Task_list)"

I have this in an on click event. The tables are based on ODBC connection and I tested the actual SQL itself in Oracle and the syntax is correct.

Is there something I am missing?

 

[PHV]

And the problem is ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[cranebill]

Oops...

In access it does not run... so I tried the SQL statement itself in Oracle to make sure it was not a syntax error. In Access it gets an error... #307 I believe.

 

[PHV]

307 is not a valid error number ...
Anyway, for me, the corect syntax is:
DoCmd.RunSQL "INSERT INTO Task_list_History SELECT * FROM Task_list"
provided that Task_list_History and Task_list have the exact same structure.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[cranebill]

Thanks, guess the parenthesis threw it off.