You have chosen to sponsor your bid up to a maximum amount of .
There are two elements to this project.
1/ I'd like to offer a 'forgot password?' function to the attached login.asp page. This would be a link to a new page where the user would enter their email address and, if it matches a record in the members.mdb file, the password is sent to that address.
2/ I'd like to offer a 'course type' database query in asp similar to the attached 'weather' query. The filters on the top row would be the same - 'Year', Month' and 'Tour' and the filters in the bottom two rows would also be the same - 'First name' and 'Surname'. Instead of the three filters in the 2nd/3rd rows, the following would be filters for this 'course type' query:
'Par' - drop-down list - the relevant field for this filter is 'Par' in the 'Events' table in the Men1.mdb file.
'Yardage' - drop-down list - the relevant field for this filter is 'Yardage' in the 'Events' table in the Men1.mdb file.
'Architect' - drop-down list - the relevant fields for this filter are the 'Architect1', 'Architect2', 'Architect3', 'Architect4', and 'Architect5' fields in the 'Course' table (Men.mdb file). There can be as many as five different architects for each course, so the query will need to run on the text entered by the user to see if it matches the Architect in any of those five fields.
'Greens' - drop-down list - as with the Architect query, there are different grasses that can be used on each green so the query will need to run on the user's selection(s) to see if it matches any of the 'Greens1', 'Greens2', 'Greens3', 'Greens4' fields in the 'Course' table.
'Green Speed' - drop-down list - the relevant field in the Men1.mdb file is 'Stimpmeter' in the 'Course' table.
'Green Size' - drop-down list - the relevant field in the Men1.mdb file is 'GreenSize' in the 'Course' table.
I will gladly answer any questions about these projects; though the first should be straightforward and there is a basic template to follow for the second one. I have commissioned plenty of projects on vworker and always had top ratings from the coders that I have employed.
Thanks for looking.