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 ....
I have this small VBA code which is appending data from one table( that is selected in the list ) to other table with the same fields and name.
Private Sub Command2_Click()
sVal = Me.Combo0
sVal = "INSERT INTO OSFinal " & _
I appropriate all your kindly advises.your ideas were helpful to understand what to do with my data .
Since I am new in Access , i have not enough knowledge as you experts.
I am really thankful for your always fast and perfect help.
the function doesn't work properly ,but,Thank you so much , the function DATEADD what i was looking for .I had no clue how to identify records.
I added it to an update query and marked flag to YES ,then I deleted them .