Form for payments - Access 2003

  • Thread starter Thread starter Nomy
  • Start date Start date
N

Nomy

Hi,

I'm building a database to record payments for martial arts classes. Most
students pay on a monthly basis. Students have different begin dates and
monthly payments are due one month after registration. Ex: registration is
5/3/09 so payments are due on the third day of each month. How can I have
the DateDue post automatically in my subform so I don't have to enter this
every month. The purpose is to have Access post an automatic late fee if
paid X # of days late.

I have a parent form for the student classes with tuition amount, a begin
date and end date, and a monthly payment
amount. In the subform, I have the fields DateDue, AmountDue, DatePd and
AmountPd.

Thanks.
Joy
 
Nomy,
Well, most probably you don't want it to enter "automatically"... you'll
be
better off using some logical event to "fire" the 1 month DueDate add...
You could double-click the blank DueDate on a new subform record. The
double click would fire code to determine the maximum DueDate currently
exisiting (for that member), and placing a value one month greater in the
new
record's DueDate.
Aircode...
Private Sub DueDate_DblClick(Cancel As Integer)
LastDueDate = DMax DueDate in the subform for that MemberID
Me.DueDate = DateAdd("m",+1, LastDueDate)
End Sub
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Al,
Thanks so much for your help. I'm sorry for not thanking you sooner, but I
was unable to check the news group for several days due to illness. Your
advice makes sense and I'm trying it now.

Thank you again.
Nomy
 
Back
Top