Search results

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

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

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

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 ,...

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

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

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

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

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

yes it worked .thanks

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 ?

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.

Thanks I cannot open the link

Thank you ..I ll test it now to see

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 " & _ "(...

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 .

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