Report / Form - Auto Pop Up

[rajeshsarin]

Hi Folks,

I have the following query that generates a list of reminders that are due:-

SELECT Reminders.Date, Reminders.Time, Reminders.Set_By, Reminders.Reminder, Reminders.Due, Reminders.Allocated, Student.SID, Student.FName, Student.LName
FROM Student INNER JOIN Reminders ON Student.[SID] = Reminders.[SID]
WHERE Reminders.Completed = False;

I want to create a facility that when reminders are due they should pop up automatically in a report or form format.

I am not very conversant with VB script. Any help would be appreciated.

Cheers - Raj

 

[DCrake]

Your first task is to rename the fields in your table. Do not use words such as Date and Time as they are Access reserved words.

To answer your question though, you can do a DCount() on the query to test for any records and if so use the DoCmd.OpenForm to open a form that is bound to the query that displays the items in the query in whatever format you want.

 

[HiTechCoach]

see it this example help

http://hitechcoach.com/index.php?option=com_docman&task=doc_details&gid=4&Itemid=28

 

[rajeshsarin]

Thanks for the example, how did you manage to get the pop up box, when the database opens?? What is the code behind that?

 

[rajeshsarin]

Hi Boyd,

Sorry about the earlier post, I was able to make the pop up work. However is there any option that i can set a time so that it pops every 2 hours etc??

Regards


Raj