reminder window

[farhanusm]

hi
actually i m maintaining my dept db in ms access for tht i need a pop up window or validator window which come as pop up and remind my employees abt their activites and how much time it needed to comlete such activity i have 3 fields 1 S.NO 2 activity 3 due date i want whenever employee open the form pop up window come remind abt due date of tht activity ..plz tell me the code for tht in vb so tht i can add in my form thnx in advance abt the various activity ..plz tell me the code for tht in vb so tht i can add in my form thnx in advance

 

[namliam]

Im lmst sre tht u can make a qry us'n the dd, us'n thy fntion DateAdd and Date in coding to opn a rcrdset and fetch your info.

 

[khawar]

First of all you have to assign the activities to employees so that when you open the form popup it will show the activities of that specific emloyee. For this you have to add an extra field
http://www.databasedev.co.uk/forms.html

Click on the link above it has an example of reminders popup form

 

[farhanusm]

thnx bro .... i have 3 enteries i told u basically i wann a validator which chks activity with the system date and remind abt the days left for tth activity

 

[DCrake]

Simple Software Solutions

Us mere mortals that do have ten fingers and toes are used to reading text entered in on a keyboard. Using txt shorthand is fine if you only have two thumbs. Please make you questions readable. Understanding questions is one thing,, haveing to translate them first is another.

CodeMaster:

 

[khawar]

Uploaded a sample with some more options for you

 

[farhanusm]

khawar sir thnx for this attachment but i m havin this already ....

 

[khawar]

If you have viewed it properly I have made some changes such show records for today forthe week for month etc I thought it may be helpful to you

 

[farhanusm]

thnx once agn .....actually sir i don't have much idea abt vba boss has assign this work to me to be very honest i don't have much knowledge about vba , so please help me ...basically my form has three fields
s.no activity due date
i have to design a form in such a way so that when ever employee view the form he will see a reminder on his or her screen which come in the form of pop up and remind him about due date and how much days are left for that activity