Form button on click event not trigerring

[Umair.711]

I have four different forms for separate purpose. I create another form that takes employee ID as input. Update other info using button "GetInfo". then save.
Save button finds the id in a table and update the time in E column of that table in front of that ID. The code was working fine when run as macro. But when i change it to form, its just not working. nor giving any error.
its just not going in IF loop. but if I enter an invalid employee id like "a" in textbox1, it says, employee absent today.
EMployee ID format is E1, E2, E3 ....

Please Login or Register  to view this content.

[Leith Ross]

Hello Umair.711,

My best guess is that the object variable rngFound is set to Nothing indicating that what you are looking for was not found.

Have you tried stepping through the macro and checking the variables?

[Umair.711]

Hello Umair.711,

HeMy best guess is that the object variable rngFound is set to Nothing indicating that what you are looking for was not found.

Have you tried stepping through the macro and checking the variables?

hey Leith,

i changed the code a bit and move set rngFound=nothing in else statement. put a msgbox in there to show where it is. but nothing shows up.

Please Login or Register  to view this content.

[Leith Ross]

Hello Umair.711,

You should post a copy of the workbook that I can run myself and troubleshoot the problem.

If your workbook contains any sensitive information, please redact that information before you post.

How To Post Your Workbook

1. At the bottom right of the Reply window, Click the button Go Advanced
2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
4. Click the Select Files button at the bottom middle of the dialog.
5. In the new window Find the file you want to upload, select it, and Click Open.
6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
7. Wait until the file has completely uploaded before you exit the File Manager dialog.

[Umair.711]

well there is nothing in there yet.. I hope there will be, sometime later.

hotel.xlsb

[Norie]

Umair.711

The code is being triggered, so if it's not doing what you want it to then the problem must be in the code itself.

As well as Leith's suggestion of stepping through the code it's probably a good idea to remove/comment On Error Resume Next.

Another thing you might want to look at is what's actually in the variables strDay and day2 and how their values compare to the values on the worksheet you are trying to match them with.

[Umair.711]

Umair.711

The code is being triggered, so if it's not doing what you want it to then the problem must be in the code itself.

As well as Leith's suggestion of stepping through the code it's probably a good idea to remove/comment On Error Resume Next.

Another thing you might want to look at is what's actually in the variables strDay and day2 and how their values compare to the values on the worksheet you are trying to match them with.

I used this code in a simple macro first. And strDay and day2 were working good in macro. But my requirement is for the form. I displayed them and they are proper dates in format MMM/DD/YYYY. The format is same as the format of column A data.

[Leith Ross]

Hello Umair.711,

I corrected several errors in your code. This version ran for me with no problems. Try it out and let me know the results,

Please Login or Register  to view this content.

[Leith Ross]

Hello Umair.711,

I corrected several errors in your code. This version ran for me with no problems. Try it out and let me know the results,

Please Login or Register  to view this content.

[Umair.711]

Hello Umair.711,

I corrected several errors in your code. This version ran for me with no problems. Try it out and let me know the results,

Please Login or Register  to view this content.

Great job. You are a genius.. Thanks (y)

[Leith Ross]

Hello Umair.711,

If you don't have any more questions about this problem or it's solution, I will mark this post solved.