Adding new search box criteria to a user form (new to excel vba )

[sharky1978]

hi all

I was looking for some help, I have a training tracker that I have made following the instruction on a web site, the issue am having is that I can only search for last names, on the user form. I would like to be able to search by first or last name. would I need to add another text box or would I be able to just use the same box that is set up on the user form for searching the last names of the employee.

I would also like to be able to search by training courses as well but I may have followed the instruction for something that is well above me at the moment and I just get lost in all the codes practice makes perfect

any help would be much appreciated

I hope I have attached the file correctly

[dotchiejack]

Hi Sharky,
Welcome to the forum.
I reworked your whole form.
You can search on first name, last name and training.
Have a look at it,try it out.
If you have questions, just ask.

[sharky1978]

thanks dotchiejack

looks great, a few question for you

when I add new training it will assign a new number but if I double click on the name and change the training it will duplicate the id number, I cant seem to find why it is doing this

also can I add a search criteria that will show over due or due within dates for the whole data base, can I use the old code from my first user form and add it to the one you have modified, im new to vba so basic instructions may be helpful

but thanks again for the help

[dotchiejack]

Version number 2
I made a few changes.
Now you can assign a new training to an exsisting employee, a new number will be assigned.
I also added Due date to the search criteria.

Please Login or Register  to view this content.

[sharky1978]

thanks for the help,

i know its a bit cheeky but is there a way to put a button that i can press and it will just bring up overdue training ive been trying but i keep getting error messages. i have taken all the code and macros i tried to use and just added a couple of buttons so you can hopefully see what i mean with overdue and due with in

and the same for due in which i can select how many days as the search criteria and it only brings up the the training due in that amount of days.

again thanks for your help

you made this look easy, i think i may try starting with basics instead of something this big

[sharky1978]

hi all
I am having trouble adding a couple of search criteria's to my training tracker, I am trying to add a search criteria for working out who's training is out of date or is due within so many days, I have added the search boxes but I keep getting an error message in the code,

I think the problem is the helpful guy that done all the work for me has different code and names for the cmd boxes to the original code and names I had copyed/learned to do from a web site and I have no idea where to go

I have not attached another file as the new one I have messed up and it doesn't work any more but the copy above in the thread was the one I cant get to work

could any one help me put the code in or point me in the right direction

thanks