How to fix Access error? CSIDL_Personal highlighted with "Constant expression required"

MAR_N 0 Reputation points
2023-01-31T15:06:48.6766667+00:00

I am not a programmer. I have an access file that was set up a long time ago. It was working fine. Now the PDFPrint function not working. One of the scripts is named "ShellGetFolder", and when I run it, it always gives me this error.

User's image

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,483 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
821 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Gustav 712 Reputation points MVP
    2023-02-01T09:20:23.59+00:00

    There probably exists some hidden garbage in those code lines.

    So, before the line:

    Dim objShell

    retype - no copy-paste - the four lines beginning with

    Function ShellGetFolder( _

    Then delete the old lines.

    Finally, Compile and Save the module.

    0 comments