Member Avatar for nai_christop

hi...i want to save the date from datepicker control to database access...
i have coded everything except datepicker...its my 1st time to use this control..

thank you...

  • 4 Contributors
  • 3 Replies
  • 103 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by Deepak Shitole
Member Avatar for debasisdas

Are you facing any problem with the control ?

You simply need to take the value from the control, format is at per you database date format and store in DB.

Edited by debasisdas because: n/a
commented: point in the right direction as always +5
Member Avatar for emond 
Set rs = New ADODB.Recordset
        If rs.State = 1 Then rs.Close
        
        rs.Open "SELECT * FROM yourtable", cn, 3, 2
        rs!date_time = DTPicker1.Value
        rs.Update
Member Avatar for Deepak Shitole 
Dim rs As new ADODB.Recordset
'ConnectionObject is a Connection Object
Set rs = Nothing
Set rs = New ADODB.Recordset
rs.Open "tblMyTable", ConnectionObject, adOpenStatic, adLockOptimistic
rs.Addnew
   rs!dtmTransactionDate = Format(DTPicker1.Value,"DD/MM/YYYY")
rs.Update

In case of any issue please feel free to contact me

Edited by Ezzaral because: Snipped contact info. Please keep it on the forums. Added code tags.
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.