I've a 'Birthday' form wherein when i click on Search command button, an input box is displayed. In this input box, i type in a month and when i click on OK i want details of all those students whose birthday falls in that month.i'm using ADO Data Connection.
me_j 0 Newbie Poster
debasisdas 580 Posting Genius Featured Poster
simply u need to trap the start and end date of the month and run a BETWEEN query in the database using ADO to get the output.
kehar 0 Junior Poster in Training
email your programme at kehar2005@yahoo.co.in unless one see the programe one c annot give you the idea because how can one know where you are.
Bye.
choudhuryshouvi 33 Posting Pro
cmdsearch_click()
dim str as string
dim rs as new adodb.connection
str=inputbox("enter month","search")
if str<>"" then
rs.open "select * from <tablename> where month='" & str & "'"
if rs.recordcount>0 then
<display data>
else
msgbox "no record found"
endif
else
msgbox "input the month plz."
endif
end sub
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.