Private Sub Form_Load()
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\db1.mdb;Persist Security Info=False"
Adodc1.RecordSource = "SELECT * FROM Farsi"
Adodc1.Refresh
End Sub
Private Sub cmdTranslate_Click()
Dim i As Long
Adodc1.RecordSource = "SELECT * FROM English WHERE English_Word LIKE('" & Text1 & "%')"
Adodc1.Refresh
If Adodc1.Recordset.EOF = False Then
Text1 = Adodc1.Recordset.Fields("English_Word")
i = Adodc1.Recordset.Fields("Word_ID")
Adodc1.RecordSource = "SELECT * FROM Farsi WHERE English_ID=" & i
Adodc1.Refresh
Text2 = ""
While Not Adodc1.Recordset.EOF
Text2 = Text2 & Adodc1.Recordset.Fields("Farsi_Word")
Adodc1.Recordset.MoveNext
Wend
Text1.SelStart = 0
Text1.SelLength = Len(Text1)
Else
Text2 = "يافت نشد"
End If
End Sub