Multi User Data Entry Form in Excel VBA (Part-2)

#VBAApplication #MSAccess
Hello Friends,
In this video, you will learn how to create VBA application (Rent Management System) with MS Access database using ADODB connectivity. We have used VBA user form with Textboxes, List box, Combo box and Command buttons. We have created minimize and maximize button to work on the excel while application is running. Filter by and Order by feature has been given to navigate the data. We have used the Calendar to fill the dates.

Part1:

Please download the practice file from below given link:

Download our free Excel utility Tool and improve your productivity:

See our Excel Products:

Visit to learn more:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Twitter:

Pinterest:

Send me your queries on telegram:
@PKanExcelExpert

************* Suggested Books *********

************* My Stuff ****************

[chitaranjanbarik]

YOU HAVE MADE ALL THE VBA DEVELOPER PLEASED. HEARTIEST WELCOME AND 🙏 🤗 😘

[tienta]

this solution was using Access DB which can handle overwritten data when 2 users doing it at the same time. I got this problem, I'm so happy if you have any better solutions. Verry appreciated for your work.

[ajayrawat]

Msgbox "Great Job, Sir", VBinformation+ vbokayonly, "Thank You !! "

[hisonamdawa]

Wow ! Fantastic. This really wonderful and I am now learing through your channel ! Keep it up ! A Tibetan Guy from HP. Jay Bharat !

[bapibp]

I want to listbox data filter with combobox and multiple textbox, how can i do this, is it possible, have any solution, thank you a lot your great help.

[gyaantoon]

I m beginer for VBA but I see your part one application design video and design my application as par my requirements can u share the coding for understand

[rohitgurung]

This is are amazingly good....thank you for sharing practice file....

[sallum]

Hello Sir .... in the same manner can the data connections be made between the access table and excel sheet so that on updating the access table, the excel sheet data also gets updated which in turn is connceted to a excel dashboard ??

[SuperHanme]

thank you very much. You are CoolMan, Kumar.

[bondniko]

Thank you, Brother, for this training.

[LyleKetchup-kv]

Hi. I hope you can also show how the ms access was being updated.

[syedimran]

Hi sir thanks for this video I have a one question for you how can I ad 4 mor textbox?
2 already is there in userfom total Amt and paid amt but we have to 4 more text box in this userfom ( discount in percentage % ) ( discounted amt ) ( received amt ) and ( balance amt ) thanks.

[hishamal-baihasi]

Thank you very much Sir PK. Awesome explanation! But I could not find the working file in the link mentioned in the description. Can you provide me with the direct download link? I will be thankful for you.

[kishorekizz]

Very helpful tutorial, thanks for your effort on doing this.

[deepakkumarchauhan]

very nice video & useful.... thank you very much.

[nmskysweed]

Thank you my friend "pk" I have a question how can I filter the list with multiple comboboxs in the same Time like advancefilter in excel I need code qry for that. You have my utmost respect and appreciation🌹

[bapibp]

Great help thank you a lot, i need sort with more one textbox to serch filter, how can i do this!it would be great help, thank you once again.

[simbarashevhovha]

Hi Mr Kumar- thanks for the good work, suppose i use a separate excel workbook as my database, how do i make my listbox rowsource refer to the database workbook sheet

[gyaantoon]

I make design the application as per my requirements but.. I m learning VBA can you share coding for my application, for understand

[deepak_shastri]

Sir please help me, In the part of export to excel, Can we export the Excel into a specified excel file or preformated excel file