Search results

  1. M

    Update a table from other table when there is a change

    Yes access table is populating by almost 60 persons ,.then at the end of month,we transfere it to oracle table for reporting on powerbi. So I have no choice ...
  2. M

    Update a table from other table when there is a change

    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 .
  3. M

    Update a table from other table when there is a change

    I don't know which records .. I have a update date trigger to see which records has been updated If I update all records ,Update date doesn't make sense any more ..
  4. M

    Update a table from other table when there is a change

    Thank you , I did this update to update table 2 from table 1 when there is a change in fields but I need just update records was changed . I added inner join and <> in criteria but ,...
  5. M

    Update a table from other table when there is a change

    Hello I have two tables with the same structure and data . I want to have a query to update only records from table2 from table 1 where changed . both tables have the same fields
  6. M

    Ask User to input the DATE in Macro

    Hello 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 ...
  7. M

    Solved Runtime error '3061' too few parameters .expected 1

    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..
  8. M

    Solved Runtime error '3061' too few parameters .expected 1

    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 ....
  9. M

    Solved Runtime error '3061' too few parameters .expected 1

    no, Unfortunately . I have to run my project and stuck to this little part ...
  10. M

    Solved Runtime error '3061' too few parameters .expected 1

    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 ....
  11. M

    Solved Runtime error '3061' too few parameters .expected 1

    I am confused .In Fact , Sval is the name of table which is chosen in a drop list and wants to append its data to a main table . shouldn't it be a string ? the name of the selected table ?
  12. M

    Solved Runtime error '3061' too few parameters .expected 1

    I have a drop list in my from which shows a list of tables .when user chooses one by clicking append wants to append data to a main table(OSFinal) sval refers to the name of selected table.
  13. M

    Solved Runtime error '3061' too few parameters .expected 1

    Thanks I cannot open the link
  14. M

    Solved Runtime error '3061' too few parameters .expected 1

    Thank you ..I ll test it now to see
  15. M

    Solved Runtime error '3061' too few parameters .expected 1

    Hello 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() Dim sVal$ sVal = Me.Combo0 sVal = "INSERT INTO OSFinal " & _ "(...
  16. M

    Update a flag for two month ago

    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. :)
  17. M

    Update a flag for two month ago

    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 .
  18. M

    Update a flag for two month ago

    yes B. Records prior to August 1, 2021 and just two month before not more.(JULY AND JUN )
  19. M

    Update a flag for two month ago

    Month no. is matter not the date.. Filtering is based on month number .all date were updated in process at the beginning the month : 08/1/2021 or 09/01/2021 or 10/01/2021
Top Bottom