Share via

ms access - Undefined function 'Dir' in expression. (Error 3085)

Jason Henry 0 Reputation points
2024-03-01T13:33:19.7166667+00:00

I.T have updated office 365 to the latest version. A access database now has all the security features set on it as attached. When i run on previous version this yellow security tag does not appear. The real problem is that the 3085 error stops a report running in the database which uses the DIR function. Have had this problem before and it is usually missing references, re added references but nothing works. Please help

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
5,124 questions
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,710 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
400 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,989 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
9,893 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. George Hepworth 0 Reputation points
    2024-05-11T22:47:16.01+00:00

    One possibility would be that you updated to a 64 bit version of Office from a 32 bit version. In some cases, VBA which uses APIs can fail due to the bitness difference. One of the symptoms of that is the failure of common functions like Dir().

    What version and build of Access do you have installed?

    0 comments
  2. George Hepworth 0 Reputation points
    2024-05-11T22:49:41.3633333+00:00

    One possible reason for the failure of common VBA functions is that update installed was a 64 bit version instead of the original 32 bit version of Office.

    What version and build of Access do you have installed?

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.