Software Applications Programming Errors and solutions.

This is code sample to Set label in MDI Form on which label data taken from table using Timer in visual basic language. Dim rs As New Recordset Private Sub MDIForm_Load() open_recordset "select *from MASTER1 ", rs MDIForm1.Top = 0 MDIForm1.Left = 0 MDIForm1.Width = Screen.Width MDIForm1.Height = Screen.Height End Sub Private Sub MDIForm_Unload(Cancel As Integer) Timer1.Enabled = False rs.Close End Sub Private Sub Timer1_Timer() While Not rs.EOF If rs.Fields(0).Value = Format(Date, "dd/MM/yy") Then myform(i).Label1 = rs.Fields(1).Value myform(i).Show End If i = i + 1 rs.MoveNext Wend If Not rs.EOF Then rs.MoveFirst End If Timer1.Enabled = False End Sub