• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 50
  • Last Modified:

method or data member not found in access 2016

I get this message when I run this code in Access 2016, I don't get it if I run it in Access 2003, please see attached
Jaile.pdf
0
dailymeat
Asked:
dailymeat
  • 3
  • 2
  • 2
  • +1
1 Solution
 
John TsioumprisSoftware & Systems EngineerCommented:
You must declare rst as DAO.Recordset...probably you forgot the reference
0
 
NorieVBA ExpertCommented:
How have you declared rstDetails?
0
 
Fabrice LambertFabrice LambertCommented:
Rules of thumb:

Always use Option Explicit at top of your modules.
Always declare and fully qualify your variables.
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
dailymeatAuthor Commented:
Thank you for your help, I did not realize that I did not sent you the beginning of the code, please find it attached.
Thanks.
Jaile.pdf
0
 
Fabrice LambertFabrice LambertCommented:
It looks like an ambiguity issue between DAO recordset and ADO recordset.
(guess you referenced the ADODB library ?)

Always fully qualify your variables:
DAO.Database instead of Database.
DAO.Recordset instead of Recordset.

Also, think about using to late binding instead of early binding (that is: using explicit references).
0
 
dailymeatAuthor Commented:
That worked!! Thank you.
0
 
John TsioumprisSoftware & Systems EngineerCommented:
In the 1st post i have pointed you to the solution but you probably you missed it...anyway...
0
 
dailymeatAuthor Commented:
Sorry, not sure what can I do
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now