Question Adding dates from a form and automatic deletion of records determined by date

[JohnM]

Hi,
I am making a simple database to use with a web site (using ASP). This will store job vacancies in different geographical locations. It will require a field with closing dates for the job applications. I am presently stuck with 2 aspects of this.

Firstly, I want to create an "add records" page with a form and I'm not sure how to go about adding dates on this page so that entries are consistent and easy for users to imput. Ideally I would like to have a "calender" where you can select a date, similar to those you get on airline/railway sites. How would I go about doing this?

Secondly, I would like the record to be deleted automatically the day after the closing date. Again I have no idea how to go about this.

If anyone has any ideas on how I would go about doing either of these I would greatly appreciate any assistance given.

Thanks John M.

 

[CameronM]

So your main data entry is being done via an ASP website? Which version, classic ASP or ASP.NET?

Secondly, you wouldn't normally delete the old records but simply no longer display them. You can achieve this by adjusting the SQL query that is used to populate your page to have a date criteria something like "WHERE endDate <= Date()"

If you really must delete the old records, you will need to execute a DELETE query using a similar WHERE clause.

 

[JohnM]

Cheers for the speedy reply

I will be using Classic ASP. Thanks for the SQL info I think thats just what I need. I want to delete records as each will become redundant within a couple of weeks.

John M.

 

[CameronM]

If you haven't gone very far in the development, I would suggest using ASP.NET, as even in the freely available Visual Web Developer (VWD) edition, there is great support for Access databases straight out of the box. VWD also has a calendar control, that is farily easy to setup and use.

With Classic ASP, you will probably have to use a fair amount of javascript to utilise your calendar control, as it is rendered on the client side. There are a number of examples you can download to get you started - try Googling "Classic ASP Calendar".

 

[JohnM]

Thanks for the assistance Cameron it has been very useful and I'll be following your advice.

John M