473,657 Members | 2,559 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Report shows #Name? when printed but is OK in Preview

446 Recognized Expert Contributor
Hi, I have a report that displays the correct data in Preview but displays #Name? when printed. (Access 2003)

The field is unbound but the control source is read from a form

Expand|Select|Wrap|Line Numbers
  1. =[Forms]![dialogRecalls].[DatesBetween_Text] & " (Week " & [Forms]![dialogRecalls]![cmbFrom] & " to Week " & [Forms]![dialogRecalls]![cmbTo] & ")"  
ie. it shows a date range in text that is formatted in the form after the user has selected a week number range from the two combo boxes, and then the contents of the combo boxes.

The dialogue form is kept open until the report close event and the contol width is ample for the text.

Has anybody any ideas why the error?

Many thanks
Oct 8 '09 #1
3 3499
ChipR
1,287 Recognized Expert Top Contributor
Do you get the same result if you put code in to just set the value of the text box?
Oct 8 '09 #2
sierra7
446 Recognized Expert Contributor
Sorry Guys! My error!
The dialogue form was being closed from the 'Preview' command button (on the form) after the command to preview the report, so the data was not available if the user subsequently wanted to print the report.

Thanks anyway
Oct 8 '09 #3
NeoPa
32,568 Recognized Expert Moderator MVP
You had me confused there Sierra. Now it makes sense :)
Oct 8 '09 #4

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

Similar topics

1
2367
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...
5
5807
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...
1
17657
by: Nathan Bloomfield | last post by:
Does anyone know if there is any documentation which relates to Access2k + ? or can anyone help adjust the code? I am having trouble converting the DAO references. TITLE :INF: How to Create a Dynamic Crosstab Report PRODUCT :Microsoft Access PROD/VER:1.00 1.10 OPER/SYS:WINDOWS
0
427
by: CSDunn | last post by:
Hello, I have a format issue on an Access 2000 ADP report that I am going to attempt to explain from a 'ten thousand foot view' : I have an Access 2000 ADP report that has a SQL Server 2000 Stored Procedure as its record source. The Proc is called MM_rptTeacherGroupingTest_sp. In order to help communicate the issue I am having with the report, please take a look at the following: http://www.valverde.edu/home/policy/ReportLayout.htm .
1
5174
by: VBSponge | last post by:
Hi all. In A2K i have a report with a control bound to to calculate the page count for the report. I need to retrieve this page count from the report, and build it into a TOC containing this an other reports. All the reports are page-numbered consecutively in the order they are printed (there are 7 reports in total, with about 60 pages in all). I am having an issue with one of my reports returning a seemingly incorrect page count,...
2
4597
by: Wolfgang | last post by:
Hi, I need to timestamp printed records with the printing date. According to the customer's requests the report must be opened in preview-mode and the user clicks on the printer button if he really want to have a hardcopy. The customer selects the records with a special selection form, where he can combine up to appr. 20 different criterias, which are combined to a more or less complex filter string. This string is then written to the...
1
3345
by: adolph | last post by:
I have a problem with pages being printed out of order. An example is a 15 page duplexed report. Title page fine back of title page blank. (As it should be) SEcond page front, bottom says Page 1 of 15. Second page back says Page 10 of 15. Third page front says Page 3 of 15. Third page back says Page 4 of 15. Special not Page 10 of 15 is the correct page IE it duplicated page 10 and placed it in place of page 2. The real page two is...
1
5284
by: AMD_GAMER | last post by:
Hi, I am trying to print address labels. I have a form which asks for the user to input the first name, middle initial, and last name. On the button click to print the label, I have an event procedure which is called. The problem seems to be having two different reports in the same procedure. Basically, I want to check if the user has typed in a middle initial. If no middle initial is typed in, I want to load the report with only the...
11
7320
by: Gord | last post by:
When I open a certain report, it runs some code that generates the records that will be displayed in that report. This works fine. When I go to print preview the report it appears that the code is run again? This is causing certain error problems. 1 Why does the code run for a print preview when the report already exists? 2 What command do I use in code to find out if a report (or any other object for that matter) is already...
0
8305
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
8732
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8503
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
8605
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6163
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
5632
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();...
0
4151
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...
0
4302
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
1953
muto222
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.