D
doobrie
i have an access database converted from 97 to 2000 which im now trying
to get functioning in 2000 properly ... generally things are ok but one
bug so far is when in a form and i click on the dates section for
started then another date section for finished i get a compile error
that brings up the debugger
i am a complete newbie to access and the folk who wrote this are long
gone and i wondered where i even start to debug this problem
this is where the debugger points me to, highlighting the sub flub() -
this is the extract of whats there:-
Sub flub()
With Me.List38
..RowSource = "SELECT DISTINCTROW NI, Surename, Forename,[Middle Name]
FROM Personnel ORDER BY Surename, Forename"
..BoundColumn = 1
..ColumnCount = 4
..ColumnHeads = True
..ColumnWidths = "0cm, 2.5 cm, 2.5 cm, 2.5cm"
..Requery
End With
End Sub
any pointers please
to get functioning in 2000 properly ... generally things are ok but one
bug so far is when in a form and i click on the dates section for
started then another date section for finished i get a compile error
that brings up the debugger
i am a complete newbie to access and the folk who wrote this are long
gone and i wondered where i even start to debug this problem
this is where the debugger points me to, highlighting the sub flub() -
this is the extract of whats there:-
Sub flub()
With Me.List38
..RowSource = "SELECT DISTINCTROW NI, Surename, Forename,[Middle Name]
FROM Personnel ORDER BY Surename, Forename"
..BoundColumn = 1
..ColumnCount = 4
..ColumnHeads = True
..ColumnWidths = "0cm, 2.5 cm, 2.5 cm, 2.5cm"
..Requery
End With
End Sub
any pointers please