For getting the data from DB, there are some ways, but approach is one. After executing the Recordset with SELECT statement, use rst!<field name> or rst.fields(index) and store the data in the variable and initialize that variable to particular control box

E.g:-
getting email id
dim s as string
s = rst!emailid
text1.text = s

This normal process. But Sometimes it causes a error if you have NULL value in emailid field in the DB. So before setting it to the control check for IsNull, if false then proceed. So RTE is not shown and data is seen.

And for the Popup Calendar,
1) Do you mean creating a control like Calender?
OR
2) Just want to show the Calender control in the separate form and call it when a click of button and get the date from the calender and put into the text box or label

IF #1, don't think about it, Its easy yet so complex, but not now. IF #2 then I don't see any difficulties.

a) draw a calender in the form (set the color and look and size as needed)
b) in the button_click of the button load the form
c) when click of the calender, put the date selected in to the text box (or any)
d) close the calender window.

IF NOT #2, then explain whats your need properly, will look it out.

Hope this helps.

With Regards,
Raghavendra Mudugal

Dear Member,

     What I wanted is #2. Can u help me.....?



    cnkumar74

I have already mentioned you those four steps from a to d for #2, read it again. And tell me what you don't understand.

With Regards,
Raghavendra Mudugal

 cnkumar74

How can we get the datas back from the DB? Please give me the code...As I am a beginner in VB.



cnkumar74