473,836 Members | 1,535 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Name? error in Report - print view only (access 2010)

23 New Member
Hi - I have a report that's based off a query. The first field in my report is a field from the query that was a combination of 2 different fields (company & state) - looks great in the query, no problems. I run my report and it's perfect, pulls in the field just as expected - until I either export to PDF or do a Print Preview, at which point it displays "Name?" in that field. My report has this field listed for each company, and the rest of the report displays perfectly in either view; it's just the very first record that gets that error.

Any ideas? I'm sure I'm doing something wrong somewhere, but haven't been able to identify what - despite Googling it and searching everywhere I can think.

Thanks for your help!
Jan 19 '12 #1
12 8448
32,584 Recognized Expert Moderator MVP
Please provide the relevant part of the SELECT line (from the SQL of your query), as well as describe how the control on your report is defined. I assume it's a TextBox. Does any code run in your report's Open event procedure?
Jan 19 '12 #2
Katie Howard
23 New Member
Here's the Select statement from the query:

[Organization_de sc].[Organization] & ", " & [Organization_de sc].[State] AS Org_State

The form's record source is this query, and the Control Source for this field is Org_State (which I can pick from a drop-down menu).
And yes, it's a Text Box.

I should also mention that I have a secondary field in my query/report that's a combination of fields (full name which combines first and last name), and there's no trouble at all with that field.
Jan 19 '12 #3
32,584 Recognized Expert Moderator MVP
And no code in the report's module anywhere?

I must admit I see nothing untoward with what you've shown so far. It would make that field non-updatable, certainly, but why it would fail to display in any circumstances you've described I don't know - unless the code is interfering.
Jan 19 '12 #4
393 Contributor
For the control that won't print, check to see if it's named "Org_State" . If so, change it.
Jan 19 '12 #5
Katie Howard
23 New Member

It's not - it's called "Organizati on". I changed the name, anyway, just for the fun of it - and that didn't help at all.
Jan 20 '12 #6
Katie Howard
23 New Member
I just tried changing the field that gets pulled in, and instead of having it be a combined field (organization and state), I did a single field (organization) and am getting the exact same "Name?" error in print preview only, for the first record in the report only. I'm completely stumped...
Jan 20 '12 #7
32,584 Recognized Expert Moderator MVP
And no code in the report's module anywhere?
Were you able to confirm this Katie?

I must admit - my ideas are running out on this one. I was hopeful for Dsatino's suggestion, but even that drew a blank it seems :-(
Jan 20 '12 #8
Katie Howard
23 New Member
Correct - no code anywhere in the Report.
Jan 20 '12 #9
32,584 Recognized Expert Moderator MVP
In that case I am stumped. Sorry. In your position I'd try to recreate the report from scratch in case of some type of corruption. Normally, when something is confusing it just means we don't understand well enough, but there's also a slim possibility that the db is corrupted somewhere. Don't be surprised if it's not, but if it were me I'd check that at least until I saw the same problem occurring.

I'm afraid that's all I have for you Katie, and I know it's little enough. Sorry.
Jan 20 '12 #10

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

Similar topics

by: pottschmidtr | last post by:
I receive the following error 'Request for the permission of type System.Security.Permissions.StrongNameIdentityPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.' when I try to access a property or method of the library. I was wondering if the library is secure with a key, so the caller has to be sign with same key or I'm calling the library incorrectly. Do I need an assembly tag with in...
by: hawk | last post by:
I am creating a series of custom reports, whose parameters are specified through combo boxes in a form, which then generates a custom report based on a series of calculation queries. My problem is this...at the top of the report I've inserted several text boxes which link to the combo boxes on the entry form, and are supposed to show which parameters a particular report is being generated from. On the screen, everything looks great and...
by: Tom Louchbaum | last post by:
When I preview my Access 2000 Report it looks fine. When I Email the report using DoCmd.SendObject acSendReport, "Report", acFormatRTF, "To Address", , , "Subject", , False the resulting attachment to the email consistently does not display all of the lines it should in one of the GroupFooters. I am using the Print event in the report to print lines multiple times in a groupfooter depending on an integer set elsewhere in the VBA...
by: Gilberto | last post by:
pks00 Expert 280 Posts April 16th, 2007 01:08 PM Re: How to print MS Access 2000 report to PDF995 printer by VBA Code Sweet, your using pdf995, makes answering this question that much easier :)
by: shayvillere | last post by:
I'm designing a report and cannot pull data from a query. The control gives me a #Name? error when I do a print preview. I never had this problem with Access 2000. Any ideas?
by: jaad | last post by:
Hello, I have a database that was written in access 2007 on my pc. I wanted to work off site with the database so I uploaded it onto my laptop which is loaded with access 2010 beta. When I finished working with the database and return it to my pc(which has access 2007) I can't get it open because Access say that the file is not the right format. Does anyone have a way to work around this compatibility problem? So you know I...
by: sierra7 | last post by:
It seems Access 2010 is associating an 'input mask' or field type with a combo box when a form is opened, even though there is no Format setting on the control. I have a form which has been running OK for years in Access 2003; it adds an item selected from an inventory listing to either an existing Sales Order or Purchase Order. For historic reasons Purchase orders are alphanumeric and Sales orders are numeric (long integer). The RowSource...
by: Alan Yim | last post by:
Hi folks, My company recently upgraded our Office suite from 2003 to 2010. The problem in particular is with an Access database that was originally designed in Access 2003. The code in question used work in 2003 (see below code). Private Sub engSave_Click() Dim strSql3 As String 'Archive order number and cost data for engine.
by: Bill Boord | last post by:
I need to be able to shut off the AutoCorrect "feature" within Access 2010 code. I have utilized Application.SetOption with method strings for other startup requirements, but I cannot seem to find a correct method string to turn off the text replace "feature." I am not talking about the "Track Name AutoCorrect Info" method, but rather the method that corresponds to the checkbox if one were to enter Access 2010 and click File, Options,...
by: Scorp Scorp | last post by:
Dear All, I designed a report, and bound with some data, the retreived data is 7 coloumns. I set a buttong to open the report in print preview, also to show display the page in landscape. Now on report design view it shows the width of the report to be 22". When the report is displayed, the 6th colomn and the 7th colomn are showed on a new page, moreover the 6th colomn is showed splitted, half of text on one page and the other on the...
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...
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,...
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...
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...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
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...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
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
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.