Solved

RunTime error 3464  data type mismatch string

Posted on 2013-06-12
2
717 Views
Last Modified: 2013-06-12
Running into issue with data mismatch at: .FindFirst "[strClientId] = " & vID.  CboTest is a text string.


Dim vID As String

vID = cbotest

    If Not IsNull(vID) Then
        With Me.RecordsetClone
            .FindFirst "[strClientId] = " & vID
            If Not .NoMatch Then
                Me.Bookmark = .Bookmark
            End If
        End With
    End If


Error occurs at: .FindFirst "[strClientId] = " & vID
0
Comment
Question by:jbakestull
2 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 39241101
I assume that "strClientID" is a Text field, so do this:

.FindFirst "[strClientId] = '" & vID & "'"

This surround the vID value with single quotes ( ' )
0
 

Author Closing Comment

by:jbakestull
ID: 39241650
thanks
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question