Due date for Homeworks

[Sharrowkyn]

Hey guys, As im new to this forum, id like to thank in advance anyone who offers any advice on my following question (and I hope ive posted this in the right place!)

Im making a final year project using access as a prototype system, I basically have most of it working, but the one thing i cant seem to find, how to set a "due date" My assignment is schools bases and I want a section were if a teacher sets a homework, for say 4 days from now on day 3 there is a notification (or something along those lines) that flags up saying you have one day left to do your home work.

I have searched the web and there are a few videos and other forum posts, but nothing so far that directly helps me. So if anyone has any ideas on how to go about this please let me know.

Sharrowkyn

 

[maw230]

I guess this could be the right place since this is in fact a very "general" question that depends completely on how you have things set up right now. I would suggest to post a sample database per the forum guidelines, or write your question in a much more specific way.

The questions I have are:
Is there already a 'due date' field that you can use for your notification?
Do you want the flag to pop up on a form, report, query?

 

[Sharrowkyn]

Thanks for your reply. attached are two screen shots, if this is not helpful ill upload some sample data as well. Screen shot "assign homework" shows a page were a teacher can add in information regarding homework's what subject, class and comments. In that page I want them to be able to assign when the homework was set and the due date for when it has to be handed in. This information will then be displayed in the table in the second screen shot "homeworks screen shot" just after forename, with the field saying when the home work was given and when it is due

If I have not made this very clear or if more information is required please let me know.

Sharrowkyn

 

[maw230]

Ok, so in the table used in the screenshot you will need to add two fields. One for the date the homework was given and one for the date it is due. The rest is kind of up to you.

You could have the form from the first screenshot automatically add Today's date to the table field discussed above when the teacher makes an entry and that would be your "homework assigned date", or you could have the teacher enter what day the homework was assigned which would again be transferred to the table.

For the due date you have several options as well. The one that makes the most sense to me without knowing your requirements is to have the teacher enter a due date that is then displayed in the table.

Once you have your two dates you have many options for displaying a notification of "time remaining until due", but essentially they will all involve performing a calculation on the two date fields. You can use a date function like Datediff() to get the difference in time between the two dates: http://www.techonthenet.com/access/functions/date/datediff.php.

Once you know how and where you want the notification to be displayed you can explore your options further.

 

[Sharrowkyn]

Thanks a lot, that was very help. I appreciate you taking the time to look it at. Ill have a wee think about it now and hopefully work out something.

Cheers

Sharrowkyn

 

[maw230]

Not a problem, good luck (but you probably don't need it...Ireland joke)!