Microsoft Access - 05 Create a form for invoices

Поділитися
Вставка
  • Опубліковано 12 січ 2025

КОМЕНТАРІ • 40

  • @haishengcao6363
    @haishengcao6363 2 роки тому +3

    Thank you for the tutorials. Very impressive. Simple, but clear.

  • @poduvalsumod
    @poduvalsumod 3 роки тому +1

    ONE OF BEST CLASS SO FAR... THANK YOU SIR..

  • @sephjvr5979
    @sephjvr5979 2 роки тому +2

    You sir are a legend. Thank you.

  • @unyxium
    @unyxium 5 років тому +2

    Thank you! This is what I needed! Easy to follow tutorial.

  • @RavishaVijani
    @RavishaVijani Рік тому

    thank you so much for this tutorial..very clear and easy to understand..

  • @danburnham4643
    @danburnham4643 5 років тому +2

    Shad, when I select Form Wizard and add all the fields from the various tables, it doesn't show the option where it gives the option of Form with subforms(s). Any suggestions,
    Thanks,
    Dan

  • @deergeneticsnz
    @deergeneticsnz 2 роки тому

    How do you set up adding GST (15%) to total if Customer is Registered & leave empty of not?

  • @MrTHuG_gh
    @MrTHuG_gh 6 років тому +1

    Hi, thanks so much for ur videos. please where are the rest of the videos? 06

  • @edwardanderson9966
    @edwardanderson9966 5 років тому

    How can I add new products that are not in the product look up table on my form/ If I want to add a product do I have to enter it in the product table first. It would be nice if when filling out a form and have a new product to sell I could just enter it in the subform and have it append the products table.

  • @samanthatesta3385
    @samanthatesta3385 4 роки тому

    Hi Shad - i need to set up an invoice whereby each customer is billed differently for each product, how will I set that up?

    • @helentaylor9721
      @helentaylor9721 4 роки тому

      Hey you can use the Moon Invoice App. Its easy to use and also pocket-friendly.

  • @ranggayudistira76
    @ranggayudistira76 7 років тому +1

    how to print this form invoice

  • @D3_Business_Analytics
    @D3_Business_Analytics 7 років тому +4

    Product ID same as Product Name ... in subform....Should be modified

  • @davidrodgers8531
    @davidrodgers8531 5 років тому

    If you change the price on a product, wont it change all the old invoices to match ?

  • @Mamoiavarte
    @Mamoiavarte 2 роки тому

    Sir, I have created database for my store as you have shown in this video. The problem what i am facing is when i update the selling price of a particular product. That product selling price in the old invoice also change automatically. Can you please show me how to update the product selling price without effecting the old invoices. Thank you.

    • @shadsluiter
      @shadsluiter  2 роки тому

      Create another column in the sales table. Name it current price. Save the current price when you make the transaction.

  • @Eiva911
    @Eiva911 7 років тому

    May you know whit might i have done wrong. I did everything as you show, but as I open Invoice form (also I converted Invoice form into report but same problem) on Print preview it shows every Invoices subform in one page while I need to print only one Invoice with his own subform. Any ideas ?

    • @CalvinHodgson
      @CalvinHodgson 7 років тому

      In File > Print select the radio button "Selected record(s)" under the Print Range.

    • @SalRez
      @SalRez 7 років тому

      Calvin Hodgson oooooooh, I love you man. You just saved my ass. Thank you soo much!!!

  • @bergbergberg4976
    @bergbergberg4976 2 роки тому

    i am running into issues when adding discount for each item

  • @SamnangIdea
    @SamnangIdea 7 років тому

    Excuse me, could you show me table relationship?

  • @santdnyaneshwar9920
    @santdnyaneshwar9920 5 років тому

    Sir, just solve the big error that if we use autonumber data type for sales invoice no. and during entry user has cancelled the entry or not completed the entry then auto generated bill no. will be generated but invoice contents will be left blank. or if we deleted a bill there will be a gap in bill number. so how can we prevent from this issue?
    Sir, nobody have solved this issue that i am asking since last 2 years. so I hope you will give a positive response and will sort out the error.

    • @shadsluiter
      @shadsluiter  5 років тому

      Gaps in the numbers are a normal "problem" when using auto numbering. If a record is deleted there will be a gap. There is no requirement that numbers be consecutive. They just need to be unique. In many computer systems a record ID number is a long string of seemingly random characters.

  • @gururajkulkarni6529
    @gururajkulkarni6529 3 роки тому

    very nice video.. i want a auto serial no in subform ... kindly guide me

  • @ABDULLAHSHAHABbahawalpur
    @ABDULLAHSHAHABbahawalpur 7 років тому

    bro where is part 3.

  • @ldillipkumar5803
    @ldillipkumar5803 8 років тому

    how to gate product prices automatically

  • @SalRez
    @SalRez 7 років тому

    Hey shad, thank you for the tutorials. I've learned a lot from you :) I just have one question. I have my invoice form, even designed it to my own preferences. Now when i want to save an invoice, say to pdf, or when i want to print it, it puts all the invoices together. It won't let me print or save them separately. How can I save or print my invoices separately?

    • @SalRez
      @SalRez 7 років тому

      Never mind good sir, I got it fixed :D Thank you again for the awesome tutorials. Keep up the good work

    • @manuelmantillamendez3215
      @manuelmantillamendez3215 5 років тому

      @@SalRez how did you fix it?

  • @emadabuhagag222
    @emadabuhagag222 3 роки тому

    great tutorial

  • @ikitzone9998
    @ikitzone9998 4 роки тому

    Thank you Sir

  • @Mzsmartdestroyer
    @Mzsmartdestroyer 3 роки тому

    Good one

    • @shadsluiter
      @shadsluiter  3 роки тому

      Thanks for the visit. Any topics you are wanting to study?

    • @Mzsmartdestroyer
      @Mzsmartdestroyer 3 роки тому

      @@shadsluiter thanks man for ur responce . I want creat inventory managment system for a news agency can u help me out by making vedio on that

  • @rameshpillai8273
    @rameshpillai8273 6 років тому

    HI Shad, i like the way you teach and developed an interest to know about MS Access. As a Warehouse Person, i need your help in creating a inventory database and to issue the Delivery challan inward or outward, as a result adding or deducting the stock. like wise to have record for all transactions occurred. please help me. how should i contact you. give me your mail id and conctact no.

  • @المعزصديق
    @المعزصديق 7 років тому

    usefull- thanks

  • @shanefrancis2182
    @shanefrancis2182 6 років тому

    Hi love the vids I have built a full retail database just need a bit of help to finish it off when I do an invoice how can I remove things from the invoice form pm me and I can send u set and u can try it please thanks
    Shane

  • @المعزصديق
    @المعزصديق 7 років тому

    thanks