sql="S ELECT * FROM Table1 WHERE NAME

select củ chuối form củ mài where củ riềng

---------------------------------------------
Private Sub Combo11_AfterUpdate()
   Me.Text13 = GetDept(Me.Combo11)
End Sub

Sao dùng WHERE trong câu lệnh SQL bị chặn nhỉ

SELECT * FROM A HAVING B=C

Đã gửi mail cho support host. Chắc nó có cài filter gì đó.

CurrentDb.Execute "D_ELETE * FROM tblTKDieuChinh", dbFailOnError
Sub DieuChinhLuuKho()
    
    Dim rsTenSP As DAO.Recordset, rsSPThua As DAO.Recordset, rsSPThieu As DAO.Recordset
    Dim strSQL1 As String, strSQL2 As String, strSQL3 As String, strSQL4 As String
    Dim oldSLThua As Integer, oldSLThieu As Integer, SLChuyen As Integer

    CurrentDb.Execute "D_ELETE * FROM tblTKDieuChinh", dbFailOnError
    CurrentDb.Execute "D_ELETE * FROM tblChiTietDieuChinh", dbFailOnError

strSQL1 = "SELECT tblTKDieuChinh.Sanpham F_ROM tblTKDieuChinh GROUP BY tblTKDieuChinh.Sanpham ORDER BY tblTKDieuChinh.Sanpham"

    Set rsTenSP = CurrentDb.OpenRecordset(strSQL1, dbOpenSnapshot)

select * from test where test=test1

Có vẻ ok rồi đó

SELECT * FROM where n=m  HAVING B=C