Recent content by mansied

  1. M

    Convert a string to date datatype

    Hello All, I have field as a string 2022-07-06 01:54:44.000 2022-06-10 20:43:59.609 1- I want to remove after space ( 01:54:44.000) 2- change the 2022-07-06 to date format how can I do this in Access query ? Thank you
  2. 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 ...
  3. 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 .
  4. 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 ..
  5. 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 ,...
  6. 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
  7. 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 ...
  8. 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..
  9. 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 ....
  10. M

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

    no, Unfortunately . I have to run my project and stuck to this little part ...
  11. 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 ....
  12. 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 ?
  13. 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.
  14. M

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

    Thanks I cannot open the link
Top Bottom