Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question"WHERE TIMEstmp = #" & 02/05/2011 14:25:46 & "#"j'ai un message d'erreur qui me dis : "Erreur de syntaxe" alors que lorsque j'effectue ma requête en string :
Sub Action_Bouton() Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Dim Date_Debut, Date_Fin As String Dim Jour, Jour1, Jour2 As Date Dim i As Integer Dim champ0 As String Dim champ1 As String Dim champ2 As String Dim TriDate As Date TriDate = Format(TriDate, "DD/MM/YYYY HH:MM") TriDate = "02/05/2011 00:00" Set cn = New ADODB.Connection 'Connexion à la DB' With cn .ConnectionString "Provider SQLOLEDB;Data Source=Masource;Initial Catalog=MaBDD;Uid=Login;Trusted_Connection=yes" 'Chaîne de connexion Sql Server' .Open End With Set rs = New ADODB.Recordset 'Lecture de la DB' With rs .ActiveConnection = cn .Open "SELECT * FROM Actions_OPE WHERE TimeStmp= #" & TriDate & "#" 'Sélection de la table Actions_OPE' End With
Public Sub DTPicker1_CallbackKeyDown(ByVal KeyCode As Integer, ByVal Shift As Integer, ByVal CallbackField As String, CallbackDate As Date) DTPicker1_CallbackKeyDown.Value = DateChoisie End Sub
Set cn = New ADODB.Connection 'Connexion à la DB' With cn .ConnectionString "Provider SQLOLEDB;Data Source=Masource;Initial Catalog=MaBDD;Uid=Login;Trusted_Connection=yes" 'Chaîne de connexion Sql Server' .Open .Execute "USE (NOM DE LA BASE DE DONNEE" End With Set rs = New ADODB.Recordset 'Lecture de la DB' With rs .ActiveConnection = cn .Open "SELECT * FROM Actions_OPE WHERE TimeStmp= #" & TriDate & "#" 'Sélection de la table Actions_OPE' End With