March 11th Windows Update and VBA (dis)functionality in Access

  • Thread starter Thread starter J.D.
  • Start date Start date
J

J.D.

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
 
Was one of the updates installed Office SP 3? There are several known bugs
and hotfixes available with that pack.
 
J.D.,

Oops, ignore my post. I missed your reference to OfficeXP. SP3 applies to
Office 2003.

nomadk said:
Was one of the updates installed Office SP 3? There are several known bugs
and hotfixes available with that pack.

J.D. said:
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
Click to expand...
Click to expand...
 
nomadk,

Thanks for responding. The database is in 02-03 format, but the problem
originally surfaced when it was run in Access 2003, so SP3 was a factor.
However, I down-revv'ed to AccessXP (a total Office03 uninstallation and
OfficeXP reinstallation) and the problem still persisted.

It seems to be related to subforms for which no records exist. Instead of
displaying a blank version of the subform for entry of a new record, it
displays no subform fields and the VBA code to change the text of the
corresponding tab control fails.

Thanks,
J.D.

nomadk said:
J.D.,

Oops, ignore my post. I missed your reference to OfficeXP. SP3 applies to
Office 2003.

nomadk said:
Was one of the updates installed Office SP 3? There are several known bugs
and hotfixes available with that pack.

J.D. said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top