March 11th Office Security Updates and Access VBA Coding and Macro

Discussion in 'Windows Update' started by J.D., Mar 12, 2008.

  1. J.D.

    J.D. Guest


    I've programmed an AccessXP database that makes extensive use of VBA module
    code called via Macro in response to form object events. Since yesterday's
    Office Security updates (multiple), a particular module function called via
    macro has begun to throw Microsoft Visual Basic Run-time error 2427 - You
    entered an expression that has no value.

    On debug, it jumps to the second in a series of about 6 If/Else statement in
    which the [Object].Value is tested for content. The first appears to work
    correctly, but commenting out the following 5 items one at a time causes the
    function to fail on the next If/Else statement (and yes, each terminates with
    an End If).

    The macro security is set to run at Low and Sandbox has been disabled.

    Any thoughts?

    J.D. Haight
    J.D., Mar 12, 2008
    1. Advertisements

  2. How does this related to Windows Update functionality? How about posting to
    an Access newsgroup instead?
    PA Bear [MS MVP], Mar 13, 2008
    1. Advertisements

  3. J.D.

    J.D. Guest

    Duly noted. Advice followed. Self considered chastised.


    J.D., Mar 13, 2008
  4. I think it directly applies. I also have an Access application that runs everywhere. Recently one laptop user downloaded all MS Updates and the application stopped working with this error. For him only. We did a system restore to the point before the Security Updates and it works fine. Env is WindowXP Access 2003

    EggHeadCafe - .NET Developer Portal of Choice
    Bret Griswold, Jan 14, 2009
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.