如何将.mdb中的勾选状态同步到Tkinter复选框或Treeview？

首先明确：Access的Yes/No类型复选框，通常存储为-1（勾选/Yes）和0（未勾选/No），部分场景下也会用布尔值True/False，处理时先做值判断再转换为Tkinter可识别的状态。

一、打印展示直观的勾选状态 #

修改原代码的循环逻辑，将数据库返回的原始值转换为易读的标识（比如✅/❌或文字）：

from tkinter import *
from tkinter import ttk
import pyodbc

root = Tk()
root.geometry("1500x1000")

def query():
    conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=\\<pathway goes here>.mdb;')
    c = conn.cursor()    
    c.execute("SELECT * from users ORDER BY fullname")
    records = c.fetchall()
    
    print_records = ''
    for record in records:
        # 转换复选框状态为直观文字/符号
        checkbox_state = "✅ 已勾选" if (record[2] == -1 or record[2] is True) else "❌ 未勾选"
        print_records += f"姓名: {record[1]} | 复选框状态: {checkbox_state}\n"  # 假设record[1]是fullname字段
    
    query_label = Label(root, text=print_records, justify=LEFT)
    query_label.grid(row=8, column=0, columnspan=2, padx=10)
    
    conn.close()

query_btn = Button(root, text="显示记录", command=query)
query_btn.grid(row=7, column=0, columnspan=2, pady=10, padx=10, ipadx=137)

root.mainloop()

二、导入至Treeview并展示状态 #

如果要将数据导入Treeview表格，先创建Treeview组件，再逐条插入转换后的状态：

from tkinter import *
from tkinter import ttk
import pyodbc

root = Tk()
root.geometry("1500x1000")

# 创建Treeview表格
tree = ttk.Treeview(root, columns=("ID", "姓名", "复选框状态"), show="headings")
tree.heading("ID", text="用户ID")
tree.heading("姓名", text="全名")
tree.heading("复选框状态", text="状态")
tree.column("ID", width=80)
tree.column("姓名", width=200)
tree.column("复选框状态", width=120)
tree.grid(row=8, column=0, columnspan=2, padx=10, pady=5, sticky=NSEW)

def query():
    # 清空表格现有内容
    for item in tree.get_children():
        tree.delete(item)
    
    conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=\\<pathway goes here>.mdb;')
    c = conn.cursor()    
    c.execute("SELECT * from users ORDER BY fullname")
    records = c.fetchall()
    
    for record in records:
        checkbox_state = "已勾选" if (record[2] == -1 or record[2] is True) else "未勾选"
        # 插入表格行
        tree.insert("", END, values=(record[0], record[1], checkbox_state))
    
    conn.close()

query_btn = Button(root, text="加载至表格", command=query)
query_btn.grid(row=7, column=0, columnspan=2, pady=10, padx=10, ipadx=137)

# 让表格自适应窗口大小
root.grid_rowconfigure(8, weight=1)
root.grid_columnconfigure(0, weight=1)

root.mainloop()

三、生成独立的Tkinter可交互复选框 #

如果要为每条记录生成可点击的复选框控件，可在循环中动态创建Checkbutton：

from tkinter import *
from tkinter import ttk
import pyodbc

root = Tk()
root.geometry("1500x1000")

def query():
    # 清除之前生成的旧复选框
    for widget in root.grid_slaves(row=8, column=0):
        if isinstance(widget, Checkbutton):
            widget.destroy()
    
    conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=\\<pathway goes here>.mdb;')
    c = conn.cursor()    
    c.execute("SELECT * from users ORDER BY fullname")
    records = c.fetchall()
    
    # 动态生成复选框
    for idx, record in enumerate(records):
        var = BooleanVar()
        # 根据数据库值设置复选框初始状态
        var.set(True if (record[2] == -1 or record[2] is True) else False)
        cb = Checkbutton(root, text=record[1], variable=var)
        cb.grid(row=8 + idx, column=0, sticky=W, padx=10, pady=2)
    
    conn.close()

query_btn = Button(root, text="生成复选框", command=query)
query_btn.grid(row=7, column=0, columnspan=2, pady=10, padx=10, ipadx=137)

root.mainloop()

注意事项 #

• 先确认数据库中复选框字段的实际存储值：如果不是-1/0或True/False，需调整判断条件适配实际数据。
• 查询操作无需conn.commit()，直接关闭连接即可。
• 动态生成控件时，记得先清除旧控件避免重复堆积。

内容的提问来源于stack exchange，提问作者marcspector1972