Volunteers database in access needed please

Latest post 07-14-2009 5:12 PM by bobalston. 2 replies.

Volunteers database in access needed please

06-24-2009 7:05 PM

Hello everyone,

I took on the responsibility of creating a new MS Access database for Volunteers event/hour tracking. 
 
Here’s what I have so far:
3 tables (Personal, event, Personal_event). 
The personal tables hold contact information and an “hours” field to record their hours worked. The event tables hold the event information including name, data, location, etc. The last table is a join table for the many-to-many relationship between the first two tables.
 
Here’s where I’m hitting the wall at. I can get form/subform to work correctly. Meaning I can’t seem to get the correct information to pop-up. My thought I somewhere in the relationship or the form-design isn’t correct.
 
I’ve read other posts here asking for the same thing. However no real templates were provided. The only thing that came close was VMS program but that’s way of an overkill for what we are trying to do.
 
If someone have an Access template 2003/2007 to track Volunteers hours for events and willing to share. Please let me know. Thanks in advance

Re: Volunteers database in access needed please

06-27-2009 10:24 AM

You might try posting your request for an Access template to track volunteers to some volunteer management discussion groups, such as CYBERVPM, UKVPMs, and OzVPM. I've got a list of volunteer management databases, and at least one is free and built on Access. And if you could check back later and let us know what you go with, that would be terrific.

Re: Volunteers database in access needed please

07-14-2009 5:12 PM

You cannot do a many-many relation directly with Access.  There are ways to do it but they require some expertise.

Here is a nice list of volunteer management software  www.coyotecommunications.com/tech/volmanage.html

 

Bob