dear programmers,
I got a problem with database i created a event for cboname_change()
so that i can determine if the name and the data have been added in.
the table have 4 attribute
1. name (pk)
2. check in
3. check out
4. date (pk)
i want o make the event to check i whether the name have been entered
for the specific day.
later check if that guy have checked in (data in database) if yes then
i will disable the check in button
then check if that guy have check out if so disable check out button
(got data in database)
The problem is that:
what i have to code in order to check if the name and of the same date
got entered?
what code to make sure that guy have check (check, check out record) -
how to code ?
this is my code .. i don't know how to use find method to determind
whether the data hav been entered or there is other way ? any
suggestion?
my code ... but doesn't work ...
Private Sub cboName_SelectedIndexChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
cboName.SelectedIndexChanged
Dim timein As String
Dim timeout As String
DsTime1.Clear()
dbTime.SelectCommand.Parameters("name").Value = cboName.Text
dbTime.SelectCommand.Parameters("date").Value = lblDate.Text
dbTime.Fill(DsTime1)
If (DsTime1.Tables("tbltimedate").Rows.Count = 0 And <> "") Then
mblnCheckIn = True
btnEnter.Text = "Check In"
End If
If (DsTime1.Tables("tbltimedate").Rows.Count = 0 And timeout <> "") Then
mblnCheckOut = True
btnEnter.Text = "Check Out"
End If
End Sub
i connect to my access database ...
Any suggestion ?
--
Regards,
ByteSurfer RULES....
------------------------ Yahoo! Groups Sponsor --------------------~-->
$9.95 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/k7folB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To reply to this message, go to:
http://groups.yahoo.com/group/visualbasic6programming/post?act=reply&messageNum=17965
Please do not reply to this message via email. More information here:
http://help.yahoo.com/help/us/groups/messages/messages-23.html
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/visualbasic6programming/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
