How to create Customer Payment Receipts in ANY Microsoft Access Database Project
HTML-код
- Опубликовано: 16 мар 2023
- CREATING PAYMENT RECEIPTS IN MS ACCESS DATABASES
Hello guys, thank you for tuning into this wonderful Microsoft Access tutorial. In this video, I am going to share with you on how to create payment receipts in your Microsoft Access Database projects.
Issuing receipts is needed mostly in POS, School Management System, Hospital System, Church System, etc,
In this lesson, we create a very basic "customer payment" database to be used in illustrating the concept. Find below the link to download the project.
Thank you for your supports.
drive.google.com/file/d/1VbhQ...
woinderful
A big thanks to you!! It helped me for making my project.
WATCHING IT FROM ZAMBIA. THANKS
This is helpful video Mr.Arko Smaila indeed i have got a point for what I have been looking for.
The link to the project is in the description everyone.
thank u i love u
so glad our video has helped.
Nice Sir, it's good to see that you are taking care of naming conventions
Thanks for the support sir.
Congratulation. Nice video thank you
you are welcome
Thanks for file Sample Project
thanks very much....
You're welcome
This video was helpful to create a way to enter payments from a customer. Can you show us how to apply these payments to an invoice that was created already
Hello, you have an invoice database you want us to include? feel free to share the database
Very informative video. Thanks sir😊
Welcome sir
Sir Thank you Big problem solved
Glad to hear.
Very helpful. Maybe ill make a lesson study from you...
Nice to hear this sir
Thank you very much. I was able to create one following your tutorial. I feel very happy. Please I want to know. How do I generate receipt for an old payment already in the database? I tried but was not able to go back and generate.
Didi it not work after watching this video?
Good work Sir
Please can I get tutorials on church database?
Will try upload on that soon.
great video. next time please would you create timestamps for us please for follow up. maybe if some part isnt entirely understood?
okay sir. I will do well to ensure that
You're good😊
Thanks 😅
smaila suppose a system allows for clients to apply for full sevices or a number of the services how do you print receipts
this involve a lot that needs to be discussed. Feel free to email
Please help and a create full movie on how to create a automatic banking for saving, crediting, deposit, with mutiple user accounts in Ms access please.
okay, will definitely consider this sir
I got to print receipt command and and clicking on it gave me “Data type mismatch in criteria expression “
I clicked on and Error Number 2950 came up
“Arguments: Lawmed Payments Receipt, 5, , [Payment ID]=001, Normal
Help me out I’m stuck bro
sorry for this. can you try this: "paymentid="&"'"&"paymentid"&"'"
this was helpful, i am trying to create a database for members in a SACCO, about this specific form. I needed some help on the make payment button, i have accomplished most of what i want it to do but i am still facing an issue of printing out a specific record. This is the VBA code i am using;
Private Sub Command13_Click()
' Save the current record
DoCmd.RunCommand acCmdSaveRecord
' Creating a new record in the Payments table
DoCmd.GoToRecord , , acNewRec
' Saving the specific member's name to a variable
Dim memberName As String
memberName = Nz(Me.Member_Name.Value, "")
' Checking if the memberName variable is empty
If memberName "" Then
' Print the payment report for the specific member
DoCmd.OpenReport "Rt_Receipt", acViewPreview, , "Member_Name = '" & Replace(memberName, "'", "''") & "'"
' Printing the report
DoCmd.PrintOut
' Closing the report
DoCmd.Close acReport, "Rt_Receipt", acSaveNo
Else
' Displaying a message if memberName is empty or Null
MsgBox "Please enter a valid member name."
End If
End Sub
can u help me, what am i missing?
I think it would be simpler if you can create a form, then add a text box or combobox where you will be entering the required member unique field then create a query that will filter data based on the record enter and then create a report on the same.
have you been able to do this?
@@patrick_the_technician okay, let me try this and c the outcome. 🙏 Thanks
@@datatechstutorials Do what? The form for payment?
This is helpful video Mr.Arko Smaila indeed i have got a point for what I have been looking for.
glad to hear sir