Microsoft Access pt 10 - Invoice with Payment & Dlookup
HTML-код
- Опубликовано: 3 сен 2016
- In this video learn to create an Invoice with Payments & Balance. Also learn to use Dlookup. This video applies to all versions of Access. Link to sample file that included the sample database and notes: sites.google.com/view/simplet...
Thanks for video....I didn't have any knowledge about how to create Access database but this has helped to me to begin my study. Thank u so much
I was stuck on how to do the Invoicing for my customer tracking database. Thank you for your help!
Great video sir. Kindly upload a full video of power query, data uploading from SQL server, Azure in excel etc.
love this video
Informative & clear.
How to implement opening balance + receipts - payments = closing balance
Best guide line
Wonderful..thanks.
the best videos ever. thanks a lot
Wonderful..thanks الله يبارك فيك
Very nice
thanks aloooot
thank you so much
Thank you very much for the videos I have watched them several times as I make my database. I looked for the links to download the Notepad stuff such as formulaes and could not see/open them. The Access ones are there though. Please post them again here or on your website
not all videos have a sample file. For this video, there is a sample file, the link is in the description. The file is a zip file, so you can right click on it and save it to your computer first, and then open it. simpletek.ca/files/access-2013/
+Amir Parmar
hi
What is the use of before events after event and how?
Great Video :D I just have a question. Hopefully you can answer, Instead of adding a v/dlookup when I want to display customer information on the invoice, can I not just instead make the Customers table into a query and then add it as a sub report into my invoice so that I can have other details like a customer ID, name, address, phone number and etc.?
sure, many ways to approach it. You could add the info to the query, base the report on the query and drag the fields. Vlookup just adds another approach.
Thanks for the fast reply! Just one more thing, Is it possible to make a report based on the Customers query and then add both qrypayments and qryServiceparts as sub reports? If so would it still pick up information if I changed it. (For example if I typed in Customer ID 1 would it pick up all the information and change it accordingly like address and contact details associated with customer ID 1 )because it's all in a query with no Vlookup. Sorry if that sounded confusing XD
it should work. As the query has the criteria [Enter Customer Id] the report is running the query. So everytime you open the Report, it is running the query, as you enter 1, it will show you the details. if you close and open the report again, enter 2, it will show the details of 2.
Thanks so much, this really helped! :D
I have a access database showing some food items. Out of all items, only want to generate a cash memo only on the items, on which transaction has been made. For example, there are tea and coffee in the items on forms. But in Bill No.1 only coffee has been sold. So in the cash memo only coffee should appear and not tea. It is possible.
i am very appritiate sir🥰🥰🥰🥰🥰🥰🥰🥰💞💞
Hello Amir.
I been following along the video to learn how to replicate the database. Using your database files there was no problems. I tried recreating all the tables and relationships. When I get to the portion of the video on how to create queries I enter under OrderID Criteria Enter OrderID I get a "Type mispatch in expression error" Do you have any idea why?
How come you didn’t create a 1:many relationship between customer and service...?
Hi Mr Amir,
I have created petty cash in ms access 2007, kindly guide me about formulas (Credit-debit = Balance)
I have never done that, but below is a link that offers a solution
www.experts-exchange.com/questions/20451349/Total-in-Debit-Credit-and-Balance-query.html
Also look into Dsum
Sir, Please update a new video regarding medical like patient entry, billing, report etc.......
Sir can you plz teach how to make gst bill in access
Thank u
Hi thanks for that, I have may database that involves labtests payment criterias and test costs what I want is to enter payment criteria Of different funding groups like NHIF, CHF, PAPO and when I enter lab test the test costs display automatically something like x lookup how it does in excel I want it in MC ACCESS THANKS if one say B/S has different costs according to the funding ID say 1300, 5000, or 2000 respectivelly
i have tried to use this but it didn't work with me =DLookUp("f_name",[student_table],"student_ID = " & [student_ID])
finally i found it
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.
Hi A K, I have looked at this briefly, looks like the recommendation is not to use Autonumber for invoices, have a field for Autonumber, but make the Invoices either data type Text or number, so you can control the numbers.
Thanks for reply... but how can it increase.. please make a video on it.. that is tables and forms of Purchase / Sale / Payment / Receipt / Journal vouchers... then it will be a perfect application... if you know the things..
Sir please make the video on my query / problem regarding gap in sales invoice numbers as requested before 15 days......
please make this videos in Urdu :)
It is online now, go to the access playlist ruclips.net/user/ComputersHindiplaylists
Please make this video in hindi. thanksDinesh kedia
will do so soon.
hendi nagayidam, pashmi
Wouldn't it make more sense just to use excel 🤔