scudzilla

I'm almost finished with a task organizer project. Whenever a task entered is due, the app creates an alert form at the lower right corner of the screen. How can I play an alert tone whenever a form is created? I wanted it to be like the new email alert …

The simplest code I can muster is: [code] If rst.Recordset.Recordcount > 0 then Do While not rst.Recordset.Recordcount = 0 rst.Recordset.Delete Loop Else MsgBox "No Data in database." End if For i = 1 to 8 step 1 If txtAgenda(i).visible = true AND txtAgenda(i).Text <> "" then rst.Recordset.AddNew rst.Recordset.Fields(0).value = i …