Ad:

Visual Basic 4 / 5 / 6 Discussion Thread
Unsolved
Views: 1672

Page 1
2
Next

You are currently viewing page 1 of this multi-page discussion thread

Aug 17th, 2009

Error: Type Mismatch - access + vb 6.0

Expand Post »

I'm having this error: type mismatch.. i dont actually get/understand the error.. i think the error is in the WHERE clause [tblUserAccount].[UserID].. the field [UserID] is set to a data type Autonumber, and the roleUserID is set as integer..

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
 
Global rolesDbs as new adodb.connection
Global rolesRs as new adodb.recordset
 
 rolesDbs.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = " & App.Path & "\library.mdb;MODE=ReadWrite"
        rolesDbs.CursorLocation = adUseClient
        Set rolesRs.ActiveConnection = rolesDbs
        rolesRs.LockType = adLockOptimistic
        rolesRs.CursorType = adOpenDynamic
        rolesRs.Source = "SELECT [tblRoles].[UserID], [tblRoles].[Role] " & _
                         "FROM [tblUserAccount] INNER JOIN [tblRoles] ON ([tblUserAccount].[UserID] = [tblRoles].[UserID]) " & _
                         "WHERE [tblUserAccount].[UserID] = " + roleUserID + ""
        rolesRs.Open , rolesDbs, , , adCmdText
       
Global rolesDbs as new adodb.connection
Global rolesRs as new adodb.recordset

 rolesDbs.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = " & App.Path & "\library.mdb;MODE=ReadWrite"
        rolesDbs.CursorLocation = adUseClient
        Set rolesRs.ActiveConnection = rolesDbs
        rolesRs.LockType = adLockOptimistic
        rolesRs.CursorType = adOpenDynamic
        rolesRs.Source = "SELECT [tblRoles].[UserID], [tblRoles].[Role] " & _
                         "FROM [tblUserAccount] INNER JOIN [tblRoles] ON ([tblUserAccount].[UserID] = [tblRoles].[UserID]) " & _
                         "WHERE [tblUserAccount].[UserID] = " + roleUserID + ""
        rolesRs.Open , rolesDbs, , , adCmdText

help me out here please.. thanks

Similar Threads

[Getting an error 'Data Type Mismatch in Criteria Expression] in VB.NET
run time error "13" type mismatch in Visual Basic 4 / 5 / 6
Run time error 13 - type mismatch in Visual Basic 4 / 5 / 6
accessing dates in ms access with visual basic in Visual Basic 4 / 5 / 6
Type mismatch: Cannot convert from void to double in Java

JerieLsky

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

63 posts
since Jul 2009

Permalink

Aug 17th, 2009

Re: Error: Type Mismatch - access + vb 6.0

You cannot "add" strings together (+), you can however concatinate strings together (&). As for everything else, it looks fine at first glance.

Good Luck

vb5prgrmr

Reputation Points: 156

Solved Threads: 296

Posting Virtuoso

Offline

1,670 posts
since Mar 2009

Permalink

Aug 17th, 2009

Re: Error: Type Mismatch - access + vb 6.0

well if i tried changing the (+) sign using the (&) sign the error now changes to: Data type mismatch in criteria expression. So how's that? I'm not actually concatinating it, im comparing it using the WHERE clause.

JerieLsky

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

63 posts
since Jul 2009

Permalink

Aug 17th, 2009

Re: Error: Type Mismatch - access + vb 6.0

try this

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)

"WHERE [tblUserAccount].[UserID] = '" & roleUserID & "'"

single quotes around roleuserid

ProfessorPC

Reputation Points: 31

Solved Threads: 29

Posting Whiz in Training

Offline

270 posts
since Dec 2007

Permalink

Aug 17th, 2009

Re: Error: Type Mismatch - access + vb 6.0

Click to Expand / Collapse Quote originally posted by ProfessorPC ...

try this
Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
"WHERE [tblUserAccount].[UserID] = '" & roleUserID & "'"
"WHERE [tblUserAccount].[UserID] = '" & roleUserID & "'"
single quotes around roleuserid

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
"WHERE [tblMembership].[UserID] ='" & Trim(roleUserID) & "'"
"WHERE [tblMembership].[UserID] ='" & Trim(roleUserID) & "'"

in this code if i place a single quotes the error is "Data type mismatch in criteria expression." but if i remove the single quotes, what will happen is that i am already concatinating the string together, which causes an error..

JerieLsky

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

63 posts
since Jul 2009

Permalink

Aug 17th, 2009

Re: Error: Type Mismatch - access + vb 6.0

if you are pulling data from one table only why use the join?

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)

"SELECT UserID, Role FROM tblRoles where UserID = '" & roleUserID & "'"

ProfessorPC

Reputation Points: 31

Solved Threads: 29

Posting Whiz in Training

Offline

270 posts
since Dec 2007

Permalink

Aug 18th, 2009

Re: Error: Type Mismatch - access + vb 6.0

I ain't actually getting data from only one table, i need some datas also from the other table that's why i applied the INNER JOIN, i just don't know why it shows an error with the WHERE clause.. please, need back up

JerieLsky

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

63 posts
since Jul 2009

Permalink

Aug 18th, 2009

Re: Error: Type Mismatch - access + vb 6.0

in your query you are only pulling from one table. i guess its throwing me off. what are the fields from the other table you are using? can you test your query in your db's query analyser?

ProfessorPC

Reputation Points: 31

Solved Threads: 29

Posting Whiz in Training

Offline

270 posts
since Dec 2007

Permalink

Aug 19th, 2009

Re: Error: Type Mismatch - access + vb 6.0

Click to Expand / Collapse Quote originally posted by ProfessorPC ...

in your query you are only pulling from one table. i guess its throwing me off. what are the fields from the other table you are using? can you test your query in your db's query analyser?

Ok, i tried this Query from only one table which is Table Membership:

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)

"SELECT * FROM [tblMembership] WHERE [tblMembership].[UserID] = '"+ rolesUserID + "'"

if i remove the WHERE clause, i get no errors, but if place that WHERE clause in the Query it pops up the error: Type Mismatch. In the table Membership, i set the data type of UserID to Number, and the variable rolesUserID to Integer.
The rolesUserID is actually a variable that i have set to make a comparison to [tblMembership].[UserID].

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
 rolesUserID = usersRs.Fields("UserID").Value
 rolesUserID = usersRs.Fields("UserID").Value

i dont know what's causing the problem.

Last edited by JerieLsky; Aug 19th, 2009 at 1:57 am.

JerieLsky

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

63 posts
since Jul 2009

Permalink

Aug 19th, 2009

Re: Error: Type Mismatch - access + vb 6.0

Seems like user id is a numeric field. Remove the single ticks (') from around your variable.

Good Luck

vb5prgrmr

Reputation Points: 156

Solved Threads: 296

Posting Virtuoso

Offline

1,670 posts
since Mar 2009

Page 1
2
Next

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Where to find VB?

Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: msflexgrid data trasfer to texbox

DaniWeb Message

Cancel Changes

User Name
Password