Click here to Skip to main content
15,892,161 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Integarting VB application with FingerPrint Reader Pin
DaveAuld25-Jan-10 2:29
professionalDaveAuld25-Jan-10 2:29 
GeneralRe: Integarting VB application with FingerPrint Reader [modified] Pin
εїзεїзεїз25-Jan-10 3:48
εїзεїзεїз25-Jan-10 3:48 
GeneralRe: Integarting VB application with FingerPrint Reader Pin
Dave Kreskowiak25-Jan-10 3:48
mveDave Kreskowiak25-Jan-10 3:48 
GeneralRe: Integarting VB application with FingerPrint Reader Pin
εїзεїзεїз25-Jan-10 3:50
εїзεїзεїз25-Jan-10 3:50 
QuestionReg Username Pin
hellogany24-Jan-10 20:28
hellogany24-Jan-10 20:28 
AnswerRe: Reg Username Pin
Mycroft Holmes24-Jan-10 21:23
professionalMycroft Holmes24-Jan-10 21:23 
AnswerRe: Reg Username Pin
Eddy Vluggen24-Jan-10 21:59
professionalEddy Vluggen24-Jan-10 21:59 
QuestionType mismatch when loading data from db to listview Pin
misCafe24-Jan-10 14:47
misCafe24-Jan-10 14:47 
I am using VBA (Access 2007) for my project. On the form load, listview retrieves data from the db but gets problem (Error Message : Type mismatch).

Here is my code.

Dim Rst As New ADODB.Recordset
Dim Str As String
Rst.CursorLocation = adUseClient

Str = "Select * From qry_staff_info Order By sID"
Rst.Open Str, Application.CodeProject.Connection, adOpenDynamic

If Rst.RecordCount < 0 Then Exit Sub
If Rst.RecordCount > 0 Then
Do While Not Rst.EOF
Dim lvwItem As ListItem
Set lvwItem = Me.lvwStaff.ListItems.Add(, , Rst![insurno]) ''''''' This the line which debug and show the error message (Type mismatch)
lvwItem.SubItems(1) = Rst![sname]
lvwItem.SubItems(2) = Rst![bgroup]
lvwItem.SubItems(3) = Rst![gender]
lvwItem.SubItems(4) = Rst![dob]
lvwItem.SubItems(5) = Rst![doj]
lvwItem.SubItems(6) = Rst![Position]
lvwItem.SubItems(7) = Rst![location]
lvwItem.SubItems(8) = Rst![Address]
lvwItem.SubItems(9) = Rst![Telephone]
lvwItem.SubItems(10) = Rst![martialstatus]
lvwItem.SubItems(11) = Rst![nod]
Loop
End If

Thanks,

Chuon Visoth
Angkor Wat - Cambodia
asp.net - c sharp beginner

AnswerRe: Type mismatch when loading data from db to listview Pin
Eddy Vluggen24-Jan-10 22:07
professionalEddy Vluggen24-Jan-10 22:07 
GeneralRe: Type mismatch when loading data from db to listview Pin
misCafe25-Jan-10 13:15
misCafe25-Jan-10 13:15 
GeneralRe: Type mismatch when loading data from db to listview Pin
Eddy Vluggen26-Jan-10 1:25
professionalEddy Vluggen26-Jan-10 1:25 
QuestionWebBrowser Navigation in MDI from seperate form. Pin
OmegaMaximum24-Jan-10 10:06
OmegaMaximum24-Jan-10 10:06 
AnswerRe: WebBrowser Navigation in MDI from seperate form. Pin
DaveAuld24-Jan-10 10:19
professionalDaveAuld24-Jan-10 10:19 
GeneralRe: WebBrowser Navigation in MDI from seperate form. Pin
OmegaMaximum25-Jan-10 7:53
OmegaMaximum25-Jan-10 7:53 
GeneralRe: WebBrowser Navigation in MDI from seperate form. Pin
EliottA25-Jan-10 10:35
EliottA25-Jan-10 10:35 
GeneralRe: WebBrowser Navigation in MDI from seperate form. Pin
OmegaMaximum25-Jan-10 16:40
OmegaMaximum25-Jan-10 16:40 
GeneralRe: WebBrowser Navigation in MDI from seperate form. Pin
DaveAuld25-Jan-10 23:56
professionalDaveAuld25-Jan-10 23:56 
GeneralRe: WebBrowser Navigation in MDI from seperate form. Pin
OmegaMaximum26-Jan-10 0:48
OmegaMaximum26-Jan-10 0:48 
QuestionAttach scrollbar to listview Pin
Eli Nurman24-Jan-10 8:12
Eli Nurman24-Jan-10 8:12 
AnswerRe: Attach scrollbar to listview Pin
DaveAuld24-Jan-10 8:44
professionalDaveAuld24-Jan-10 8:44 
AnswerRe: Attach scrollbar to listview Pin
Luc Pattyn24-Jan-10 9:59
sitebuilderLuc Pattyn24-Jan-10 9:59 
GeneralRe: Attach scrollbar to listview Pin
Eli Nurman24-Jan-10 10:25
Eli Nurman24-Jan-10 10:25 
QuestionHow to Work On MAC Application Pin
Anubhava Dimri22-Jan-10 22:32
Anubhava Dimri22-Jan-10 22:32 
AnswerRe: How to Work On MAC Application Pin
DaveAuld23-Jan-10 5:30
professionalDaveAuld23-Jan-10 5:30 
AnswerRe: How to Work On MAC Application Pin
Eddy Vluggen23-Jan-10 5:44
professionalEddy Vluggen23-Jan-10 5:44 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.