I have a table in access is the same as table in oracle .
We update oracle tables with this table in access . We want to update oracle table with updated records in access ,not all records be updated . Just those has been changed .
I've added this line in my macro to ask user to input the date. It repeat two times in my macro .!!
I 've changed it many many times .but ... .I have the same code in another database which comes up one time !
could you help me what is wrong ?( the correct date should be 2022-01-01 ...
I really appropriate that.... yes you were right,I saw that ,Access adds a [ ] for table name in the append query sql ..
my problem solve till here .
thank you very much for all helps .I have to study more about VBA debugging..
Yes you are right........ bracket helped ....
the code is working now .. but I don't know how !!!
I tried to test it by append query and it added a bracket for table name in SQL code !!!
I appropriate all your help and advice ...i have to study more how to debug VBA codes ....
This is the sample database .it seems work here ,but when I add the code to my file which has the same structure tables ,I have a syntax error (3131)????
why ????? same code ,same tables??? I lost ....