Recent content by Mebd

Hi Arnelgp, you demo file worked a treat. That is exactly what I needed. Now how do I take your code and enter it into my database. Remember that I am new to all this, thanks.

Hi Arnelgp, apologies for the late response and thanks for the demo and I will try to replicate this on my database. will let you know how I get on

Hi Pat, Yes this is a conversion based on paper records. The fee amount does change but not each year. The 'how do I know when the fee was paid' question is my next stage that I will post on.

Hi Arnelgp, Thanks for coming back. I'm new to all this so need step by step help. Where do I paste code suggested code?

Hope some can help here? I have a membership database and I want to create a form that records membership dues. What I need to happen is when we create a member, based on the date of their membership and current year, it will insert correct number of rows. For example, a member joins in 2018...

No, just from here? Should I have done so?

Hi Pekajo, This looks to be what i may be looking for. Can you kindly send me a copy, please?

That's a good point Gasman, there is also a requirement to take a member who passes away for us to insert Spouses name without any membership dues. Also, can a member record hold attachments, say their actual membership form they completed? The more I think about it the more complex this gets.

Thanks everyone. Having read and looked at the sample dbase I think that I need as follows; Members Table - One unique record per member (Personal Details, Contact Details) MembershipStatus Table - One record per member (Fully Paid, Retired, Student, Widow, etc) MembersAddress Table - many...

Thanks theDBguy, will do that.

Thanks Pat Will review what you attached and let you know.

That is great, will play with that and see how I get on. Will you be able to help if I need to know 'how do I do...' type questions?

Thanks gasman, I have 2013 but there doesn't see o be one that fits. I'll look at the links provided. Thanks

Hi, New to all this, but can someone suggest if there is place to download template (or if someone already has one) for Attendance/Membership and membership fees. Looking to create this for a local community club. Thanks.