Search results

  1. R

    Sql for a combo using text control from parent form

    Private Sub cboConsulta_GotFocus() Dim strsql As String strsql = "SELECT ID_Verificação,Verificação FROM tblVerificacao WHERE ID_Peça = '" & Parent!TxTId_Peça & "' ORDER BY Verificação;" Me!CboConsulta.RowSource = strsql End Sub Message Box: Data type mismatch in criteria with data field...
  2. R

    Insert Into do not find my table on split bd

    Private Sub Form_AfterInsert() Dim strSql$ MsgBox "Nova Peça Criada" srtSQL = "INSERT INTO tblVerificacao (Verificação,ID_Peça) VALUES (""1"",'" & Me!TxtID_Peça & "')" CurrentDb.Execute strSql End Sub Table not found, but this linked table from my backend is correct. What is wrong?
  3. R

    Table relationship in front end?

    I was creating a form by form wizard that has fields from 3 tables that is located on my back end db. When I finished the process, it informs that I don´t have relationship between the tables and then I was dropped in mey front end relationship tab. These tables are all related in my back end...
Back
Top Bottom