General information
Category:
Database 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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only