LinkBack URL
About LinkBacks
Your code should check if the user has an entry for that date in the cell & if it has exit the code.
Your code should check if the user has an entry for that date in the cell & if it has exit the code.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Hi roy,
thanks for the idea but how am I suppose to do that? I am new with excel vba. Can you show me how? Thanks
Cheers,
Stoey
I don't know what your existing code is, so I can't tell you how to code it. Post your code or attach the workbook so I can see exactly what you are doing.
Hi roy,
thanks for the quick response. here is the attached workbook. some of the codes there were taken from some of the threads here. Thanks again.
Cheers,
Stoey
Where's the code from, you don't seem to use myarray?
Why are you searching for multiple entries? Do you expect more than one listing for each employee?
assuming you only have unique entries for each employee, this form eliminates the search by using a Combbox linked to a Dynamic Ranged Name containing the employee names. It also uses comboboxes for time entry.
hi roy,
I appreciate the time you spent in checking my test file. Im not sure with regards to the multiple listing. But I want to have the search in any form. I mean the search code is also being used in other part of the program. the file I have attached is a test file. The file I am creating is more than the alloted filesize for attachement. The search code comprise multiple listings for searching . Like I have a part on the program to be used by supervisors only in which they can us the search function to find any data of the employee like Name, ID no or designation. My only problem now is how can I disable the IN and OUT button once the specific user has already a recorded data. Thanks.
Cheers,
Stoey
hi again roy,
I have checked the file attachment you sent but there seem no modifications on the file you attached? Its the same as my sample file.
Cheers,
Stoey
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks