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

Folks,

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?

Thanks,
J.D. Haight

How does this related to Windows Update functionality? How about posting to
an Access newsgroup instead?
--
~Robear Dyer (PA Bear)
MS MVP-IE, Mail, Security, Windows Desktop Experience - since 2002
AumHa VSOP & Admin http://aumha.net
DTS-L http://dts-l.net/

J.D. wrote:
> 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.

Duly noted. Advice followed. Self considered chastised.

Thanks,
J.D.

"PA Bear [MS MVP]" wrote:

> How does this related to Windows Update functionality? How about posting to
> an Access newsgroup instead?
> --
> ~Robear Dyer (PA Bear)
> MS MVP-IE, Mail, Security, Windows Desktop Experience - since 2002
> AumHa VSOP & Admin http://aumha.net
> DTS-L http://dts-l.net/
>
> J.D. wrote:
> > 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.
>
>

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
http://www.eggheadcafe.com/default.aspx?ref=ng