I'm using MSFlexGrid to display my MS Access table on the screen.
Previously I have only 5 columns. I have added one more column [Status] but having the run time error when I execute the program.
"[Microsoft][ODBC MS Access Driver] Circular reference caused by alias "status" in query defination 's SELECT list."
And here is my code:-
.ActiveConnection = conn
.CommandText = "select TranDate as [Rework Date],Section as Location,modelno as [Model],serialno as [Serial Number],wo as [Remarks], Status as [Status] from serial_tracking_tbl where format(trandate,'short date') = ?" & " order by trandate desc"
.CommandType = adCmdText
Set dateParam = .CreateParameter("date", adDate, adParamInput)
dateParam.Value = Format(txtdate.Text, "short date")
Set rs_daily = .Execute()
.Cols = 6
.ColWidth(0) = 2000
.ColWidth(1) = 2800
.ColWidth(2) = 2000
.ColWidth(3) = 2100
.ColWidth(4) = 3200
.ColWidth(5) = 1000
Anyone can help?