Microsoft Access Tips | How to use VBA Recordsets and Modules

[@PeterPapadimitriou]

Thanks

[@LoopLearnings]

Hi Peter, Thank you so much 😊

[@jisokmproductsvideos8863]

i am intrested to learn VBA, PLEASE ADVICE, I have been using M Aceess since 2006 and I love it

[@ralphlewis4350]

This is the most clear and concise teaching i have seen on this. Thankyou so much

[@LoopLearnings]

Thank you very much ☺️

[@victorarchangel9400]

Very good

[@PeterPapadimitriou]

Excellent. Thank you.

[@LoopLearnings]

Appreciated

[@josephpatrick5381]

Thanks for introduction to "RecordSet" and "Modules". Used SQL commands embedded to "Save" button in form itself. Would like to know about "Recordset" method for editing record. Would also like know how "Recordset" can be used in relational multiple tables. Hope you will cover the same in future episodes.

[@LoopLearnings]

Uploaded

[@manishkashikar9154]

Wow what a funtastic method, thank you

[@LoopLearnings]

Glad that you liked it :)

[@sheltonsmith-o1v]

👍👍

[@strive4peaceksa]

This is a great lesson.. can you please show me a demo a form with search txtbox, edit, cancel, close, delete button.

[@LoopLearnings]

Thank you, will make a video soon !

[@SiyamandRashid]

This method is used for update as well?

[@mosjany]

sir kindly demonstrate a loan management VBA where by You can loan people money at percentage rate, kindly show us on how you can receive those repayment installments , loan balances , profit margins , cash in cash out plz

[@munirjamali1101]

Brother, when u create a form, u have to link it to some table, and subsequently each box in the form to a field in the same table. Filling the form populates the linked table without the need for even a save button let alone a code in VBA. Why should one bother with all this when the result is achievable without it ? I watched the video thinking that the recordset will lead me to something new. Plz let me know what i am missing here.

[@LoopLearnings]

Hi, thanks for the message. If you want to make an application for yourself which will be saved on your computer then yes go ahead and create a bound form which is linked to the table. But when you want to make application for multiusers and you want to avoid performance issues then using recordsets is efficient way...

[@karanlimbu2990]

🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰

[@wimschiphorst8541]

I don't really see the point of a global module in this example. 1. If you use a different forms or tables you must adjust the code. Maybe use variables? 2. You say that the form will be clearer. On the other hand, you have to look carefully in the module to find where the code of that form is.

[@LoopLearnings]

Hi, thanks for the input. I guess it depend on each developer on what route one wants to take. For me modules are really helpful specially when you are making application that will be used for several purpose. Now i make less number of forms and reports and i basically utilize one form or report for multiple purposes and modules really helps. with regards to search, you can use Ctrl + F and give the name of the function. By the way as i said it depends on each individual but thanks for taking time to comment, cheers :)

[@wimschiphorst8541]

@@LoopLearnings I than not understand when you say "I utilize one form etc". But if you must at new record to table cost instead of product. Or have open form cost instead of productF. Maybe this is something for future video

[@satyabanukil779]

Try to develop a SUM module. In excel sum function works easily but Access form does not allow that function. So a module could be very useful.