constructing database question

[mel waite]

I want to create a database using Microsoft access 2003 that is relatively
straightforward; it is for a new club that I'm starting. It is quite as
small club with only about 100 members maximum, I have searched for a
Microsoft access template, but had no success, and most ready-made database
programs I have looked at are far too complicated for my needs which are
very basic. I know enough to create the database which would include normal
club membership details, such as name address telephone details etc but the
one field I am stuck on is, membership renewal payments, I need to be
reminded automatically when my member's fees are due. I offer membership on
a weekly, monthly, or yearly basis, and what I need is for an automatic
pop-up box to inform me a couple of days before the renewal due date, that
my members, membership fees are due, so that I can then contact that member
to inform them of this and hopefully they will renew their subscription
before the expiry date. I am hoping there is some way of doing this is
automatically within Microsoft access, as I only have basic programming
skills. Any help will be greatly appreciated.

 

[Rick B]

Please post each question once. If you want it in multiple groups, then you
should do so by entering all the newsgroups in the one post.

http://www.mvps.org/access/netiquette.htm

 

[mnature]

Membership database template:

http://office.microsoft.com/en-us/templates/TC010185841033.aspx?CategoryID=CT011366681033

 

[mel waite]

Thanks for the info...i have downloaded this Membership database template,
but unfortunately it doesnt seem to have the facility to remind me
automatically when payments are due, which is what I really need .....but
thanks for trying anyway , it is appreciated.
Mel

 

[Craig]

this is not an elegant way to do this but you could try...
include field (either in this table or related to another table) with the
number of days that the member has to pay after e.g. 7 days, 30 days and 365
days. make sure that you have a start date, and presumably you will have a
separate table that tracks when they paid their subscriptions. so then

Add the delegates name id and the following in another column
HowManyPaymentsRequiredNow()-[startdate])/[periodquantity] this will
calculate how many payments there should have been, where periodquantity is
set in your table (7 or 30 or 365 etc)
then add the nameid again and from the total row set the option to COUNT.
then in another column
IsPaymentNeeded: [HowManyPaymentsRequired]/[countofname] where countofname
is the name of the nameid column. (if this value is over 1 then they will owe
you money)

then to create your list
create another query which lists all the details from the delegates table
that you need (name address etc) add the query that you created above and
link the nameid columns.
add the IsPaymentNeeded field that you created above and set the criteria to
be >1 and bobs your uncle - create your report on this query and you will
have your list.

(innacurate due to the number of days in months and years etc - but if you
just want a quick solution ...)