Microsoft Access - 06 Create a subtotal field on a form

[@anandmallikarjunan7775]

Dear Sir, Your Tutorial and way of presentation is really excellent. You are teaching well. Keep it up. God Bless You.

[@vincysigma]

This is what i was looking for for long time. you made my day. Thank you so much. and God bless you...

[@emadabuhagag222]

This is what i was looking for for long time

[@Schleppy625]

Impressive series.. Helped me out a lot. Access is quirky with the relationships and code and this was really helpful. Thank you Shad..!

[@alializadeh8195]

Thank you ...

[@kegenrodrigues]

How can i store the value of Order Table (dynamic value) to a separate field of a separate table?

[@moneementor5175]

The text box created for a the total shows up with #Error inside? Tried redoing several times and same error. Please help! Thanks

[@farrukhammar7284]

You have done a great job

[@imvandam]

How do you make the price static so that future changes to the price will not change the price on previous invoices?

[@rhondaluhrs7335]

Hi Shad. Fantastic set of videos. I have now completed my Invoice Form and Invoice Details Form. How do I now create a printable invoice to send to my customers with address etc.

[@cliffordmacharia9065]

Hi, this is very helpful! Also is it possible to add the subtotal to the invoice table?

[@darshitrathod7902]

Sir i am facing a problem that is the total in main form is not calculating

[@createvisions]

Sir i am facing a problem that is the total in main form is not calculating

[@selvarajandiappa3143]

Hi good day .. Need your help.. In Microsoft access if we want the form to display total in numbers.. For example the total of new job, total of pending jobs, total jobs waiting for spare parts and so on.. Is it possible

[@peinichua5987]

hi , i have a question under 5.22 second why i type in invoice it wont come out let me choose?? Pls help thanks

[@petefenolio4816]

I followed these steps exactly and keep getting #error in the total. Any idea why?

[@dasrotrad]

Pete... I get #error also. Have you discovered a solution?

[@createvisions]

@@dasrotrad yeah, don't do it at all

[@mitchellfolbe8729]

Make sure you name the unbound box "total price" and not the label "total price"

[@chuy14nba]

I don't get an error, but the order total is blank is not showing nothing!

[@harikrishnannamboothirin2911]

one doubt!!!!! how will i save the total in the table i have to keep the record of the total also

[@kailidamaske2877]

Hi, so I followed your steps exactly and my total order is blank.... not sure why everything is done exactly like you did! PLEASE HELP!!!!

[@createvisions]

if you would have done everything he did you should have been fine

[@tjvel_Bhajana]

HI, I use access 2007 and when i put this expression it shows a error "#Name" what should be done plz help me out

[@createvisions]

the equation might be typed incorrectly or it just might be too old of a access

[@ashokachangadan7674]

how to store this data in to subtotal

[@alializadeh8195]

tHANKS

[@manuga2001]

you're a god among men thank you so much

[@moodyrcf]

how do i get the total when i make the report or print? need to make a statement

[@shadsluiter]

Check out the next video in the series kzbin.info/www/bejne/hXK7qZiupMuoatk

[@barbarascutt792]

This has helped me a lot but I have one issue. If I don't have any value in the subform, I get #Error instead of zero

[@CarlosRuiz1]

Exactly! what I was looking for. Great work. Thanks a bunch!Can I add a request? Could you fill in the products table information by querying another DB (e.g. MySQL) on the fly, instead of having to create a table with the information in Access? Alternatively, keeping an Access table synched with the contents of another Table in another DB engine, using an ODBC connection?The problem is that I already have the products table information stored in another DB engine and I dont want to duplicate information in Access and I also want to avoid having to maintain two separate product information tables simultaneously.

[@hannalawwad3407]

You are the best ...thank you so much

[@shadsluiter]

You're welcome! Are you studying to be a software developer?

[@hannalawwad3407]

@@shadsluiter yes,I'm studying computer engineering.the tutorial help me so much but I need to know how can I save the total sum of each invoice in invoices table I try many times to do that , can you help me please?

[@shadsluiter]

@@hannalawwad3407 The Orders table would need a new column (field) called order_total or something similar. Save the value when doing a checkout.

[@hannalawwad3407]

@@shadsluiter I will try this idea ..thank you so much

[@danburnham4643]

Shad, love the work, one question, how would I update the product table to reflect the correct quantity after products were sold? Thx, Dan

[@firefighter0345]

So I have done all the steps added all the equations. They show up but on my orderly total it will not show. It stays blank. Have deleted and started over several times. PLEASE HELP!!!

[@christianb572]

Same here. I do everything like in the video but, for some reason, the text box remains blank!

[@designerx100]

how to make this form (invoice) uneditable once completed/closed. Like the one in Northwind DB please.

[@shadsluiter]

+designerx100 Watch the last video in the series kzbin.info/www/bejne/qaWWamSgp96Fj9k This will show you how to protect the application from edits.

[@sudiptadas1804]

Please help. Its showing 0 instead of showing subtotal.

[@anluuy17]

HI SHAD i created an invoice form with Sub form like yours. now how can i update the product stocks in the product database i cannot create an update query using the subform in the Form i made. can you show me how thanks so much. im having a hard time. I've been watching some videos of how to create an update query but it seems it only works in a single form invoice. Thank so much and hope you can help me out

[@simplybelieving5315]

Hi, great tutorial! Will you be adding more content? Like having a discount based on which customer?

[@alexanderenos9628]

Thank you so much. This has helped me a lot! How would I integrate receipts pls?

[@miinoo88]

Did you find this solution?

[@suhbatismatullah9948]

hello every one where I can find this video ? Microsoft Access - 03 Create a simple store invoice system tutorial create tables

[@juancarlossilvaleal306]

You are the best

[@tgrisko]

absolutely LOVE this! ! I have a question that I cannot figure out... I would like to put a yes/no box to calculate tax if I charge tax? Can you possibly help me with that? Thanks again.... GREAT TUTORIALS!!!!

[@miriamenvios3813]

please share link of part 3

[@chrisnelson7500]

Thank you, clear and succinct

[@andybawn1]

good series. one problem. it all works great until you change a price in the product table. it resets all the invoices to the new price making them useless :(. unless there was something in #3 that prevented that, thing is #3 isn't on here ?? :(

[@shadsluiter]

Good point. The invoices are not locked / closed. Needs some more work. Video number 3 is here vimeo.com/157627924

[@andybawn1]

Thank's a lot Shad, i'm looking at ways to lock it up now. but being a complete novice at Access it may take me some time :) I was thinking maybe a save button on the invoice entry form that will append that invoice to a different table? in effect having a table that is outside the auto update of the system then having a data entry form and a read only form for the invoices, don't know yet have to play with it for a while see what happens. I learned a lot of new thing's thanks to your videos, very well made and put in a way even an idiot like me could understand. again thank you very much

[@shadsluiter]

I would suggest that a new table is needed. Perhaps titled "Historical Price" Columns = Product_ID (which links back to the product table), Starting_Time_Date and Price. Whenever a product price is changed, add a new row to the Historic Price table. The invoice has a date so use the historic price table to get the price for the correct date.

[@andybawn1]

Hi Shad, well I’ve been digging deep in to the dark corners of what I call a brain and may have come up with a simple fix. How about having a hidden field on the invoice sub form for the 'current retail price' and if the 'retail price' field is null / empty it runs a bit of VBA code to transfer the 'current retail' price into the 'retail price' field. maybe after the Quantity field is updated. Obviously if the retail price field is not null/empty the VBA code won’t run. What do you think?

[@createvisions]

very interesting

[@VarunyuApisaksiri]

Hi! This series is great. I use it to learn how to use MS Access and try to develop my business also. In the other hand, I have some thing I want to add up from these VDO. 1. I am both retail and wholesale. How to choose or change price in invoice into wholesale price? 2. I want to have inventory track function in the application, Could you suggest? 3. I want to make roughly profit & loss statement, Could you suggest? Thank a lot for These VDO ^.^

[@shadsluiter]

You are going to have to create new tables to handle multiple prices, including a table for the historical price. Create another table for inventory values. This tutorial is designed to give only a very basic understanding of the Access and Database concepts. I would recommend either hiring a professional developer to make the app or if you would like to do it yourself, take a more advanced course. Udemy has some medium to advanced courses that could help. www.udemy.com/courses/search/?q=access&src=ukw

[@VarunyuApisaksiri]

Thanks a lot. I just finding some ERP app and found these VDO. You inspire me to learn about the database. Maybe I have to take some course for this. :D

[@KM-be5hl]

I was fascinated by ms access power such that I developed my Own invoicing and product tracking database. I watched online videos again and again for 6 months. Now Inhave made forms and queries to calculate sales totals of Each product, summary of sales of products monthly compared to annually. And even print each products history from an opening balance till date with closing balance. It even covers returns and purchases of the products . All by Myself ! Just from free tutorials. I work in my own small business and my software comes free to me with unlimited freee modifications at will !

[@sagheergic]

Thanks for uploading your rigorous videos. I am trying to calculate the discount on this video based on the idea through which you get Grand total on the main form. But so far, remained unsuccessful please guide or upload a video.

[@nac205]

Everyone who wasn't able to get a total, it seems that you need to put the formula in the Footer section. Not the body

[@rodari78]

thanks a lot

[@المعزصديق]

thanks - very usefull

[@RichardFlorin]

It was trikkie. But Thanks