How To Create A Simple Database In Excel (VBA)

How To Create A Simple Database In Excel (VBA)

[clairelee]

this tutorial is better than other tutorials given. Just appreciate that you're learning for free.

[nooru]

Pradheep is great Helper He solved my pro which i post here and sir now i want add some more functions like check box, list box can you help mee???

[prakshshukla]

Good video making it very good by explanation so people can understand very much better way .

[mikepaterson]

Wonderful video Pradeep, thanks for sharing. I have incorporated alot of your code into my own project but when searching using the second combo box i cannot amend or delete records - do you have any code that could do this?

[janicedrew]

Ok so, created VBA Data sheet. Now want to activate the command buttons. Like you wrote I double click on the command button, but now to paste the information on the sheet.... There is no sound on this video so very difficult to get the basics right. Did you use a keyboard short cut, if so, which one?Or should I just type out the whole command?

[stevenphilp]

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!

[saravanakannan]

such a good one..!!
Sorry to ask just tell me how to Save it(which extension i should use)
And the another one thing is it possible with ms office 2007...???

[teuteu]

Thanks a lot, I have added a new frame with additional information, everything is running smooth. Now i would like to add an other button to delete only the information in the new frame named frame 4 without deleting the information in the frame 2.
Now i have a database with a total of 10 columns so 5 column are dedicated for the frame 2 same as your example and 5 other for the frame4 that i have added. if i use your delete button the entire line with the 10 columns are deleted. but i want only to delete the last 5 column per employe name selected.
How to do?

[jenariodeguzman]

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.

[Novaprod-jnkq]

i want to start making soft and rapping i have an acer laptop. does soft soft co with good softs already?

[stefanjansevanrensburg]

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.

[nathanball]

Hi Pradeep. Thank you for this great video. I have an issue with my setup
I have followed your steps, however when doing a search, I am only able to bring up 1 persons details. I then select a second name from the list and the details don't change

Could you please let me know how I can fix this?

Thank you

[ajhernz]

what excel 2010 or 2013? because when i run my edited work from you it's work but when i saved it and then i open it, it's work but when i search/click the other i saved the only appear is the first one i saved? how can i fix it? or there is something in my ms excel version???

[rospy]

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

[romarabino]

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!

[Kashmirkid]

If I wanted to make the Search bar able to search criteria other than the employ number. how would I tweak the code to include other search queries?

[romarabino]

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?

[kardiona]

The music is pretty nice to listen to while learning Excel. :D

[laxmireddy]

what did u done as last point to save the database. that i couldn't understand

[kirankumarshah]

Your example files seems to be password protect. Anyway around it?