FEES PROGRAM

[Guest]

i WORK IN A SCHOOL AND INTEND TO PROGRAM A FEES COLLECTION. WE COLLECT FEES
IN 2 TERMS AND THE STUDENT HAS THE OPTION OF PAYING IN INSTALLMENTS IN EACH
TERM. WE ALSO GIVE DISCOUNT TO SECOND CHILD ON CERTAIN FEES. I WOULD LIKE
SOMEONE TO HELP IN DESIGNING THIS ONE FOR PREPARING THE STATEMENT OF FEES TO
BE PAID, GENERATING RECEIPTS OF THE FEES, KNOWING THE BALANCE OUTSTANDING AND
ALSO CREATING THE LEDGER OUT OF IT.

THANKS IN ADVANCE

 

[Arvin Meyer [MVP]]

I'm sure that you understand that it is well beyond the scope of this forum
to write an entire program for you. We can, however, answer any specific
questions about how to design or program a part of it. Also, please refrain
from typing in all caps. It makes your text hard to read and is considered
by most to be shouting.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[PC Datasheet]

Contact me.

 

[StopThisAdvertising]

Contact me.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1100 users have come to me from the newsgroups requesting help
(e-mail address removed)

--
To Steve:
Over 300 users from the newsgroups have visited the website to read what kind of a 'resource' you are...

To the original poster:

Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html (updated)

Arno R

 

[John Marshall, MVP]

The expert in fee collection from a free support newsgroup.

Stevie, you know the drill. These newsgroups are for free support, not a
means to con community members out of their hard earned cash.

John... Visio MVP

Need stencils or ideas? http://www.mvps.org/visio/3rdparty.htm
Need VBA examples? http://www.mvps.org/visio/VBA.htm
Common Visio Questions http://www.mvps.org/visio/common_questions.htm
Visio Wishlist http://www.mvps.org/visio/wish_list.htm

 

[Guest]

I apology for writing in caps. Dear frnd, I have linked up 3 tables: fees
mater table, student master, receipt master. The main form is student master
and receipt table being the subform. We collect fees in 2 terms. when i
update the fees collected the balance amount has to be updated and if any
balances still has to be carried forward to the 2nd term. how do I write the
code for generating the fees in two terms.

I want :
1) send statement of accounts - like the fees to be paid,
2) Generate receipts for them when they pay
3) Carry foward the balance amount in the 2nd term.
4) Reports of balances, receipts, ledger

I would you would resolve my issue

 

[Arvin Meyer [MVP]]

Answers in line:

I apology for writing in caps. Dear frnd, I have linked up 3 tables: fees
mater table, student master, receipt master. The main form is student master
and receipt table being the subform. We collect fees in 2 terms. when i
update the fees collected the balance amount has to be updated and if any
balances still has to be carried forward to the 2nd term. how do I write the
code for generating the fees in two terms.

You don't really need code. Use an Append query instead something like:

INSERT INTO [Fees Master] ( [StudentID], Amount )
SELECT [StudentID], CCur(100) AS Fee
FROM [Student Master];

That will add a record of $100 for each student in the Strudent Master
table.

I want :
1) send statement of accounts - like the fees to be paid,

After you add the fees to the table, run a report based on a query which
will show the new balance due.

2) Generate receipts (a report) for them when they pay

Again, run a report as you enter the paid amount into the field in a form
based on the Fees Master table.

3) Carry foward the balance amount in the 2nd term.

You can use another append query (I prefer this method) or you can build an
Update query to change the existing amount. I'd rather use the Append method
because it allows for new students and drop-out which happen during the
first term or in the interim.

4) Reports of balances, receipts, ledger

Again, write the queries which show the balances, receipts, etc. and base
reports on them.

It will take some effort on your part to learn the program. Understand, that
unless you'd like to hire someone to do it for you, we can only provide
answers to specific questions.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access