Hi,
I'm working on a small calculating prog in Autocad.
It should take a record from a access database table, and calculate it.
I already got the calculating part going, but can anyone help me to
sort the table according to a certain fieldname.
Also, if i want to
loop the caltulation on every record till it finds a correct one, how do i do that?
This is the code that i have:
Public wksObj As Workspace
Public dbsObj As Database
Public tblObj As TableDef
Public fldObj As Field
Public rstObj As Recordset
Private Sub CommandButton5_Click()
'Berekeningen en toetsen.
Set dbsObj = DBEngine.Workspaces(0).OpenDatabase("D:\My Documents\project\7m535\access database\profielen.mdb")
Set rstObj = dbsObj.OpenRecordset("profielinfo", dbOpenTable)
'Ascending
Dim SQLString As String
SQLString = "profielinfo.* FROM profielinfo ORDER BY profielinfo.profielhoogte ASC;"
so the thing now is that it keeps picking the number 1 id record instead of the first of the fieldname"profielhoogt" that should have been sorted in ascending order.
if someone can help me on this i'd be very grateful