#Name? Error Access 2007

[myipmike]

Hi there,

I have an app that produces labels and which runs fine under Access 2000, 2002 and 2003. The compiled 2002 .mde version runs fine under Access 2007 but only sometimes !

i.e. under XP with Access 2007 no SP it's fine

but under XP with Access 2007 SP1 I get #name?
in the label fields

same deal if under Vista with 2007 no SP, and Vista with SP1

The .mdb version works fine and it is only the .mde file that produces the error.

A sample line of the labels report (which is based on a query) is:

=Trim([Address1])

I've checked and removing the Trim function makes no difference.

Can anyone help? I would greatly appreciate any feedback.

Thanks in advance,
Mike

[puppydogbuddy]

Hi there,

I have an app that produces labels and which runs fine under Access 2000, 2002 and 2003. The compiled 2002 .mde version runs fine under Access 2007 but only sometimes !

i.e. under XP with Access 2007 no SP it's fine

but under XP with Access 2007 SP1 I get #name?
in the label fields

same deal if under Vista with 2007 no SP, and Vista with SP1

The .mdb version works fine and it is only the .mde file that produces the error.

A sample line of the labels report (which is based on a query) is:

=Trim([Address1])

I've checked and removing the Trim function makes no difference.

Can anyone help? I would greatly appreciate any feedback.

Thanks in advance,
Mike

Mike,
I would first check the following link about known bugs with Access2007, and see if you can make a connection there.

http://allenbrowne.com/Access2007.html#Bugs

If that didn't help I would look over the "fix" list that came with the instructions for installing SP1 and see if you can connect the dots there.