473,748 Members | 2,207 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

#Name? Error Access 2007

2 New Member
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 7074
puppydogbuddy
1,923 Recognized Expert Top Contributor
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

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

Similar topics

5
6159
by: Eric Davidson | last post by:
I keep getting the folowing error message in my db2diag.log every couple of seconds, and I can not find any information on this on the DB2 website or in the apr's Can anyone give me a pointer why this is happening. PS I only noticed this once I had migrated to v9 db2level DB21085I Instance "DB2" uses "32" bits and DB2 code release
17
4881
by: =?Utf-8?B?RGF2ZQ==?= | last post by:
I have set up a virtual directory using IIS. Whenever, I load a web page of type .htm, I have no problem. Whenever I run a .aspx page I get the statement below. I am running on XP Pro, both Microsoft .Net 1.1 & 2.0 installed. How do I remedy this error? //Error below Server Application Unavailable The web application you are attempting to access on this web server is
0
5252
by: Tifer | last post by:
Hello, I am building my first .Net Application. The first couple of Publish and Installs I did went fine. But after a couple of builds, I get a modal dialogue box error every time upon trying to install using the setup.exe. Title is "Cannot Start Application" and it says: ==================== Cannot download the application. The application is missing required files. Contact application vendor for assistance.
1
6806
by: ishwarjoshi | last post by:
I am in the process of upgrading an old Access ADP/SQL 2000 App to Access 2007 ADP/SQL 2005. There are a lot of buttons in the Access form which are calling Access Macros, the Macros call Stored Procedures in the SQL database. This is resulting in '2950 Error' for all the macros. Here is Microsoft' answer for that error: http://support.microsoft.com/kb/931407 *edit*
13
9203
by: Neil | last post by:
Can I get the name of a procedure from within the procedure? In my error handler, I write the error to an error table. I'd like to write the name of the procedure that's writing the error. But, rather than customizing each error handler with the procedure name, it would be nice to be able to call a system variable or function that gives me the procedure name and module name. Is that possible?
6
8770
by: tony.abbitt | last post by:
I have recently installed Office 2007 (SP1) retaining the previous installation of Office 2003. I have converted an Access 2003 database to Access 2007. The database contains the VBA code 'DoCmd.RunCommand acCmdLinkTables' to initiate the dialog box to rebuild links to tables held in a back-end Access database (which has also been converted from Access 2003 to Access 2007). The code runs without problem in the original Access 2003...
0
2757
by: Sebastian | last post by:
Hello I develop my applications in Access 2002. My development system is running Windows XP SP2 and I have Microsoft Office XP Developer. Microsoft Office XP is at SP3. I used Inno Setup (great product) to install my applications. When the Access Runtime was needed on the system I simply ran 'accessrt.msi' from Microsoft Office Developer discs. When another version of Access (other than Access 2002) was on the system then I simply...
0
1147
by: GreinerCon | last post by:
The application was built in Access 2000 and upgraded to Access 2002 and currently runs on desktops with Access 2002, 2003 and 2007 in multi user environment. The MDB file executes the expression fine without error yet the MDE file displays a #NAME? error in the textbox on some of the desktops, I can not determine why the expression fails on only some of the desk tops. The date settings all appear to be the same
5
5893
by: Tony | last post by:
I am continuing to develop an Access 2007 application which was originally converted from Access 2003. In Access 2003 I was able to disable the Access Close button in the top righthand corner of the screen. I have been unable to find any way to disable this button in Access 2007 and subsequently I have been forced to find ways to detect and handle the situations after the Access Close button has been clicked. I have been largely...
0
8991
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8831
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9552
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
9326
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8245
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6796
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4607
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3315
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2215
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.