Access Form With a Subform and Calculated Fields

[@ricardomontoya2108]

Have a program to write to account for my Church's contributions, your video shows me everything I need to get started. Thank you so much.

[@Officeinstructor]

Wonderful!

[@rajeshsanghvi1418]

Nabil -Best instructions. Very clear. Thanks for this.

[@dewaldkritzinger3568]

BRILLIANT!! THANK YOU. Easy to understand and follow and no steps missed or "assumed". First time, all GOOD.

[@abbasial]

It was the best access tutorial that I have ever seen. thank you. excellent

[@paulstanlev459]

Fine Thank you Sir. you Great, special and nice for Teaching...

[@sadaquathussain7938]

Thank You so much sharing such kind of fruitful video on MS. Access.. Mr. Nabeel Murad you have has good grip on Access and explained all concepts of form & sub form in very professional way.

[@nationalprayerroom781]

Thanks so much for this. I have been trying to figure out how to put totals from a subform for a long time. Thanks for the great work.

[@Officeinstructor]

Glad I was able to help

[@johncobbina]

I haven't come across such a tutorials before. You done a good job.

[@Officeinstructor]

You are most welcome

[@leonshears6925]

Very good! Everything I need to know - except "tabbing". I was hoping to learn how to tab from the main form on to the subform (2 consecutive fields) and back to the main form. But apart from that, again, excellent! Thank you

[@zs6deb]

Thank you Sir, this was, and still is an amazing tutorial!

[@dorothy6424]

The tutorial looks great and very simple!

[@stephenheadland5589]

Very informative. Thank you.

[@vijaysarvaiya8592]

What nice and clear instructions... thank you sir..

[@jungjungdelosreyes4147]

Wow...pls continue to use this same database as you progress your tutorial. I like everything on your tutorial very straight forward and faster, because some tutorial is too sleepy and boring. But this one excellent. Im looking forward the progress on this same database. Thank you sir.

[@adriannaparedes]

The best explanation, thank you very much 😁

[@abdulhamidalhaddadi2255]

Nice and easy lesson. thank you

[@pratchmg]

Thank you. That was extremely informative and has helped me a lot.

[@liveoffline4317]

Perfect explanation

[@ashokanselliah9571]

Thank you so much. I really enjoy your video and it is really helpful.

[@polaterol417]

Well done.. The best on Forms.. There is only one area you should be careful.. in the creation of Subform you deleted the RetailerID .. but some how it came back when you connected the subform to the mainform..

[@ammadkangatabdulla8775]

excellent,clear and interesting tutorial

[@rohancorea750]

Well Done, Nabil.

[@Officeinstructor]

You are welcome

[@fromspenny]

Fantastic video thank you

[@vincysigma]

Thank you Sir. it was wonderful..

[@Officeinstructor]

You are most welcome

[@gathobeevens2644]

Thank you Sir !Blessings!!!

[@jloo1900]

fantastis. Thank you and God bless

[@Officeinstructor]

Glad you liked it

[@tonanmaroc]

very very very good thank you very much

[@princeblahkohnway7818]

I enjoy the tutorial.

[@abusam1]

@30:30 you are inserting a new record, and as soon as you hit the tap from qty the "total" dynamically gets calculated, while the the text box for subtotal above does not dynamically gets updated unless you move to a new record. how is it possible to have the calculation dynamically calculated as soon as I type the value? thanks

[@alenmorina1543]

Great video. Thank a lot.

[@Officeinstructor]

You are welcome!

[@korbike1]

Thank you, well done!!!!

[@Officeinstructor]

Thank you too!

[@moneementor5175]

I'm having trouble making the relationships among the tables and what foreign fields need to be in them. Any help? Thank you

[@frankkenneth1129]

Thank you so much..

[@Officeinstructor]

You're most welcome

[@eeevvveeevvveee]

thanks for your upload

[@rommelramoneda738]

I like to the technique that was used, do you have an example similar to Training Class Database. Hope to see one that I could reference on my current project.

[@habibullah2461]

Excellent.

[@rotethongvanit]

I have watched your basic course Part 1 to part 9, impressed. Do you have an intermediate or an advanced course?

[@moneementor5175]

Great and refreshing video! Love your teaching style! I do have one question, is there any way to choose the customers with a combo box so that all the related information would populate? Thx!

[@Officeinstructor]

Thank you for the nice comment. And Yes, Same like the combo box for product name in this video.

[@moneementor5175]

So I changed the text box to a combo box, but when I did the record identifier at the bottom of the page didn't change when I changed the customer in the box..@@Officeinstructor

[@jamesowusu8245]

Great presentation. Thank you Please i need your help I created two forms from two different tables. i want to enter only the PatientID from the first form so all the remaining patient details will be filled in the second form. How can i do that? i will be grateful if you can help me.

[@billelguechi5831]

❤❤❤❤❤

[@kalpeshsangita]

Was there any data in the junction tables? How to import data in the junction table if I create one? Thank you

[@alializadeh8195]

Thanks

[@artistryartistry7239]

Thanks for this, but at around 5:20 you do not explain the logic behind which items you're adding in the query. You just say I"'m adding this, and I'm adding that. It would be useful to understand WHY because in you could've added the exact same field from a different table with the same ID name.

[@Officeinstructor]

Honestly I can't remember and have to check the video, that was long ago

[@jayare7750]

Is there a way to create a form that has multiple drop-down menus and in the subform it will populate which items in the dropdown menus were selected and how many? lets say 20 drop down menus each have the option RED, ORANGE, YELLOW, GREEN, BLUE, INDIGO, VIOLET Then when the user selects the values from the dropdown menus, a subform will populate the choices and the quantities. example if the user selects only REDs from the form's dropdown menu, the subform will say RED - 20 if the user selects 2 of each at random dropdown menus and the remaining BLUE the subform will say RED - 2 ORANGE -2 YELLOW - 2 GREEN - 2 BLUE - 8 INDIGO - 2 VIOLET - 2

[@HRazaJ]

dear sir, please inform me, is there any way, that i can enter product list, before entering customer details?

[@akokohjoel9854]

Pls sir I have main form with subform, I want the value of (1200) on field(txtAmount) on the mainform to also appeared on the subform field (tztAmount). I have a button on main form , so which VBA code will do it.

[@lawrencewillie9087]

Hi Sir, how can I create a report with data from main form and sub-form to a single report layout for printing?

[@AutoCAD_Troubleshooting]

THANK YOU VERY MUCH BUT I NEED TO STORE THIS CALCULATION TO A FIELD OF TABLE BECAUSE I HAVE VARIOUS INPUT TO THE FIELD PAYMENT

[@vijaykumarp2405]

i am very new to Access, pls tell me what is lng, str, cur, mem before each field name.

[@lbrahimfalihal-masoodi2185]

thank you all information and how can make tables in the first vido

[@leonshears6925]

Sorry!!! I should have asked if you have another video to show that???

[@cjlion7081]

in the creation of the form query you offer no explanation of the reasoning behind it. what does it facilitate and why, so many people say they have helpful information this and many other videos seem to only be for monetization or to somehow prove YOU know what YOU are doing... great you can make an order form, so can everyone else...

[@moneementor5175]

Hello, anyone here?

[@bradleykarlhalcomb685]

looks like tof from bh at sct.... \