VB / Access Question

Hi all. Hoping you can help out with this.

I have been web-enabling alot of an access database with forms and asp.

In the database, there is a field in the record stating weather it's open or closed.

By default, the value is open.
When the record is changed to closed, I want to have an email sent -- confirmation (record number and column values) page to the email address in the record.

The changing of the status from "open" to "closed" will be done in Access.

I would like to have this automated and scheduled to run every night.

It would go through the database to see which records = closed by "completed_date" type of thing. And each record that was closed have the email sent to address in the record.

Any thoughts on the logic or how this can be done?

Thanks,
JC

You could create a simple console application, that connects to the database.
Gets all the records and for each record where the value is "closed", pass the necessary fields to a sub to send the email.

based on the info you provided it wouldn't be too hard, just break the steps down into smaller tasks...

Tasks
1) connect to database
2) Query database
3) loop through all records and check for value of "closed" in that field.
4) If "closed" then pass the records info to another procedure to send the email.

i am new to visual basic and visual studio and would like it if some one gave me some help . not looking for a hand out but would like to learn

What don't you understand? What have you tried so far?

I've been reading up on console applications to get started.

Looks like I can really screw this up, but I'm going to give it a stab anyways.

Anyone have any pointers for a noob?

Thanks,
JC

This had hit the back burner for a while, and now it's pressing again.

I have the asp page to where I input the variable (date) and then submit the query and return "closed" records to a recordset by date.

How should I approach passing the records into a template and having them e-mailed.

Thanks,
JC