Recurring item payment

[Guest]

I would like to use a version of Duane Hookom's recurring database for
reservations. I have modified it and all is well so far. I can enter the
reservation and have it duplicate the info while only changing the dates. Is
there a way to add payments to this database? When someone reserves a gym,
meeting room, ballield, etc., payment is also due at that time. But, the
payment is for all the recurring items (someone pays once for their multiple
reservations and organizations pay once for ballfield use all season). The
department is currently using a different database with a payments table.
Payment are input on a payment subform, so the payment can be tied to it's
corresponding reservation.

The current payment table includes:
Payment ID AutoNumber
ReservationID Identifies reservation
ReceiptNum Number
DatePaid Date/Time
HowPaid (Check cash credit) Linked to PaymentType table
CheckNum Number

My question: Can a payment option be added to Duane's Recurring DB? Does it
require a separate payment table as well? Would it be similar to the above
table?Will it correspond to each separate reservation or the 'group' of
recurring reservations? Can payments be input from the same scheduling form
as the reservations?
I just need a few expert opinions and I can take it from there.
Thanks for all your help.

 

[Duane Hookom]

You would need to add a table of scheduling transactions. The primary key
from this table would need to be stored in a field in tblSchedule and
tblTempSchedDates.

tblSchedTrans
===============
sctScTID autonumber Primary key
this would be similar to your Reservation ID
sctTransDate Date of the transaction
sctComments notes about the schedule
sctAmount cost or possibly payment
sct...

Add the field
tblSchedule and tblTempSchedDates
====================
....
tscScTID or schScTID long integer link to
tblSchedTrans.sctScTID

You might want to bind the form "frmMultiSchedule" to the new table.

cmdBuildSchedule would need to include the new sctScTID field value.

 

[Guest]

Thanks again.
I'll do this and we will see how it turns out.

One more thing, while I got you here. After I have reviewed the items in the
Temp. table (from the Temporary Tab), I then choose to append them to the
Perm. table. After I append the records and I go to the Permanent Schedule
tab (3rd tab) to see the permanent schedule. I just see a blank subform
(based on the Perm. table). Are you supposed to see the permenent items
after they have been appended? If not, why? Do I need to refresh something?

Sorry for all the ????'s.....

 

[Duane Hookom]

Actually, there should be a Requery or the 3rd tab subform at the end of the
code to append the temporary schedule to the permanent. You could also right
click in a row of the 3rd tab and select "remove filter/sort".

Private Sub cmdAppendToPermanent_Click()
DoCmd.OpenQuery "qappTempSchedToPermanentSched"
'this next line should be added ;-)
Me.sfrmScheduled.Requery
End Sub

 

[Guest]

Adding the payment information like you suggested worked out great. I also
added the Requery line to the permanent schedule form (3rd tab) which works
as well.

Thanks again for your time. I'm sure I'll have more questions later...