If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do i set up a club in Access?
I want to set up a database for a rugby club with various details held on
members including type (Ordinary; Associate; Senior Citizen) which affects how much they pay. Each year I want to re-set status when money is due & keep a record of dues paid, ideally automatically updating status (& ideally creating aleeter / form to acknowledge receipt). I would also like to be able to write to various categories / statuses of members (e.g. when subs due). |
#2
|
|||
|
|||
I am in business to provide customers with a resource for help with Access,
Excel and Word applications. My fees are very reasonable. By the nature of your question, it is apparent you need help in creating the database you want. I can create this database for you. Contact me at my email address below if you want my help. -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com "IainADove" wrote in message ... I want to set up a database for a rugby club with various details held on members including type (Ordinary; Associate; Senior Citizen) which affects how much they pay. Each year I want to re-set status when money is due & keep a record of dues paid, ideally automatically updating status (& ideally creating aleeter / form to acknowledge receipt). I would also like to be able to write to various categories / statuses of members (e.g. when subs due). |
#3
|
|||
|
|||
I am involved with this type of database (club). We're now working on the
second year of development (over 100 emails from here to the UK). It may seem easy, but I can see you have many of the complications we faced. This can (and will) quickly grow out of bounds. My Advice -- 1. This is not a project for the beginner 2. Get some professional and/or volunteer help Ed Warren "IainADove" wrote in message ... I want to set up a database for a rugby club with various details held on members including type (Ordinary; Associate; Senior Citizen) which affects how much they pay. Each year I want to re-set status when money is due & keep a record of dues paid, ideally automatically updating status (& ideally creating aleeter / form to acknowledge receipt). I would also like to be able to write to various categories / statuses of members (e.g. when subs due). |
#4
|
|||
|
|||
Office.microsoft.com has an Access template called "Membership" that you
might be able to adapt to your needs. Check it out at http://office.microsoft.com/en-us/te...185841033.aspx hth, LeAnne IainADove wrote: I want to set up a database for a rugby club with various details held on members including type (Ordinary; Associate; Senior Citizen) which affects how much they pay. Each year I want to re-set status when money is due & keep a record of dues paid, ideally automatically updating status (& ideally creating aleeter / form to acknowledge receipt). I would also like to be able to write to various categories / statuses of members (e.g. when subs due). |
#5
|
|||
|
|||
Thank you - it will be a good start but looks like a steep learning curve!
"LeAnne" wrote: Office.microsoft.com has an Access template called "Membership" that you might be able to adapt to your needs. Check it out at http://office.microsoft.com/en-us/te...185841033.aspx hth, LeAnne IainADove wrote: I want to set up a database for a rugby club with various details held on members including type (Ordinary; Associate; Senior Citizen) which affects how much they pay. Each year I want to re-set status when money is due & keep a record of dues paid, ideally automatically updating status (& ideally creating aleeter / form to acknowledge receipt). I would also like to be able to write to various categories / statuses of members (e.g. when subs due). |
#6
|
|||
|
|||
Suggest you reread Ed's response and heed his advise!
-- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com "IainADove" wrote in message ... Thank you - it will be a good start but looks like a steep learning curve! "LeAnne" wrote: Office.microsoft.com has an Access template called "Membership" that you might be able to adapt to your needs. Check it out at http://office.microsoft.com/en-us/te...185841033.aspx hth, LeAnne IainADove wrote: I want to set up a database for a rugby club with various details held on members including type (Ordinary; Associate; Senior Citizen) which affects how much they pay. Each year I want to re-set status when money is due & keep a record of dues paid, ideally automatically updating status (& ideally creating aleeter / form to acknowledge receipt). I would also like to be able to write to various categories / statuses of members (e.g. when subs due). |
#7
|
|||
|
|||
how do i set up a club in Access?
"IainADove" wrote: I want to set up a database for a rugby club with various details held on members including type (Ordinary; Associate; Senior Citizen) which affects how much they pay. Each year I want to re-set status when money is due & keep a record of dues paid, ideally automatically updating status (& ideally creating aleeter / form to acknowledge receipt). I would also like to be able to write to various categories / statuses of members (e.g. when subs due). |
#8
|
|||
|
|||
how do i set up a club in Access?
Firstly you need to work out the tables in your system. Example you
will have a members table, but there are probably others. Then create the relationships between your tables. From there you can start to sketch out your forms. The table will sit behind the form or it may be a query. It sounds like you have a lot of conditions in your database also. For FREE Access ebook and videos click here http://access-databases.com/ebook On 20 Jan, 06:31, rystali'2yahoo.com. wrote: "IainADove" wrote: I want to set up a database for a rugby club with various details held on members including type (Ordinary; Associate; Senior Citizen) which affects how much they pay. *Each year I want to re-set status when money is due & keep a record of dues paid, ideally automatically updating status (& ideally creating *aleeter / form to acknowledge receipt). I would also like to be able to write to various categories / statuses of members (e.g. when subs due). |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to get data from Analysis Services cubes into Access | General Discussion | 2 | December 4th, 2004 02:21 PM | |
is Access 2003 any better than XP? | Gorb | General Discussion | 4 | November 11th, 2004 09:44 PM |
is Access 2003 any better than XP? | Gorb | Using Forms | 2 | November 11th, 2004 09:20 AM |
MICROSOFT INVESTING HEAVILY IN ACCESS | Mike Painter | General Discussion | 39 | October 15th, 2004 03:56 PM |
Access 2000 DB in Access 2002 | Tony_VBACoder | General Discussion | 2 | July 28th, 2004 01:23 AM |