Some more questions on a social club database

[Patrick]

With the help by a number of fellows of this newsgroup, we have enhanced a
social club database with two tables - Staff and Payment. Payment table
contains details like EmpID / PaidYear / Payment Date / Amount / Comment.

We would like to ask some more questions re the enhancement.

1) Does it mean that we have to use Form and Subform to present staff and
payment details ?
2) If we have to enter new payment, does it mean that we can go to the
subform and enter 2010 (for current year) ?
3) End user would like to keep the old interface, i.e. checkboxes shown -
Year2005 / Year2006 / Year2007 / Year2008 ? I have tried but it seems that
with a single query, we are not able to get all checkboxes showing whether
there is payment at that year. Similarly, it seems that it cannot be shown
in reports ?
4) If the requirement is to get a combo box with choice of "No Payment" /
"Paid 1 Yr" / "Paid 2 Yrs" / "Paid 3 Yrs" and we have to update the subform
(for up to three rows if they pay for 3 years), does it mean that we still
have to create another table for the combo box so that its choice will
update the payment table ? If yes, it means that we have to update that
table each year !!!

Your advice is sought.

Thanks

 

[KARL DEWEY]

1) Yes.
2) enter 2010 (for current year) ? For data entry it would be PaidYear, not
current year. To view data already loaded then you would want current year
but you probably want to view all people in a continous form view for that.
3) we are not able to get all checkboxes showing whether there is payment at
that year. That is the problem with checkboxes, all your objects - tables,
queries, forms, and reports must be updated each year - so out with the old.
4) You provide no information about this combo so I can only guess and that
is a operator counts years and selects for display. Better would be to have
machine count using DCount function from payment table for display.

 

[Arvin Meyer [MVP]]

With the help by a number of fellows of this newsgroup, we have enhanced a
social club database with two tables - Staff and Payment. Payment table
contains details like EmpID / PaidYear / Payment Date / Amount / Comment.

We would like to ask some more questions re the enhancement.

1) Does it mean that we have to use Form and Subform to present staff and
payment details ?

You should, yes.

2) If we have to enter new payment, does it mean that we can go to the
subform and enter 2010 (for current year) ?

Or it would be preferable to enter the current date, which you can do in a
simple double-click event.

3) End user would like to keep the old interface, i.e. checkboxes shown -
Year2005 / Year2006 / Year2007 / Year2008 ? I have tried but it seems that
with a single query, we are not able to get all checkboxes showing whether
there is payment at that year. Similarly, it seems that it cannot be
shown in reports ?

My mother used to say "People in Hell want ice water" You can't get what you
want with checkboxes like that.

4) If the requirement is to get a combo box with choice of "No Payment" /
"Paid 1 Yr" / "Paid 2 Yrs" / "Paid 3 Yrs" and we have to update the
subform (for up to three rows if they pay for 3 years), does it mean that
we still have to create another table for the combo box so that its choice
will update the payment table ? If yes, it means that we have to update
that table each year !!!

You do not need 3 rows for 3 years. Add a field for number of years paid. If
you need to see when the next payment is due, use the DateAdd() function.