"... Where monChamp Between #" + MaDateHaute.ToString("MM/dd/yyyy") + "# " + _ "AND #" + MaDateBasse.ToString("MM/dd/yyyy") + "#"
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionDim date1 As Date Dim date2 As Date date1 = format(CDate(MaskedTextBox1.Text.ToString),"dd/mm/yyyy") date2 = format(CDate(MaskedTextBox2.Text.ToString),"dd/mm/yyyy") Set Db = OpenDatabase(CHEMAIN COMPLET DE TA BASE DE DONNEE ACCESS, false, False) Set vo_info = Db.OpenRecordset("SELECT * FROM NOM DE LA TABLE where deffet Betwenn #01/01/1900# And #01/01/2100#") DataGridView1.DataSource = vo_info("police").value DataGridView1.AutoResizeColumns() vo_info.close db.close Set vo_info = nothing Set Db = nothing End Sub