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

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

DataTechs Tutorials

1 год назад

37,470 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

Muhammad Amir
Muhammad Amir - 06.10.2023 22:39

Sir Thank you Big problem solved

Ответить
Baha'is of Liberia Tv
Baha'is of Liberia Tv - 09.06.2023 12:47

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.

Ответить
Marvin_Hub
Marvin_Hub - 24.05.2023 09:29

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?

Ответить
Jerry Imahiagbe
Jerry Imahiagbe - 03.05.2023 02:54

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.

Ответить
Blessed Kidav
Blessed Kidav - 17.03.2023 20:24

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

Ответить
DataTechs Tutorials
DataTechs Tutorials - 17.03.2023 18:42

The link to the project is in the description everyone.

Ответить
khuram shahzad
khuram shahzad - 17.03.2023 11:15

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

Ответить