thank you for the best explanation, it does clarify a lot. i did exactly as you said, only thing, during report, i receive the oders from ALL customers, rather the selected invoice No. can you tell me why this is? please note, i am not a programmer :)
Thank you for the lesson. I have query, if the same customer purchase more products at a later date, how to add more order forms with the same customer, and preview the invoice at the date of customer purchase the products. In my case, with the same mechanism of the sample, the invoice report will preview all invoices in 2 pages. How to preview only last invoice, thank you.
In this case you can you the value list edit form option in the property sheet. Choose to edit list items with the product form. Let me know if this works.
Do you have any tutorial or link for that one sir? I cant use a calculation formula since the sum of total cost was created on datasheet layout and CART form has no table, only formulated from invoice query. Tnahk you@@datatechstutorials
I mange to creat a new discount button and succesfully applied a discount formula on on CART form but when I add on query in ooce report the label is visible but the the disclut value was not vissible and it was blank. Is it in the format setrings to show the value? Thank you
Good video, just one question. what happens when a customer comes more than once a day, there is no way to distinguish between the orders a customer bought in different times of the day
In this case, we can combine customer ID and date of orders to create a unique serial which can be used to identify all orders made by a customer on a particular day.
hello thanks for the leassons i have makinig a lot of work with .. BUt nowe i stuck.. .. a several day i am look for the anwserr on this quistion .. If i making the macrocode = brings me to the raport ( ="[saleorder]=&"'"& [saleorder] ecte ct . I am getting a raport with ALL my records sale but not the specific saleorder ? Can somebody help me with it ... thanks
Hi There, I was practicing side by side your video and at the portion where you were saving the Table 3, Invoice_OrderTB access displayed an error "type mismatch". I tried some help but couldn't fix this error. Can you guide me?
Very understandable video sir! Kudos! Just have a query sir....how can you do a credit balance report on specific costumer with their payment and balance history. Thanks for answering in advance sir...Godbless!:D
Sir, I am a student and beginner of MS Access, I know nothing about Programming, even a little bit. I want to learn MS Access from Basic to Advance, what is the road map for that. Can it be learnt in someone's own country? or the ms access tutors are very less. In my locality I didn't find any tutor of MS Access. Can you please tell me that whence we can learn it in a proper way(All in All) ? Please Sir Please Please!!!!!!!!
You go way to fast. Slow down! I had to go back over and over because I kept missing things you would quickly say under your breath. Overall, this video was very informative. Ok...I'm going to go back and rewatch the parts I missed.
Fantastic job...but this does not subract the QTY f the item invoicee from the inventory QTY. Therfore, if you have 20 items and sell 15, it still shows that you have 20 items. It would get 100% if this was achieved.
Sir, can you share how to update the product price, without effecting existing one. when I changed the product price of "Gin Toes" all the previous selling price of "Gin Toes" recorded are also changed.
Dear Sir, Would you like to Upload a coarse-wise session of videos that explain the MS Access with much in-depth details, that will be fantastic, if you already have uploaded the coarse, then link my comment to that !!! otherwise Upload Please Please Please
This video literally saved my behind!! I can't thank you enough!
You are very welcome madam.
It is Fantastic that you Answer Every Comment!!!!!
Thanks for the explained Content Sir Best of Good Luck....
The Copy of My Comment
Hahahahahaha
Okay No Problem, Don't Worry, I don't Mind!!!
Thanks for this video. It is very educative.
Glad it helped. Thanks
It is Fantastic that you Answer Every Comment!!!!!
No UA-camr works on such Policies,,,,
Thanks for the explained Content Sir Best of Luck
It's my pleasure. Thanks sir
thank you very much. Lesson was explained well
You are welcome!
Thanks for this video. You need more followers and viewers than this. Thanks for the guidelines throughout.
Thank you too
This is very educative, well done.
Thank you
Amazing brooooo❤❤❤
Good work
Thank you
very good tutorial
Many many thanks
Amazing!
Thanks!
Genial. Thanks
Love this
thank you for the best explanation, it does clarify a lot. i did exactly as you said, only thing, during report, i receive the oders from ALL customers, rather the selected invoice No. can you tell me why this is? please note, i am not a programmer :)
Okay, attending to you on WhatsApp already I guess.
Thank you for the lesson. I have query, if the same customer purchase more products at a later date, how to add more order forms with the same customer, and preview the invoice at the date of customer purchase the products. In my case, with the same mechanism of the sample, the invoice report will preview all invoices in 2 pages. How to preview only last invoice, thank you.
Hello sir, it is best you send me an email or whatsapp explaining since this is more or unless personal problem pls? Thank you.
thanks for sharing the db file
Thank you too sir.
Thanks you very much but I want to know how to add new product when the product is not on your list.
In this case you can you the value list edit form option in the property sheet. Choose to edit list items with the product form. Let me know if this works.
Is it possible to add percentage discount button from the total price? Thank you
Yes sir. It is possible
Do you have any tutorial or link for that one sir? I cant use a calculation formula since the sum of total cost was created on datasheet layout and CART form has no table, only formulated from invoice query. Tnahk you@@datatechstutorials
I mange to creat a new discount button and succesfully applied a discount formula on on CART form but when I add on query in ooce report the label is visible but the the disclut value was not vissible and it was blank. Is it in the format setrings to show the value? Thank you
I will try to add the formula in query expresion builder. I will try to figure out the right formula as well.
Good video, just one question. what happens when a customer comes more than once a day, there is no way to distinguish between the orders a customer bought in different times of the day
In this case, we can combine customer ID and date of orders to create a unique serial which can be used to identify all orders made by a customer on a particular day.
hello thanks for the leassons i have makinig a lot of work with .. BUt nowe i stuck.. .. a several day i am look for the anwserr on this quistion .. If i making the macrocode =
brings me to the raport ( ="[saleorder]=&"'"& [saleorder] ecte ct . I am getting a raport with ALL my records sale but not the specific saleorder ? Can somebody help me with it ... thanks
can you send an email?
Hi There, I was practicing side by side your video and at the portion where you were saving the Table 3, Invoice_OrderTB access displayed an error "type mismatch". I tried some help but couldn't fix this error. Can you guide me?
You can email me with the issue?
This is very educative, well done. However, you need to slow down the pace of teaching so that you don't lose some learners.
Okay I will sir. Thanks for advice
Sorry can you help me how to collect data from different tables (two or more) and place them in one table for reporting
Hello teacher very nice.
Thank you! 😃
Sir, Do you have any software for Diagnostic Center or Clinic ? I prefer Made in Access
No I don't have. But you can contact to discuss this. Thx
Very understandable video sir! Kudos! Just have a query sir....how can you do a credit balance report on specific costumer with their payment and balance history. Thanks for answering in advance sir...Godbless!:D
a lot goes in here. maybe you can contact for special consultation on this
Sir, I am a student and beginner of MS Access, I know nothing about Programming, even a little bit. I want to learn MS Access from Basic to Advance, what is the road map for that. Can it be learnt in someone's own country? or the ms access tutors are very less. In my locality I didn't find any tutor of MS Access. Can you please tell me that whence we can learn it in a proper way(All in All) ? Please Sir Please Please!!!!!!!!
Hello, have you checked on Richard Ross? Else reach out to me via email.
Sir am blocked at the level of the invoice table,it is saying mismatch
Hell Eyong, check the description to download the full file of this lesson. If issue persist contact me via WhatsApp or mail.
Hi prof what ido if i need to print only one record not totall
In that case use button on profile to open directly to a record using where to statements (where "Id="&id for example
You go way to fast. Slow down! I had to go back over and over because I kept missing things you would quickly say under your breath. Overall, this video was very informative. Ok...I'm going to go back and rewatch the parts I missed.
Thank you for the kind advice
Fantastic job...but this does not subract the QTY f the item invoicee from the inventory QTY. Therfore, if you have 20 items and sell 15, it still shows that you have 20 items. It would get 100% if this was achieved.
yes this video doesn't capture that. check in other videos in the playlist on product qnty calculation and inventory. Thx
after doing adding the sales code on the invoice the systemis requesting for parameter value for sales code
you can send me this via WhatsApp
Thank You so much Sir share the file of profit and loss accdb.
Will upload soon
When I go into form view it does not move like yours it's fitted the hole screen please help
Hello try adjusting the anchoring options at the form design view-property sheet.
Could you teach me this step by step
Like that one 9:31
Sir, can you share how to update the product price, without effecting existing one. when I changed the product price of "Gin Toes" all the previous selling price of "Gin Toes" recorded are also changed.
Okay. This is well noted and will upload on it. Thanks for sharing to the benefit of the community.
@@datatechstutorials Sir, I still waits you help in how to update the product price, without effecting existing one.
@@Mamoiavarte hey, can you send me an email or Whatsapp
Good morning
Good morning sir. For personal conversations do email me
Dear Sir, Would you like to Upload a coarse-wise session of videos that explain the MS Access with much in-depth details, that will be fantastic, if you already have uploaded the coarse, then link my comment to that !!! otherwise Upload Please Please Please
okay. for the mean time the available videos are in the playlist. Can you check them out and let me know if you need any extra help
God bless you in Jesus' Name Amen ✝️
Amen