No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
Hi All, I am trying to create crystal report 11 with VB6. But it seen like during the execution of code, the sql statement was ignored (line 12). And the report listed out everything. Below is my code. [CODE]Dim rs As ADODB.Recordset Dim strSQL As String Set Report = New … |
|
Hi All, Is it possible to filter 2 fields in Adodc? My code is shown below: *****-----*****----- With Adodc2.Recordset .Filter = "DOC_DATE = '" & myDate & "'" If .EOF Then MsgBox "Item Not found" .Requery End If End With *****-----*****----- But I need to filter another field on top … |
|
Hi, All I am trying to do 2 level filter on datagrid. First I search the datagrid for same customer number. Than search again by date. The problem I encounter is the first search works just fine (it return me records of a particular customer no.). But when it comes … |
|
Hi All, I had puted out my records from database and place them in Datagrid. Than I try to filter out unwanted records based on user inputed date (by using 2 DTPicker, a START DATE and END DATE). And I encounter this problem "Run-time error '3001'". Anyone has any idea … |