469,658 Members | 1,778 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,658 developers. It's quick & easy.

#Name? Error Access 2007

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
Feb 12 '08 #1
1 6923
puppydogbuddy
1,923 Expert 1GB
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.
Feb 13 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Eric Davidson | last post: by
17 posts views Thread by =?Utf-8?B?RGF2ZQ==?= | last post: by
13 posts views Thread by Neil | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.