Update Records in Database Automatically

Update Records in Database Automatically

Dinesh Kumar Takyar

5 лет назад

12,918 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@muthalagans6900
@muthalagans6900 - 10.01.2024 12:45

Link is not working..could you share the excel sheet and VBA script?

Ответить
@lsi597
@lsi597 - 27.05.2021 15:51

Can you please provide me link to this excel sheet

Ответить
@hotneil2076
@hotneil2076 - 02.06.2019 08:19

Sir, in Update records code, I am getting Run time error"1004" and when debug highlighting "Cells(Currentrow, 3) = Range("E2")"
Also, I would like to add 20 tasks with multiple cells data against the task, using the main records from (E2 to E8
E2 Name E3 Last name E4... etc main data remains common for all the tasks
Task Name|Planned Start | Planned Finish | Actual Start | Actual Finish | Planned % | Actual % |
Task 1 01-Apr-19 30-Apr-19 01-Apr-19 30-Apr-19 100% 100%
Task 2 15-Oct-19 28-Feb-19 01-Jan-19 05-Apr-19 100% 75%
Task 3 15-Jun-19 30-Jun-19 - - 100% 100%

Ответить
@sirmacademy
@sirmacademy - 09.09.2018 10:34

Hello Sir, I need your help with this problem. I want to insert texts or remarks in a cells with criteria. Just like passed, failed and "data only" if the 2 conditions were not meet.

Ответить
@marioalfredooviedo
@marioalfredooviedo - 06.09.2018 04:35

Dinesh resfriado

Ответить
@bogdanbogdan2943
@bogdanbogdan2943 - 05.09.2018 22:08

Sir, please tell me how can I do this.... But with database în another worksheet? Tkanks in advance!

Ответить
@RahulSharma-oj4li
@RahulSharma-oj4li - 05.09.2018 21:04

Sir plz help me.........the problem is, I have 3 userform 1 userform have search command button option 2nd userform contains employee ID , Emp. Name and D.O.B. , I want first check these 3 conditions in record if these options are true then all detail of employee will show on userform no. 3

Ответить
@SUKANTA_BAGCHI
@SUKANTA_BAGCHI - 05.09.2018 16:47

The voice is quite different ! And the style of explaining is quite changed !!!!!!!

Ответить
@chandraamgain4041
@chandraamgain4041 - 05.09.2018 16:24

Dear sir, i am looking for code that can highlight the selected row when i view the row. Please make video in this point. I found some code but i cant apply new color in cell.

Ответить