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

[@JustineMushivi]

WATCHING IT FROM ZAMBIA. THANKS

[@vijaykumarp2405]

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

[@datatechstutorials]

Thanks for watching out tutorials

[@Khuram_Shahzad]

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

[@datatechstutorials]

Thanks for the support sir.

[@Michiworkstechnologies]

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

[@datatechstutorials]

glad to hear sir

[@thatnepaligeek]

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

[@balentinikontokonstanti8808]

Congratulation. Nice video thank you

[@datatechstutorials]

you are welcome

[@datatechstutorials]

The link to the project is in the description everyone.

[@nathanyamis]

Very informative video. Thanks sir😊

[@datatechstutorials]

Welcome sir

[@KharrajM]

From Morocco thanks you bro ❤

[@datatechstutorials]

Thank you for sharing this commends

[@Amirkhan-bg3hu]

Sir Thank you Big problem solved

[@datatechstutorials]

Glad to hear.

[@casper7883]

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

[@datatechstutorials]

Nice to hear this sir

[@abdulhakimyasin7098]

Nice

[@datatechstutorials]

Thanks

[@LengweChanda]

woinderful

[@sumardjo]

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

[@datatechstutorials]

You're welcome

[@moundirhzr2596]

thank u i love u

[@datatechstutorials]

so glad our video has helped.

[@scubarandy100]

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]

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

[@Michaelkafui]

You're good😊

[@datatechstutorials]

Thanks 😅

[@donomondi3595]

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

[@datatechstutorials]

okay sir. I will do well to ensure that

[@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?

[@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

[@mthangzou]

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

[@datatechstutorials]

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

[@machaxmsa3493]

Please help me in the receipt where condition mine not working ​@@datatechstutorials

[@blessedkidav7551]

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

[@datatechstutorials]

Will try upload on that soon.

[@kenyanoxide]

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

[@datatechstutorials]

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

[@tasangngu4624]

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

[@datatechstutorials]

Hello sir. can you reach out? thanks

[@felixasamoah866]

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]

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]

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