stewardship/charitable church contributions

I'm not selling. Consider it a gift. If it works for you, great. If not, no
problem. It's written in access 97 and upreved to 2003. Write to me at
bwaggoner [here's the rest of it] @aircanopy.net Send me an e-mail and I'll
get it to you. You can adapt it as needed.





"Sewingmom" wrote:

that sounds great. If no one else is using it then I will be glad to take
off your hands, how much did you say?





"Bob Waggoner" wrote:

50 entries is one service - even at a little church (I know, I pastored a
little church). I wrote the database still in use at Dyess AFB, Texas. [Call
the chapel there and talk to Yvonne].

Tables include: [tblTithes&Offerings] and [tblNames]

Tithes&Offierings fields include: [LiChkID] (autonumber primarykey);
[LiCheckNo] (Long Integer for recording the number on the check or envelope);
[txtLastName] (txt field); [txtFirstName] (txt field - you can rejoin the
names in queries or reports later but keeping them separate helps sorting
issues); [CurAmount] (currency field for amount of check or cash offering);
[dteDate] (Date on the check or today's date if cash - set the default to
Date() and then just change it as needed). You can add any other fields you
want. [Also, you could create a simple code for the date field that will put
in today's date with a double-click event if you don't want it to be the
default for the record you create.

If you are not familiar with Access Queries, reports and / or VBA - I'll be
happy to walk you through (using this forum) writing queries and reports to
extract just the information you need. It's a great learning experience and
not very complicated. Plus, it's a lot cheaper doing it yourself than paying
for something off the shelf that goes overboard.



"Sewingmom" wrote:

thanks for all the help i found one that will work for now. It only allows
up to 50 entries before we have to start paying though.
it is called church trac. It is very good I just hate that we will have to
pay later


"Bob Waggoner" wrote:


I wrote a database for the Air Force chaplain service that will do what you
want.
You're welcome to it. It tracks contributions and creates reports to send to
contributors regarding their annual contributions.
It also tracks attendance and has a few other features. The person using it
was not a database expert when I wrote it.

Maybe someone can tell me how to contact sewing mom without either of us
getting inundated with junk mail.

RC W
"Sewingmom" wrote:

that does sound a bit overkill for what we need but thanks.

"BBC via AccessMonster.com" wrote:

I am in the process of developing a DB for a charitable organization
(supporting children & families in Africa). It is not ready for final
release but is about to start inital user testing. It is fairly complex and
might be overkill for your needs, "manages" clients (demographics),
contributions, child or project sponsorships, events/projects (ex fund
raisers), client interests, and will have a very basic product inventory and
sales component.
Would Excel do what you need.


Sewingmom wrote:
does anyone know of a free program that i can use for recording my church
contributions for a little church? There are some good programs out there
but right now we don't have the finances to purchase, they are so expensive.
I would love one that is somewhat close to this example.
http://www.powerchurch.com/images/ca...product/co.gif

we are looking to record by envelope numbers/names

--
Thanks
Brian

Message posted via http://www.accessmonster.com