compile errors

  • Thread starter Thread starter doobrie
  • Start date Start date
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
 
further info ...

if i play this section it stops at

..list38 with compile error: method or data member not found
 
this is where the debugger points me to, highlighting the sub flub() -
this is the extract of whats there:-

Sub flub()
With Me.List38
Click to expand...

ok, what does the above mean then?

sub flub() - what is this doing?
With Me.List38 - and this?

and i can at least start looking up whatevers needed after that at least
 
Back
Top