Windows 7 32bit 
Access 2010 32bit
I need help creating a method to recieve payments that update new dues by renewal date.
As an Access Newby, I am pulling my hair out over this one…
I am making a database for my Chamber of Commerce, which currently does not use any electronic database for membership. I have created a very nice form to input all the member information and even show if that member is a board member and/or a committee member. I already require the members record to be populated in the [Members] form to process any information or payments related to a member’s record. It has a great search feature to bring up the correct members info from any one of many fields.
1) 1) I need to have a way to set the Starting balance or add a debt in the [Balance] table with the value in the [TotalDues] field in the [Members] table. (Perhaps this can be done with a button from the [Members] form, after adding the dues information to the record. I don’t know.)
(The [Balance] table currently has [BalanceID](PK), [MemberID], [Date], [Debt], [Credit] and [Balance] fields.)
2) 2) I need to click the existing “Payments” button on my [Members] form that will open the [Payments] form, set the value for the [PaymentAmount] field in the [Payments] form with the amount in the [Balance] field from my [Balance] table and acAddform” to clear any other form data. Then I can accept a payment of any amount the in the [PaymentAmount] field. Click the “Accept
Payment” button on the [Payments] form to close the form and update the [Balance] field in the [Balance] table. (It’s more official then just closing the form with the standard close box.)
3) 3) There after, anytime I open the [Payments] form from a members form record, I need to set the value for the [PaymentAmount] field in the [Payments] form to the new running [Balance] from the [Balance] table, and I can accept a payment of any amount, click the “accept payment” and update the balance…etc…
4) 4) Finally I need the database to automatically add the value in the [TotalDues] field from the [Members] table to the running balance of that member record “on or after” the date in the [RenewalDate] field in the [Members] table. (Perhaps this calculation can be done during the “Auto Exec” startup for my database or when running a report of members with an amount in the [Balance] field of the [Balance] table.)
(Member records are auto numbered by the [MemberID] field and is the Primary key.)
Reply With Quote
