Share via

Compile Error: Method or data member not found. Opening old database with macros.

Anonymous
2022-03-24T15:04:31+00:00

I'm opening a database created in 2000 with Access 2016. There is a module that is used to import data from a text file (extension is .ftl for fault tree logic). I get the following compiling error when I try to import. Seems like it doesn't recognize ".gate". I'm wondering if there is an object library that I don't have referenced. Is there a way to look at the contents of all the reference libraries available?

Microsoft 365 and Office | Access | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. DBG 11,531 Reputation points Volunteer Moderator
    2022-03-24T15:29:07+00:00

    Have you checked your references to see if you have anything missing?

    PS. Just looked closely at your code. If StatusSet is a recordset object, then try changing your code to use the bang operator. For example:

    StatusSet!gate = GateName

    0 comments
  2. ScottGem 68,780 Reputation points Volunteer Moderator
    2022-03-24T20:44:00+00:00

    First, what you show is NOT macros but VBA code. They are not the same. Second, have you updated the file format to accdb? You should!

    StatusSet is not defined in the code you are showing. So it must be defined elsewhere. VBA syntax in Access gets tightened up with each version. So sloppy code that worked in earlier versions may no longer work.

    0 comments