>
Dim strMyTable As String 
Dim strMyField As String 
Dim strMyCombo As Boolean 
Dim strSQL As String  
strMyTable = "ItemDetails"  '(or whatever the true names are...) 
strMyField = "Chk" 
strMyCombo = False  
strSQL = "UPDATE " & strMyTable _ & "SET " & strMyField & "=" & strMyCombo & ";"          
Application.CurrentDb.Execute strSQL  
End Sub

  • 답변 # 1

    이 시도 :

    Dim strMyTable As String 
    Dim strMyField As String 
    Dim strMyCombo As String
    Dim strSQL As String  
    strMyTable = "ItemDetails"  '(or whatever the true names are...) 
    strMyField = "Chk" 
    strMyCombo = "False"  
    strSQL = "UPDATE " & strMyTable & " SET " & strMyField & "=" & strMyCombo & ";"          
    Application.CurrentDb.Execute strSQL 
    
    

관련 자료

  • 이전 DataTable은 형식화 된 데이터 뒤에 HTML을 추가합니다
  • 다음 html - 크기 조정시 겹치는 부트 스트랩 열