Hello
It is possible to develop something like you describe, but may be you
will want to consider simpler way, which can be realised with MS
Access and doesn't involve sending forms via e-mail.
Place you database's backend on network and the front end on
everyone's PC. Create a form for users to fill in their requests.
Request's data goes into the backend.
You supervisor has got a form to check the request data. At the
moment, when user submitted his request, it is available for the
supervisor to view. He can enter corrections, or to click "Rejected".
At the moment, when supervisor submitted his corrections, they are
available to the user.
E-mail can come handy, because users and superviser will not look into
the database all the time. When user submits his request, an automatic
e-mail can be generated from MS Access informing the superviser that
there is something new in the database. Also, an automatic e-mail will
inform user about the supervisor corrections and decisition.
One of the advantages of filling in the data by user into database,
that your supervisor will not need to do it him/herself.
Hope it will be of interest to you.
Galina
jd****@yahoo.com (jd****@yahoo.com) wrote in message news:<75**************************@posting.google. com>...
I developed a small database for my supervisor that tracks the dates
employees wish to schedule for vacation, how many days they are
eligible for, how many they have taken, etc. He asked me if it is
possible for the employee to email the "form" he has completed to his
supervisor, who in turn would approve or reject the dates requested,
and email the "form" back to the employee. We would, of course, need
some type of authentication process. I'm sure I will have to use
another program other than Access (97, by the way) to do this. Does
anyone have any ideas how to do this?
Thanks,
JD