November 19, 2008 01:20am pst

05.08.2008 at 01:12PM PDT, ID: 23387498

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.8

type mismatch in vb6 at .refresh

Asked by zyx100 in VB Database Programming

Tags: type mismatch .refresh

when i search i get this error "type mismatch"

i am using DBGrid1 to show all records from company table
DBGrid2 from showing search result
data1 connected to DBGride1 and deat2 to DBGride2

please tell me where i wrongStart Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:

           
           
             Private Sub cmdSearch_Click()
With Data2
    .RecordSource = "Select * from company Where co_id = '" & txtSearch.Text & "'"
    .Refresh
End With
End Sub
 
Private Sub cmdSearch1_Click()
With Data3
    .RecordSource = "Select * from students Where Name Like '" & txtSearch1.Text & "'"
    .Refresh
End With
End Sub
 
Private Sub Form_Load()
With Data1
    .DatabaseName = App.Path & "\db1.mdb"
    .RecordSource = "company"
End With
 
Data2.DatabaseName = App.Path & "\db1.mdb"
 
Data3.DatabaseName = App.Path & "\db1.mdb"
 
End Sub

           
         

Attachments:

db1.mdb (148 KB) (File Type Details)

database file

Keywords: type mismatch in vb6 at .refresh

	Title
1	Type mismatch when looking up dates i…
2	Data type mismatch in criteria expressi…
3	Type mismatch when populateing arra…
4	loading image in to picture box getting …
5	ASP > Access mismatch error
6	Type mismatch: 'SendContactUsEm…

Loading Advertisement...

20080716-EE-VQP-32 - Hierarchy / EE_QW_2_20070628

1. angelIII 70,974
2. capricorn1 40,760
3. LSMCons... 35,556
4. harfang 31,630
5. Dhaest 30,593
6. RobSamp... 23,300
7. DatabaseMX 21,600
8. Arthur_... 20,614
9. jpaulino 20,570
10. peter57r 18,229
11. emoreau 18,100
12. hielo 17,700
13. jimhorn 16,878
14. acperkins 16,498
15. ee_rlee 15,865
16. rorya 15,645
17. danaseaman 15,150
18. mlmcc 14,252
18. boag2000 14,252
20. frankytee 13,800
21. aiklamha 13,200
22. matthews... 11,400
23. MikeToole 11,000
24. saurabh726 10,900
25. zorvek 10,100

1. leonstryker 661,946
2. angelIII 316,140
3. emoreau 300,708
4. acperkins 265,782
5. Dhaest 196,907
6. TimCottee 160,377
7. Arthur_... 150,935
8. MYLim 135,434
9. Sethi 112,456
10. Dabas 109,981
11. mdougan 101,310
12. ryancys 97,083
13. leclairm 93,623
14. jimhorn 91,332
15. mlmcc 89,643
16. LSMCons... 88,068
17. capricorn1 85,338
18. aikimark 82,779
19. rockiroads 70,782
20. harfang 64,790
21. spongie 60,226
22. jkaios 46,350
23. Michael_D 42,870
24. CarlWarner 41,949
25. appari 39,853

type mismatch in vb6 at .refresh

Asked by zyx100 in VB Database Programming

Tags: type mismatch .refresh

About this solution