Charlotte Foust
cfoust at infostatsystems.com
Tue Dec 2 11:10:00 CST 2003
In Access you can only refer to the Text property of a control when that control has the focus. Just take the Text property out of your code and it will work in Access. Charlotte Foust -----Original Message----- From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com] Sent: Tuesday, December 02, 2003 8:52 AM To: accessd at databaseadvisors.com Subject: [AccessD] no Focus This would have forked in VB6, but in Access I am getting "no focus error" what should i do ? Private Sub sndBrian_Click() Dim From As String Dim Through As String Dim dtEdate dtEdate = Format(Now() - 3, "mm-dd") If txtFrom.Text = Null Or txtThrough.Text = Null Then txtFrom.Visible = True txtThrough.Visible = True MsgBox "Please enter FROM and THROUGH dates in mm-dd format", , "dates" Exit Sub End If ----------------------------------------- Get Breaking News from CNN, ABC, NBC, CBS Now. http://www.xuppa.com/news/?link=webmail _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com