Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql
Message
From
24/07/2002 10:57:41
 
 
To
24/07/2002 05:28:04
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Title:
Re: Sql
Miscellaneous
Thread ID:
00681185
Message ID:
00682060
Views:
32
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
Map
View

Click here to load this message in the networking platform