Information générale
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
I suppose the rsFacturas recordset has been set a Source already? (As in a table name or a select statement)
Does this work or does it still give you the "member not found" error message? What line gives you the error?
Seems OK to me, I would suggest checking that what is entered in tbxData1 and tbxData2 is indeed a Date with the IsDate() function.
>This is the code
>
>Option Explicit
>Dim hh As Long
>Dim ww As Long
>Dim procura1 As String
>Dim procura2 As String
>
>Private Sub BtnData_Click()
> Me.Width = 9135
> Me.Height = 7995
> FraData.Visible = False
> procura1 = TbxData1.Text
> procura2 = TbxData2.Text
> DtaEnvBD.rsFacturas.Open
> DtaEnvBD.rsFacturas.Filter = "Data>=#" & procura1 & "# AND data<=#" & procura2 & "#"
> act_lvw
> ParametrizarLvwFacturas
> ListarRsFacturas
> LvwFacturas.Visible = True
>End Sub
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement