How to create Customer Payment Receipts in ANY Microsoft Access Database Project

No video

How to create Customer Payment Receipts in ANY Microsoft Access Database Project

Рет қаралды 43,551

Күн бұрын

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.c...

Пікірлер: 48

@vijaykumarp2405 26 күн бұрын

Thank you so much, you have explained with lot of patience and with full detailing.....thank you

@datatechstutorials 20 күн бұрын

Thanks for watching out tutorials

@Michiworkstechnologies 3 ай бұрын

This is helpful video Mr.Arko Smaila indeed i have got a point for what I have been looking for.

@datatechstutorials 3 ай бұрын

glad to hear sir

@Khuram_Shahzad Жыл бұрын

Nice Sir, it's good to see that you are taking care of naming conventions

@datatechstutorials Жыл бұрын

Thanks for the support sir.

@dikshyant2.042 3 ай бұрын

A big thanks to you!! It helped me for making my project.

@datatechstutorials Жыл бұрын

The link to the project is in the description everyone.

@JustineMushivi 4 ай бұрын

WATCHING IT FROM ZAMBIA. THANKS

@balentinikontokonstanti8808 8 ай бұрын

Congratulation. Nice video thank you

@datatechstutorials 8 ай бұрын

you are welcome

@moundirhzr2596 2 ай бұрын

thank u i love u

@datatechstutorials 2 ай бұрын

so glad our video has helped.

@donomondi3595 2 ай бұрын

great video. next time please would you create timestamps for us please for follow up. maybe if some part isnt entirely understood?

@datatechstutorials 2 ай бұрын

okay sir. I will do well to ensure that

@LengweChanda 2 ай бұрын

woinderful

@scubarandy100 2 ай бұрын

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

@datatechstutorials 2 ай бұрын

Hello, you have an invoice database you want us to include? feel free to share the database

@casper7883 8 ай бұрын

Very helpful. Maybe ill make a lesson study from you...

@datatechstutorials 8 ай бұрын

Nice to hear this sir

@nathanparasafayamis781 5 ай бұрын

Very informative video. Thanks sir😊

@datatechstutorials 5 ай бұрын

Welcome sir

@sumardjo 2 ай бұрын

Thanks for file Sample Project thanks very much....

@datatechstutorials 2 ай бұрын

You're welcome

@Amirkhan-bg3hu 10 ай бұрын

Sir Thank you Big problem solved

@datatechstutorials 10 ай бұрын

Glad to hear.

@jerryimahiagbe1949 Жыл бұрын

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.

@datatechstutorials Жыл бұрын

Didi it not work after watching this video?

@kenyanoxide 3 ай бұрын

smaila suppose a system allows for clients to apply for full sevices or a number of the services how do you print receipts

@datatechstutorials 3 ай бұрын

this involve a lot that needs to be discussed. Feel free to email

@blessedkidav7551 Жыл бұрын

Good work Sir Please can I get tutorials on church database?

@datatechstutorials Жыл бұрын

Will try upload on that soon.

@BahaiofLiberiatv Жыл бұрын

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.

@datatechstutorials Жыл бұрын

okay, will definitely consider this sir

@Michaelkafui 4 ай бұрын

You're good😊

@datatechstutorials 4 ай бұрын

Thanks 😅

@mthangzou Ай бұрын

Hello bro.. The print receipt conditions =" (PaymentID) =" & (PaymentID) is not working for me! What should I do? Help

@datatechstutorials 9 күн бұрын

sorry for late feedback. use “(paymentid)=“&”’”&”(paymendid)”&”’” als make sure you are using square brackets instead.

@tasangngu4624 Ай бұрын

Hello sir greetings, Please i can't see the macro well to open report. Please could write it down. Thanks

@datatechstutorials 28 күн бұрын

Hello sir. can you reach out? thanks

@felixasamoah866 5 ай бұрын

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

@datatechstutorials 5 ай бұрын

sorry for this. can you try this: "paymentid="&"'"&"paymentid"&"'"

@blasiomarvinwasenda Жыл бұрын

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?

@patrick_the_technician Жыл бұрын

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.

@datatechstutorials Жыл бұрын

have you been able to do this?

@blasiomarvinwasenda Жыл бұрын

@@patrick_the_technician okay, let me try this and c the outcome. 🙏 Thanks

@blasiomarvinwasenda Жыл бұрын

@@datatechstutorials Do what? The form for payment?

@Michiworkstechnologies 3 ай бұрын

This is helpful video Mr.Arko Smaila indeed i have got a point for what I have been looking for.