RitaMoloney
Registered User.
- Local time
- Yesterday, 21:15
- Joined
- May 6, 2004
- Messages
- 50
Hi,
I am really stuck on this and would really appreciate if anyone could help me out.
I am working on a small database that records the names of people that pay different types of parish collections and the amount they pay to each collection in a year.
At the moment I have two forms;
frmParishioners – the user enters or edits a persons details and on a subform assigns the different types of collections they will be paying too in the year, the number of collections in the year and the amount they pay at each collection.
frmCollections – by selecting a persons name the user can view each persons details. A list of the collections they are paying and details of the payments (two subforms).
This is all working fine so far.
The problem is I need to be able to view each person’s details by a specific year so that, when the user opens frmParishioners it will always open at the present year and show the collections being paid for that year only on the subform.
When a new year starts the users selects a parishioner and enters the new year, this will cause the subform to go blank and the user can enter the collections that the person will be paying for the following year.
On the frmCollection - when the user select a person all their details appear, I need it to appear for the present year only. Also, I need a drop down list showing all the previous years and if a previous year is selected it will only show that persons details for that year.
I also need this information to be passed to a report.
At the moment I am only using three tables
tblParishioners
tblCollection
tblAccDetails
I have added in another table called tblYears in order to hold the years but am not sure if this is the right approach. Hope this makes since. If anyone could help me out it would be great. I have attached the database.
Thanks in advance.
I am really stuck on this and would really appreciate if anyone could help me out.
I am working on a small database that records the names of people that pay different types of parish collections and the amount they pay to each collection in a year.
At the moment I have two forms;
frmParishioners – the user enters or edits a persons details and on a subform assigns the different types of collections they will be paying too in the year, the number of collections in the year and the amount they pay at each collection.
frmCollections – by selecting a persons name the user can view each persons details. A list of the collections they are paying and details of the payments (two subforms).
This is all working fine so far.
The problem is I need to be able to view each person’s details by a specific year so that, when the user opens frmParishioners it will always open at the present year and show the collections being paid for that year only on the subform.
When a new year starts the users selects a parishioner and enters the new year, this will cause the subform to go blank and the user can enter the collections that the person will be paying for the following year.
On the frmCollection - when the user select a person all their details appear, I need it to appear for the present year only. Also, I need a drop down list showing all the previous years and if a previous year is selected it will only show that persons details for that year.
I also need this information to be passed to a report.
At the moment I am only using three tables
tblParishioners
tblCollection
tblAccDetails
I have added in another table called tblYears in order to hold the years but am not sure if this is the right approach. Hope this makes since. If anyone could help me out it would be great. I have attached the database.
Thanks in advance.
