Multi Page Userform - Employee Database
HTML-код
- Опубликовано: 6 июн 2024
- www.onlinepclearning
Multi Page Userform - Employee Database Project. We will be creating a multipage userform that will also have the functionality to edit delete and add new data. This video deals with the creation of the Userform in our VBA Editor.
Glad you didn't just include a link for the final version. Means we've all had to do the hard work!
Trevor, thanks so much for all the videos and tutorials. Awesome work and your steps are very easy to follow. I've adapted a few of your templates to fit my own needs and every single one of them work great. Again, thanks so much!
+Nicholas White
Thanks Nicholas,
Appreciate the feedback.
Best wishes
Trev
Dear Trevor,
This is truly a piece of art. I've been playing and pausing your tutorials over and over a trillion times and learnt a lot! Thank you so much. I'm glad I had to put all the coding and user controls in myself rather then copy/paste from your website. I've adjusted the form to my needs without much trouble.
I would like to add a bit more and hopefully you can help me with that as I cannot figure it out myself (been trying for days now)
All the rows in my database have a Status (Active, Stopped, Draft, Inactive) I would like to add these in option buttons (and 1 button for All) so that when the user searches for a particular (let's say city) and option Active was selected it would only show lines from that search with Status Active. Small note: Active would be the default.
Hopefully you are able (and willing) to guide me with this so I can proceed with this userform. Anyhow...thanks again for sharing your time and insights on your channel/website.
Thanks Trevor for this valuable information.
Thanks Trevor - this is really useful.
Thank you for the effort.
Awesome tutorial trevor...learnt a lot...
Very useful,
Thank you Trev
Thanks for sharing your knowledge
HI Trevor,
Where I can find the lessons previous to this videos?
Thanks,
Ramon
Thanks very much _Trevor, you are helping me so much!!!!
Thanks again!!!!
Hi Edgar,
Thanks for the positive feedback.
Trev
Hi Trevor. Great work are there any more projects in the pipeline?
Thank you very hard and your next videos.
Great work
Hi Trevor. Thank you ever so much for the valuable videos. I were wondering if you have a solution to checkbox overlapping when filter applied in excel?
thank u really good and very useful thank you sir
Trevor... can you advise me on how I get the template etc. I would love to follow along but do not seem to be able to find a link to the template etc. Thanks. Your courses are amazing! MozZ ;-)
thanks for this important tutorial
Appreciate your feedback.
😊
Which video is the first in this series? Can you share the link? Thank you.
how can avoid duplicity.... i use one text box and one combo box( i.e Date & shift ( A,B,C) if Data available (suppose 12/8/2017 & shift A) it will give error msg...but when i type 12/8/2017 Shift B...data will store in sheet 1)
great learning way
Hello Trev, is it possible to provide us with the complete userform? Graphics plus appropriate code? (not just the initial template) Then we can follow the rest of the tutorials. Many thanks for your tutorials.
Excllent Job,
Trevor Easton, please when I got to the rowsource and I entered colHeaders there is always an error that could not set rowsource. invalid property value. please could you please help me out
Hi Trevor, this is Razak. I had problems with the rowsource for the combo box. there's an error that could not set rowsource. invalid property value. please could you help me out
hello there trevor, i appreciate your tutorial a lot, i only have 1 question... when i try to run the contact in the userform there is an error box that pops up saying COMPILE ERROR: METHOD OR DATA MEMBER NOT FOUND from the vba code page where you type all the codes... can you help me try to fix this error. appreciate your kind response.
Can i get the template which you have created in this Video?
Hi I'm Momin from India, big fan of your work. I wish to add three fields extra. These are
1. Employee picture
2. Employee signature
3. Export filter file to another excel file. Please
Hi Trevor, I like your videos a lot, I have developed several Projects taking as a model some of your videos, in fact I am using a big Userform Interface for the company I am working currently....
I currently involved in a big project and I want to know if it is possible to open one instance of Excel if the workbooks belongs to my macro, but if is NOT then open a different instance.... in another words it is like I have two independent Excels:
One for my macro (it allows only the files that I open using my macro), and the...
Second Excel only for the workbooks I try manually open that do not belongs to my macro.Any comment I will really appreciate... Sorry but this one is the only way I found to ask you this concern.
What is the VBA code to high light the list box data based on conditions
Great work!, this tutorial saves a lot of my time for research! just need to know where is the part 1 where I can setup the sheets where the data will be stored. Thanks!
Hi Knych,
You will find the template here.
www.onlinepclearning.com/excel-advanced-filter-employee-database/
Thanks Trevor!, I did the Advance filter with the "*" to automatically give me the results, however it does not give any results. I am using both 2016 and 2007 to test my project, It would be really great if the wildcard search will work as I do not have to make differnet search combinations. Thank you!
Very good work.
God bless you.
Please sir, how did you add a picture of you interface
Sir, I cant Change the row source in combobox search to ColHeaders. its telling me that Invalid Property Value.
Thanks In Advance for your reply. This Is a great help. Thanks again.
I have the exact same problem. Can anyone help?
Thanks for this, its giving me an idea. But I want it to make simple and I'm doing it in activex controls. Is there a code if I use it in activex controls? And theres a way that can I view multiple sheets in one listbox but view one at a time using command button.
Is there an email address where can I send my project?
Hi Geno,
All Userform controls are active X controls.
You may be able to change the row source for your Listbox with a command button. You could view data on different sheet this way.
Best wishes
Trev
+Trevor Easton
I mean I want to do it in worksheet instead of userform cause userform has limited size. And I tried it in sheet, get contact and clear button are not working error 438. By the way Thank!
+Trevor Easton
Is there a simple code for get contact? Without combobox.
Good afternoon sir.
Please can you kindly let me know how you begin the first step to create the excel before the userform and codes
Merci beaucoup
thank sir
Hi Trevor, The template download link no longer works.
Hi Scott,
I checked and it download.
Trev
Hi Trevor, It must have been my computer. All is well now.
Great tutorial yet again Trevor!
Cheers
sir i have problem in combo box
Hi Trevor, thanks so much for all the videos and tutorials.
I will try to do 24 columns in add employee then I got an error like this Error 438 (Object doesn'ssupport thispropery or method) in procedure cmdClear_Click of Form EmployeeDB so please give a solution for this error.
Hi.
sir I need your help.
Ahh Found it... Cool
Software's name
sir how to get code for edit and delete
You need to go to the website..
www.onlinepclearning.com/edit-and-delete-from-a-userform/
How to make it make complete video
There are several video for this tutorial.
Trev
Can u pls gv the vba code?
Code is here
www.onlinepclearning.com/multi-page-userform-employee-database/
I think Access i a hero for this type of projects not Excel
I got nothing
hey i have found your one
What is the use for this video without coding
My son 3 years old can do same
hey please give me the template
Can i get the template which you have created in this Video?