Ошибка data type mismatch

I get a message about data type mismatch

Access for Microsoft 365 Access 2021 Access 2019 Access 2016 Access 2013 Access 2010 Access 2007 More…Less

Need more help?

Want more options?

• Remove From My Forums

• Question

• Hi,

  I made a Query by Form with multiple criteria (start date, end date and name) using VB code.  However when I run the form, I got a «data mismatch» error.  Im not sure if the error comes from the code which I paste below.

  Thanks in advance. ^_^

  Private Sub cmdOpen_Click()
  On Error GoTo Err_cmdOpen_Click

      Dim stDocName As String
      Dim stWhere As String
      Dim blnTrim As Boolean

      
         
                 
            If Not IsNull(Me.txtBPOman) Then
              stWhere = «[BPO Manager]=» & CInt(Me.txtBPOman) & » And «
              blnTrim = True
            End If

          

           If (Not IsNull(Me.txtStartDate) And Me.txtStartDate <> «») And (Not IsNull(Me.txtEndDate) Or Me.txtEndDate <> «») Then
                  stWhere = stWhere & «[Remediation Date] Between #» & Me.txtStartDate & «# And #» & Me.txtEndDate & «#»
                  blnTrim = False
           End If

                
         
           If blnTrim Then
              stWhere = Left(stWhere, Len(stWhere) — 5)
          End If

             
      stDocName = «SOCD Report»
      DoCmd.OpenReport stDocName, acPreview, , stWhere

     
  Exit_cmdOpen_Click:

      Exit Sub

  Err_cmdOpen_Click:
      MsgBox Err.Description
      Resume Exit_cmdOpen_Click
      End Sub

  • Changed type

    Monday, December 5, 2011 6:22 PM
    This is a question, not a discussion…

  • Changed type
    Vanderghast
    Monday, December 5, 2011 6:22 PM
    This is a question, not a discussion…

• Remove From My Forums

• Вопрос

• Code:

              

   [WebMethod]
          public string[] FeaturedGames()
          {

              OleDbConnection connection3 = new OleDbConnection(«Provider=Microsoft.ACE.OLEDB.12.0; Data Source=C:\Temp\GamesDatabase.accdb»);
              connection3.Open();

              OleDbCommand cmd = new OleDbCommand(«Select Game_ID from Game_Feedback where Rating > 7», connection3);
              OleDbDataReader reader = cmd.ExecuteReader();
              reader.Read();
              int Featured = reader.GetInt32(0);
              reader.Close();

              cmd = new OleDbCommand(«Select Count(Game_Title) from Game_Overview where Game_ID=@Game_ID», connection3);
              cmd.Parameters.AddWithValue(«@Game_ID», Featured);
              reader = cmd.ExecuteReader();
              reader.Read();
              int numberofgames = reader.GetInt32(0);
              reader.Close();
              String[] GameTitle = new string[numberofgames];

              cmd = new OleDbCommand(«Select Game_Title from Game_Overview where Game_ID=@Game_ID», connection3);
              cmd.Parameters.AddWithValue(«Game_ID», Featured);
              reader = cmd.ExecuteReader();

              int j = 0;
              while (reader.Read())
              {
                  GameTitle[j] = reader.GetString(0);
                  j++;
              }
              reader.Close();
              connection3.Close();
              return GameTitle;

          }

  Error Code:

  System.Data.OleDb.OleDbException: Data type mismatch in criteria expression.
     at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
     at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
     at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
     at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
     at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
     at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
     at System.Data.OleDb.OleDbCommand.ExecuteReader()
     at GamesWebService.Service1.FeaturedGames() in C:UsersJereldDocumentsVisual Studio 2010ProjectsGamesWebServiceBackupGamesWebServiceService1.asmx.cs:line 126