By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,489 Members | 1,932 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,489 IT Pros & Developers. It's quick & easy.

#Name? Error Access 2007

P: 2
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
Share this Question
Share on Google+
1 Reply


puppydogbuddy
Expert 100+
P: 1,923
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.