compile errors

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
 
D

doobrie

further info ...

if i play this section it stops at

..list38 with compile error: method or data member not found
 
D

doobrie

this is where the debugger points me to, highlighting the sub flub() -
this is the extract of whats there:-

Sub flub()
With Me.List38

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top