Forum Discussion

MMLevinton's avatar
MMLevinton
Copper Contributor
Feb 24, 2021

MS Access Filters VBA Debug Error

Hello All, we are running an Access DB that includes filters to help sort through the data.  Because of tech-refresh limitations we have two different type of workstations.  The filters work fine on ...
2016
access
MMLevinton's avatar
MMLevinton
Copper Contributor
Feb 25, 2021

GM George, George_Hepworth 

Thank you for your response.  Please see attached screenshot document.  The code is exactly the same on both systems. 

64 bit windows 10 OS

Office Professional Plus 2016

The differences are one workstation is a Lenovo ThinkPad running SDC 5.7 (works) and the other is a Dell Precision running SDC 10.1909.  

I have put in a ticket with the AF SDC support but am still waiting for their response.

George_Hepworth's avatar
George_Hepworth
Silver Contributor
Feb 25, 2021

MMLevinton 

That looks more like a missing reference.

 

Open the VBE and click on Tools-->References. Are any of them flagged as "Missing"?

 

Yours will, of course, have different references, depending on which ones your relational database application uses. We are interested in those that are "Missing" on the computers that error out, but which are okay on the other computers.

  • MMLevinton's avatar
    MMLevinton
    Copper Contributor
    Feb 25, 2021

    YES!  George_Hepworth 

    That was exactly the issue.  I copied and pasted the missing *.dll file and ...poof... the filters worked.

    Thank you George!

    • George_Hepworth's avatar
      George_Hepworth
      Silver Contributor
      Feb 25, 2021
      Congratulations on solving the problem.

      Continued success with your project.

Resources