displaying a checkbox in access as a checkbox in vb
-
The checkbox in access is called Completed. i am trying to populate a datagrid based on a SQL statement in VB, including this checkbox, but in the grid, it is only being displayed like a text field - is there anything i can do about this? here is my code for it - any help would be appreciated! Dim checkSQL As String checkSQL = "SELECT OrderGenerate.OrderNumber, Client.Company, OrderGenerate.Completed " & _ " FROM Client INNER JOIN OrderGenerate ON Client.ClientCode = OrderGenerate.ClientCode " & _ " WHERE (((OrderGenerate.OrderDate)=" & dToday & "))" Set RS = Conn.Execute(checkSQL) Adodc1.RecordSource = checkSQL DataGrid1.Visible = True Set DataGrid1.DataSource = Adodc1 Adodc1.Refresh DataGrid1.Refresh
-
The checkbox in access is called Completed. i am trying to populate a datagrid based on a SQL statement in VB, including this checkbox, but in the grid, it is only being displayed like a text field - is there anything i can do about this? here is my code for it - any help would be appreciated! Dim checkSQL As String checkSQL = "SELECT OrderGenerate.OrderNumber, Client.Company, OrderGenerate.Completed " & _ " FROM Client INNER JOIN OrderGenerate ON Client.ClientCode = OrderGenerate.ClientCode " & _ " WHERE (((OrderGenerate.OrderDate)=" & dToday & "))" Set RS = Conn.Execute(checkSQL) Adodc1.RecordSource = checkSQL DataGrid1.Visible = True Set DataGrid1.DataSource = Adodc1 Adodc1.Refresh DataGrid1.Refresh