On 19 Apr 2004 18:18:44 -0700,
ma*******@yahoo.com (Marcus) wrote:
In my opinion Access (or if you're a purist: Jet) is not the best
database to implement this with. It lacks some of the robustness of
more competent database systems like Microsoft SQL Server (a light
version of which is included with Access 2000 and up).
Second you need a competent developer. If you are new to this (which
your questions seem to indicate), you owe it to the pensioners to
gracefully bow out. Unlike the marketing propaganda would have you
believe, you can't slap together a decent app with some point and
click and a few dozen lines of script - mostly wizard created.
Perhaps you can do the maintenance on the app once it has been written
by a professional.
Chances are I did not convince you. So here are some answers to your
questions:
* Formulas (equations) are put in the queries themselves as calculated
columns, or in expressions for the control source of a field on a form
or report.
* You print checks by creating a report laid out to cover exactly the
pre-printed form you already have.
* Annual tax info: just another report.
* Check writer 2000: I'm not familiar with. If it supports Automation,
that would be an obvious choice. If it's more of a mail/merge - style
application, you create a query that it can use as a data source.
* Better alternatives: see top of my message.
-Tom.
I have a question. I am currently responsible for updating the entire
payroll and pensioner system for several pension funds. I have made
the appropriate tables for demographics, home address, check mailing
address and other pertinent info for the smallest of the funds (27
people) to test out the setup. But before I was even done I have run
into several problems.
-Firstly, I cannot figure out how to put an Excel-type equation in.
All I need is for it to add up the pension to the Year To Date,
subtract FICA from pension, etc…
-And how the heck do I make the checks print? It needs to have all the
pertinent info and print a stub that shows deductions made and YTD. It
also needs to create a registry every time it prints. We already have
a dot-matrix printer check stock in place that my boss wishes to keep
printing on.
-Another nice thing is if it could automatically prepare the tax info
we have to mail out every year.
I tried Check Writer 2000 but the darn thing didn't want to work
right. Should I use that program, completely do it myself (help!) or
are there better alternatives outside of MS Access?
Thanks,
Marcus
