Kamis, 04 Februari 2016

[MS_AccessPros] Re: Form Load or On Open question


So I tried to see if the code even sees the date and changed the code to below. I get the Ho there message box. So it does not see the date probably. The text box has a control source of =Now()

Private Sub Form_Load()
If Me.txtTodaysDate = "2/4/2016" Then
'   DoCmd.CopyObject , "Jim", acTable, "tblMessages"
MsgBox "Hi there"
MsgBox "Ho there"
   End If

 MsgBox "The tblMessages table has been copied with the name of tblMessages-1-2-2017" & vbCrLf & _
" and a message has been sent to notify the users of the copied table."
End Sub


Posted by: luvmymelody@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)



Tidak ada komentar:

Posting Komentar