By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,486 Members | 2,067 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,486 IT Pros & Developers. It's quick & easy.

Emailing Form

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
Thanks for the suggestion. However, this is not what my supervisor
wants. He wants forms that can be e-mailed, approved or rejected, and
returned. How can I accomplish this?

Thanks,
JD

ga*********@cityofbristol.ac.uk (Galina) wrote in message news:<cc**************************@posting.google. com>...
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.