Error Message-Run Time Error '438'-Access 2003 vs 2000 Issue??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know what this error is? "Run Time Error '438' Object Does not
support this property or method." My Search screen functionality works on my
laptop (running on Access 2003) but when I load it onto another PC (Access
2000), I get the above error. Is this a PC problem, version or some other
problem?

Thank you!!!

SQLstmt = SQLstmt & " order by a.contract_no, a.doc_type"
findFlag = "N"
rst_Contractrec.Open SQLstmt, CurrentProject.Connection, adOpenDynamic,
adLockOptimistic
Do Until rst_Contractrec.EOF
If Not rst_Contractrec.EOF Then

*****the error occurs in the line below*****
Me!main_list_box.AddItem (rst_Contractrec!Contract_no & ";" &
rst_Contractrec!Doc_type & ";" & rst_Contractrec!Customer_no & ";" & "'" &
rst_Contractrec!Customer_name & "'" & ";" & rst_Contractrec!Acceptance_date &
";" & rst_Contractrec!Contract_end_date & ";" & rst_Contractrec!Volume_flag)
*****the error is in the line above*****


findFlag = "Y"
End If
rst_Contractrec.MoveNext
Loop
 

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

Similar Threads

SQL select statement question 2
How to Save Records only if no records exist in another table? 4
Database Connection to SQL from Access 2003 5
Access 2000 to 2003, get error 438 3
Run time error - 438 2
Excel 2007 vs Excel 2003 = Runtime Error 438 4
Access 2000 vs 2003 Problem 2
Run-Time Error '438' Problem 2

Back
Top