Комментарии:
Sir Thank you Big problem solved
Ответить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.
Ответить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?
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.
ОтветитьGood work Sir
Please can I get tutorials on church database?
The link to the project is in the description everyone.
ОтветитьNice Sir, it's good to see that you are taking care of naming conventions
Ответить