HTML Form

Hi,

I would like to write a program that will trigger at a scheduled date every
month. This program is to generate an email to be sent to the supervisors on
the employee oustanding leave application approval. Therefore, in the email,
I'll list out all the employees under the supervisor where the leave
application that are pending for the supervisor's approval. To make it easy
for the supervisor, I'd have a checkbox next to each of the listed out record
to allow the supervisor to select and make the approval or rejection.
My problem is that I'm able to generate the email and the list of records,
but I do not know or what way to post the selected values to update the
database. Hope you experts out there can give me some hint and guidance to
work on this.
Many thanks in advance.

Regards.

Kevin
Fri Oct 14 04:16:57 CDT 2005

I don't see any need to put this into a web site. It has nothing to do with
a user visiting a web site. It sounds more like a Scheduled Task to me. As
to how to go about writing it, have you had a look at InfoPath? See:

http://www.microsoft.com/office/infopath/prodinfo/default.mspx

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
Ambiguity has a certain quality to it.

"Seok Bee" <seokbee@yahoo.com> wrote in message
news:5E809253-00C2-4890-992D-211678E64E4A@microsoft.com...
> Hi,
>
> I would like to write a program that will trigger at a scheduled date
> every
> month. This program is to generate an email to be sent to the supervisors
> on
> the employee oustanding leave application approval. Therefore, in the
> email,
> I'll list out all the employees under the supervisor where the leave
> application that are pending for the supervisor's approval. To make it
> easy
> for the supervisor, I'd have a checkbox next to each of the listed out
> record
> to allow the supervisor to select and make the approval or rejection.
> My problem is that I'm able to generate the email and the list of records,
> but I do not know or what way to post the selected values to update the
> database. Hope you experts out there can give me some hint and guidance to
> work on this.
> Many thanks in advance.
>
> Regards.

p
Fri Oct 14 21:33:37 CDT 2005

Hint: Those are 3 separate "tasks."

Task 1. Create email and send it to supervisor
Tasks 2. Form for supervisor to approve and processing page.
Task 3. Schedule Task 1 to run on a schedule

Tackle one task at a time a time. You will need script to get this done

For Task one send the email with a link to a page that contains the form
for Task 2. For task 3, you have various options. You can create a page
with script that a person can open manually on schedule, which will
result in running the task. This method depends on a reliable human. Or
you can schedule opening the page on the server with a Task scheduling
utility. Or convert the code of the page to an equivalent vbs file (or
similar script that can be run at he OS) and schedule that script on a
Task Scheduler.

As an arterantive you can use a work flow application. Or purchase an
app specifically for HR leave.

..PC

Seok Bee wrote:

> Hi,
>
> I would like to write a program that will trigger at a scheduled date every
> month. This program is to generate an email to be sent to the supervisors on
> the employee oustanding leave application approval. Therefore, in the email,
> I'll list out all the employees under the supervisor where the leave
> application that are pending for the supervisor's approval. To make it easy
> for the supervisor, I'd have a checkbox next to each of the listed out record
> to allow the supervisor to select and make the approval or rejection.
> My problem is that I'm able to generate the email and the list of records,
> but I do not know or what way to post the selected values to update the
> database. Hope you experts out there can give me some hint and guidance to
> work on this.
> Many thanks in advance.
>
> Regards.
e