HTML Form

[Seok Bee]

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 Spencer]

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.

 

[p c]

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

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