一个简单的问题有关combobox的 代码帖出来。另外,你的combobox是不是与数据源绑定了? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Private Sub Form_Load()Dim sql$On Error Resume NextCombo1.Text = ""Combo2.Text = ""Combo3.Text = ""Combo4.Text = ""Text1.Text = ""Adodc1.Visible = FalseAdodc1.ConnectionString = "provider=microsoft.jet.oledb.4.0;" & "data source=" & App.Path & "\data\database.mdb"Adodc1.CommandType = adCmdUnknownSet conn = New ADODB.ConnectionSet rs = New ADODB.Recordsetconn.ConnectionString = "provider=microsoft.jet.oledb.4.0;" & "data source=" & App.Path & "\data\database.mdb"conn.Opensql = " select distinct country,ontime,men,ktime from add1"Set rs = conn.Execute(sql)While Not rs.EOF Combo1.AddItem rs!country Combo2.AddItem rs!men Combo3.AddItem rs!men Combo4.AddItem rs!ktime rs.MoveNext WendEnd Subcombo没有绑定 这个问题最好在SQL语句中处理Disinct不行,就用Group BY country,men,ktime 这种方式只能多个rst赋值,distinct和group by 都是无效的 将combo中内容作个判断,发现相同的就删除该项 如何使用timer将字号由大变小之后再由小变大 元旦快乐 求助!!!!!在VB中如何访问指定IP地址的SQL-SERVER 采集程序问题 请问,我用VB带的Dackage&Deployment做安装程序,遇到点小问题~请教大家~! 收集编程经验和好的习惯。UP有分! 一个摸名奇妙的问题 请各位大侠近来看看 (请斑竹帮忙 ) 调用存储过程:sp_tables_ex的问题 初学者如何编写网络版程序?使用什么来编程?是COM+还是WINSOCK? 我错在那里呀,一个查询问题,请大家帮忙呀!! 请问如何使屏幕上的窗体居中显示??!!,很急 读取TXT文件的时候,如何判断读入的是空格和回车呢?
Dim sql$
On Error Resume Next
Combo1.Text = ""
Combo2.Text = ""
Combo3.Text = ""
Combo4.Text = ""
Text1.Text = ""
Adodc1.Visible = False
Adodc1.ConnectionString = "provider=microsoft.jet.oledb.4.0;" & "data source=" & App.Path & "\data\database.mdb"
Adodc1.CommandType = adCmdUnknown
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.ConnectionString = "provider=microsoft.jet.oledb.4.0;" & "data source=" & App.Path & "\data\database.mdb"
conn.Open
sql = " select distinct country,ontime,men,ktime from add1"
Set rs = conn.Execute(sql)
While Not rs.EOF
Combo1.AddItem rs!country
Combo2.AddItem rs!men
Combo3.AddItem rs!men
Combo4.AddItem rs!ktime
rs.MoveNext
Wend
End Subcombo没有绑定
ktime