Search results

  1. V

    Solved Use select to define the value of a var

    Hello, I'm trying to use "Select" to define the value of a Var My try: CodigoRequisicaoDevolucao = "SELECT * FROM tabela_ferramentas WHERE PatrimonioFerramenta = '" & Me.txt_inserir_patrimonio & "'" But when i use MsgBox to check the value of the var this is the result: There is a way to...
  2. V

    Solved Syntax error

    I'm having problems with Syntax of SQL strings, what is wrong in this string Dim Localizacao As String Dim Patrimonio As String Localizacao = Me.txt_localoculto Patrimonio = Me.txt_patrimonio Comando = "UPDATE FROM tabela_ferramentas SET Local = '" & Localizacao & "'" WHERE...
  3. V

    Solved New access user, Access UPDATE Error 3464 Data type mismatch in criteria expression

    Thank you very much, you helped me a lot :)
  4. V

    Hello Everyone

    Hello Everyone i'm from Brazil and i started studying Microsoft Access a week ago, I was having problems with the documentation and I found this incredible forum that will help me a lot in my studies. :)
  5. V

    Solved New access user, Access UPDATE Error 3464 Data type mismatch in criteria expression

    Hello everyone first time here i'm starting to learn access and i'm having a problem with the SQL update function, Private Sub GerarRequisicao() If Me.txt_oculto = "Existente" _ Then Dim Comando As String Dim DataSaida As Date Dim CodigoREQ As Integer...
Top Bottom