引用:
作者: mini
寫反了
應該是 format(變數, 字串表達式)
Format(變數, "###.#")
|
再請教大大:
我的程式碼如下,我要如何以Format()格式組合使JobBatchSet的欄位變成(###.#)
謝謝
'=======================================================
Private Sub Form_Load()
ConnStr = "Provider=MSDASQL.1;Persist Security Info=False;" & _
"Data Source=CC_walsin1_07_05_08_09_57_04R"
Sql_Data = "SELECT JobName, JobProcessCode, JobBatchSet, " & _
"JobBatchAct , JobStatus, LastUser, LastAccess " & _
"FROM UA#JobArc"
Adodc1.ConnectionString = ConnStr
Adodc1.CommandType = adCmdText
Adodc1.RecordSource = Sql_Data
Adodc1.Refresh
End Sub
'=======================================================