HomeОбразованиеRelated VideosMore From: PRADEEP S

How To Create A Simple Database In Excel (VBA)

1441 ratings | 874543 views
How To Create A Simple Database In Excel (VBA)
Html code for embedding videos on your blog
Text Comments (321)
01worldguy01 (1 month ago)
as long as I clear my ears in the morning this is useless I DO OT CARE IF YOU DO AVE ACCENT .. just talk !
Sidheek Sabeelas (2 months ago)
It's very gud an useless😁
Laura Jankevicha (2 months ago)
This new version lastest working the program required microsoft visual сс+2017.it is not excluded оthey call a error for running.This link has a 100% working software https://yadi.sk/d/KYY2D1Uy3KF5JV
Помог
Nadine McLaren (3 months ago)
Don't see the point of this video if you don't talk as you are working so as to make clear, plus you are moving too fast to see what is to be done. Music does nothing for this video. Waste of time.
Md Salim Hossan (3 months ago)
in bangla
NAVEEN SANAI (4 months ago)
Guуs I just fоund free $6702.this аwеsоmе cash gеnеrаtоr:(just go to) makepplmoney.win/?jdX6Qc its working
Rahulraj Sahoo (4 months ago)
So nice video please make 1 video from NNTLC work ok thanks
Jackpot Lucky Winner (5 months ago)
Cantect no to discrimination me dalo
Tanker Foundation (6 months ago)
Hi i created the database, but when i entered and click new it is not saving the data.could you help me to sort out this
Abdulsatar Sultan (6 months ago)
thank u
Jorge Goncalves (7 months ago)
video is not clear and very bad focus
mybikerlady1 (7 months ago)
Music is terrible, I will like in a notepad the instructions
PRADEEP S (7 months ago)
How to Create A Simple Database with Image in Excel (VBA). Click the below link to see the details https://youtu.be/VnT9SA1tLtA
Ferdinand Galut (7 months ago)
http://greatjob.online/?refer=17002
spiros pikoulis (7 months ago)
Hi Pradeep. Many Thanks for this great video. I have an issue!!! I have followed your steps with a small difference instead of Empl.No I use Empl.Name. So when I'm doing a search, I am only able to see 2nd row details only and if I select the 2nd or 3rd name from the list the details won't change. I would appreciate your Help
ankan bera (8 months ago)
"Save" command key not working and also it's not highlight what can I do sir?
Jezreel Gomonit (8 months ago)
very educational thank you for sharing
Abhi FLAMES (8 months ago)
Guys I swear I just got free $6452_real money from this_amazing website>>>>freepplmoney.win/?ti1GkY Try once.
NIKHIL GALA (8 months ago)
Please let me know how can I correct it
NIKHIL GALA (8 months ago)
I have make this user form but it not compile correctly it was an error show that compiler error Sub or function not defined
NIKHIL GALA (8 months ago)
I have problems with code
Mon Gibsson (9 months ago)
SMARTER MONEY 2018- 100% NEW METHOD MAKING MONEY SYSTEM,..........newbie friendly, no need previous experience, Just Search Google it, *DOLLARINCOMEIDEAS. COM*
Star Ch3f (10 months ago)
Guуs I just fоund this аwеsоmе cash gеnеrаtоr:(just go to) freepplmoney.win/?4HWaX9
Md. Afzal Ansari (10 months ago)
plzz sir give me this file send my mail address [email protected]
PRADEEP S (10 months ago)
Click the below link to download excel file https://app.box.com/s/edvcreaxo4g89ys4j8wbh8a60c47zutl
Shivamurthy Sp (10 months ago)
Codes Not av
yoeung punnlok (11 months ago)
Do have code update or edit on your soft code, if you have pleas sent me the code Thank you!!!! email : [email protected]
Product Training (11 months ago)
please help it is only showing the first information when you click on search and even if I search the rest of the information it will always show the data for the 1st row how to resolve it
Ravi Thakur (11 months ago)
please provide me the template file [email protected]
PRADEEP S (11 months ago)
Click the link to download the excel file https://app.box.com/s/edvcreaxo4g89ys4j8wbh8a60c47zutl
mykum online (11 months ago)
Hello sir. I want to create a form that will ask my students to insert their exam number and the app will look for it, if the number found in the list in excel will display CONGRATULATIONS YOU HAVE BEING ADMITTED Name: Institution: Course: Duration: If not found it'll display SORRY...... NOT YET ADMITTED help me with video tutorial please and please. I want to do it completely in MS Excel
MACROS EN EXCEL (9 months ago)
hi , i can help you , send me and e ail to [email protected]
PRADEEP S (11 months ago)
Click the link to download excel file https://app.box.com/s/edvcreaxo4g89ys4j8wbh8a60c47zutl
ShaNi Jan (11 months ago)
Ary Hamri Koi Help Kr da
PRADEEP S (11 months ago)
Click the link to download excel file https://app.box.com/s/edvcreaxo4g89ys4j8wbh8a60c47zutl
simply Super
yoeung punnlok (11 months ago)
Can you Add Button or code Edit in this database sent to my mail = [email protected], God Bless you
yoeung punnlok (11 months ago)
can you give me this soft , thank big big email = [email protected]
PRADEEP S (11 months ago)
Click the link to download excel file https://app.box.com/s/edvcreaxo4g89ys4j8wbh8a60c47zutl
yoeung punnlok (11 months ago)
Please Reply me ..........OK
Mukesh Raikwar (1 year ago)
plzz sir give me this file send my mail address [email protected]
PRADEEP S (11 months ago)
Click the link to download excel file https://app.box.com/s/edvcreaxo4g89ys4j8wbh8a60c47zutl
Kedar Bhoir (1 year ago)
Runtime error '5"? invalid procedure call or argument? For the following code... Plz tell me what to do? (also tried if strFile <> "" then) If strFile <> False Then Sheet1.ExportAsFixedFormat _ Type:=xlTypePDF, _ Filename:=strFile, _ Quality:=xlQualityStandard, _ IncludeDocProperties:=True, _ IgnorePrintAreas:=False, _ OpenAfterPublish:=True End If
Ajay Pal (1 year ago)
Please send me while project for customer details
Fourth Mithree (1 year ago)
Thank you a lot for this sir. Can you send me the entire project please? I badly need it. thank you. [email protected] Thank you in advance
PRADEEP S (11 months ago)
Click the link to download excel file https://app.box.com/s/edvcreaxo4g89ys4j8wbh8a60c47zutl
Monal Yuwanati (1 year ago)
i want know how generate automatic unique id or number for each new entry
janez novak (1 year ago)
Very good tutorial, thank you
NIKHIL GALA (1 year ago)
This is the best video for learning code
i am also a ms excel developer i m created a database for my institute "Unique Computer Center" it is very senstive file
Incredible tutorial man i'm very glad i follow every step but i think you missed a cmdSave.Enabled = True in the cmdNew menu you did it at your attached file but not in the video so iwas getting an error. but now is ok.
Vergelio Blaze (1 year ago)
mine too please [email protected]
Winsley Frichot (1 year ago)
can you please share updated file with us my email is as follows [email protected] - thks
Training Video (1 year ago)
Thanks for such informative tutorial
Tamilan raam (1 year ago)
"G" how can i add image file pls source code image file
leticia cardozo (1 year ago)
Can you sent me the transcript to my email [email protected] Thank you.
PRADEEP S (11 months ago)
Click the link to download excel file https://app.box.com/s/edvcreaxo4g89ys4j8wbh8a60c47zutl
vicky karep (1 year ago)
minta script nya gan
Tamilan raam (1 year ago)
want to upload a pic and it should be shown in the same template.so please help me to add ONE MORE template in the same fiels emp details
Tamilan raam (1 year ago)
I NEED ONE MORE TEXT BOX HOW CAN I ADD
Shah Zaidi (1 year ago)
can u send me his coding plz
PRADEEP S (11 months ago)
Click the link to download excel file https://app.box.com/s/edvcreaxo4g89ys4j8wbh8a60c47zutl
saravanan n (1 year ago)
If strFile <> False Then Sheet1.ExportAsFixedFormat _ Type:=xlTypePDF, _ Filename:=strFile, _ Quality:=xlQualityStandard, _ IncludeDocProperties:=True, _ IgnorePrintAreas:=False, _ OpenAfterPublish:=False End If ---------------------------------- runtime error '5"? invalid procedure call or argument?
Please write If strFile <> "" then 'same as above end if
Nicholas Mawuli (1 year ago)
i can't download to study
PRADEEP S (1 year ago)
Please check the example file https://app.box.com/s/edvcreaxo4g89ys4j8wbh8a60c47zutl
Nusrat Ali (1 year ago)
WhenI click on the student details button and Exit button on the work sheets it does not pick up the file
Nusrat Ali (1 year ago)
hi Pradeep I done the coding but when I run the app this error comes Private Sub cmdform_Click() frmstudentdetails.Show End Sub
please give your userform name frmstudentdetails
Ferdeen Shah (1 year ago)
i already create form but i could not enter formula ...please help me on this
PRADEEP S (11 months ago)
Click the link to download excel file https://app.box.com/s/edvcreaxo4g89ys4j8wbh8a60c47zutl
PRADEEP S (1 year ago)
Please check the example file https://app.box.com/s/edvcreaxo4g89ys4j8wbh8a60c47zutl
My Garden (1 year ago)
Please use music and educational videos and speak speak speak speak, Please speak speak speak speak, Please speak speak speak speak, Please speak speak speak speak, Please speak speak speak speak, Please speak speak speak speak, Please speak speak speak speak, Please speak speak speak speak, Please speak speak speak speak, Please speak speak speak speak, Please speak speak speak speak, Please speak speak speak speak, Please speak speak speak speak, Please speak speak speak speak, Please speak speak speak speak, Please speak speak speak speak, Please speak speak speak speak, Please speak speak speak speak, Please speak speak speak speak, Please speak speak speak speak, Please speak speak speak speak, Please speak speak speak speak, Please speak speak speak speak, Please speak speak speak speak, Please speak speak speak speak, Please speak speak speak speak, Please speak speak speak speak, Please speak speak speak speak, Please speak speak speak speak, Please speak speak speak speak
Sidheek Sabeelas (2 months ago)
⛷️⛷️⛷️⛷️⛷️⛷️
it is very simple video it had no needed of speaking u can understand by notepad test file
Jeffrey Biz (1 year ago)
CAN ASK IF I CAN DO THESE ON MY SELF AND CAN YOU HELP ME? THANKS
PRADEEP S (11 months ago)
Click the link to download excel file https://app.box.com/s/edvcreaxo4g89ys4j8wbh8a60c47zutl
Steven Philp (1 year ago)
Please could you explain how Print Screen works. i.e. where is the data pulled from? i'd like to change the format of the PDF :)
Steven Philp (1 year ago)
This is great! I would like to adopt the database but to include a date field.... I tried to do this myself but the dates formats are causing me problems. ANy assistance would be great!
Andrius Žilėnas (1 year ago)
More useful to be putting link to download the example file into video description
Andrius Žilėnas (1 year ago)
consider putt link to video description
PRADEEP S (1 year ago)
Please check the example file https://app.box.com/s/edvcreaxo4g89ys4j8wbh8a60c47zutl
Archie Balatucan (1 year ago)
Good Day @PRADEEP S , can you help me how to create a button to move the data from data sheet1 to sheet2? thanks in advance bro. Godbless!
kclaire56 (1 year ago)
what the hell is going on here??????
Claire Lee (1 year ago)
this tutorial is better than other tutorials given. Just appreciate that you're learning for free.
Hadi Saputra (1 year ago)
how to add scroll bar in data input
yashveer giri (1 year ago)
But sir example file doesnt have any clue about it..plz tell me what should be change in code, if you can Thanks
Ashu Tosh (1 year ago)
hello sir, in this tutorial in last your save command was not enabled. so can you tell me how to enabled save command because its not working
PRADEEP S (1 year ago)
Please check the example file https://app.box.com/s/edvcreaxo4g89ys4j8wbh8a60c47zutl
Ali Al Sherify (1 year ago)
Brother,,, many thanks for video.. one question.. can you pls explain to me what you do on video time 8 :48
Hi, Awesome tutorial and easy to follow, BUT @ 28:11 in the video after ive done the same procedures and same coding, i receive an error "run-time error 7: out of memory. I'm Using excel 2016 on a I7 laptop win10. Is this a programming error?? Thanks again.
PRADEEP S (1 year ago)
Please check the example file https://app.box.com/s/edvcreaxo4g89ys4j8wbh8a60c47zutl
Ravi Shankar (1 year ago)
Hi this is really helpful but download file allow only pdf how to see excel sheet is that hiden?
PRADEEP S (1 year ago)
Click below link to download excel file: https://app.box.com/s/edvcreaxo4g89ys4j8wbh8a60c47zutl
Archie Balatucan (1 year ago)
Good Day @PRADEEP S , can you help me how to create a button to move the data in data sheet to another sheet? thanks in advance bro. Godbless!
Vasant Khajindar (1 year ago)
ACTUALLY PLEASE PROVIDE ME DATA FORMATION IN THIS WORK OUT
PRADEEP S (11 months ago)
PRADEEP S 4 months ago Please check the example file https://app.box.com/s/edvcreaxo4g89ys4j8wbh8a60c47zutl
abdul nizar p p (1 year ago)
hi PRADEEP S, Please help me how to print user form landscape mode
Sol mag (1 year ago)
Hello, I am following this tutorial and I got stuck at 18:36. I am getting an error message after the green line. When I typed in the next line, I'm getting a compile error. Expected: List separator or ). I typed in exactly what you have and I don't know why am getting that. Please help. Thanks
PRADEEP S (1 year ago)
Please check the example file Click below link to download the example file https://app.box.com/s/edvcreaxo4g89ys4j8wbh8a60c47zutl
Sandeep Verma (1 year ago)
can this database run without ms-excel
KHART BOLINA (1 year ago)
Pradeep S example same Employee Code not error ex. Emp1 khart Code 1 Emp2 john code 1 not working how to fix ? thanks advance Please send to our Gmail [email protected]
Susana Ragas (1 year ago)
can I imitate this on excel 2010?
PRADEEP S (1 year ago)
Yes, but save as .xlxm in Excel 2007, 2010, 2013 & 2016 (Macro enabled workbook)
Santos Sotero (1 year ago)
THANK YOU SO MUCH
Jai Sam (1 year ago)
Hi PRADEEP S, Please help me how to add employee picture with this coding
Jenario De Guzman (1 year ago)
Is there anyway that I can integrate a Copy/Insert Command Button here ? Like when I clicked Search and I want it to Copy from a Worksheet to another Sheet (in the same Workbook) ? Please teach me. Thanks.
Babu Rao (1 year ago)
i want to upload a pic and it should be shown in the same template.so please help me to add that template in the same fiels emp details
hay its working... thnx a lot pradeep... keep it up
laxmi reddy (1 year ago)
Mr.Pradeep sir i also encouter problem to save the data base . when i enter the data save button is not working you showed this in this video but i couldn't understand what you have done for this pls help me sir
laxmi reddy (1 year ago)
what did u done as last point to save the database. that i couldn't understand
Danish Bedi (1 year ago)
can u give me the code that u r using in this video... thank you in advamce
PRADEEP S (1 year ago)
Click below link to download the example file https://app.box.com/s/edvcreaxo4g89ys4j8wbh8a60c47zutl
Eye of the Tiger (1 year ago)
And I advise to talk , I hate Tutorials and nobody talks ! terrible
Marco Bianchera (1 year ago)
Very good.. but i have a problem.. i can't insert a photo from my webcam, for every employee registration. Any suggestion?
FHM Realty (1 year ago)
Sir. how to get rid of this Compile error Variable?
Krishna limbu (1 year ago)
Wow very Nice . How to learn basic langues >? Plese tell me sir
Yohannes Almaw (1 year ago)
THANK YOU SO MUCH FOR YOUR USEFUL TEACHING. BY THE WAY CAN YOU USE AUDIO TO EXPLAIN YOUR WORK? I KNOW IT IS VERY TIRESOME BUT IF YOU DO THAT , YOU CAN REPLACE OUR PROFESSORS AND WE CAN LEARN A LOT REALLY EASILY
Yi You (1 year ago)
I follow exactly the same, but noticed that when i click on the "Emp Details - Entry" on the first excel file, system prompt me error 424. as in "frmEmpDetails" not found. Any idea?
Yi You (1 year ago)
The 2 excel that you show actually all sit in the same excel file is it? because i split into 2. So now i combined them in to 1, still i have error at "Private Sub UserForm_Initialize() Compile error: Method or data member not found" Any Idea??
RAM RAJAN (1 year ago)
Very good project pleas send our mail id [email protected]
roma rabino (1 year ago)
Mr Pradeep, After you enter the name "Thomas Axen", you highlighted the name and put the cursor below and suddenly the "save" button activate...how did you do dat?
roma rabino (1 year ago)
Hi Mr. Pradeep, After you click "New", where did the data go?is it in "Data" sheet? if it is, then, my coding is incorrect because I cannot see any information to that sheet..or, should I click the "Save" button? but the "save" button is not working... And also, the sheet that you renamed "Data", is the informations i.e EmpNo.,EmpName, etc were automatically link to their or you type it manually? Please Help!
Magdiel Adames (1 year ago)
I will be doing some youtube livestream on userforms. I could be able to answer some of your questions.
SHAAN SHRESTHA (1 year ago)
please tell me what to do after entering programming mode i m totally new for database. i didnt understood what u did after you pressed "enter" in front of private sub userform_click(). what to do now?? help me
Magdiel Adames (1 year ago)
I will be doing some youtube livestream on userforms. I could be able to answer some of your questions.
Issac Kants (1 year ago)
Acknowledge
Juan j (1 year ago)
I cant search a different client with the same name. Could you help me with that configuration ? Please..
Magdiel Adames (1 year ago)
I will be doing some youtube livestream on userforms. I will be addressing your situation.
Lavi Chaudhary (1 year ago)
Thanks for sharing useful tutorial
Ben Agyei (1 year ago)
hi, please can you help me create a database about client's savings and withdrawals?
Librarygurl (1 year ago)
The music is very distracting.
Nirmal Xavier (1 year ago)
Please Replay My Mail Sir
kishor purohit (1 year ago)
pradeep ji send (VBA) DATA BASE MY MAIL ID [email protected]

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.