473,792 Members | 2,877 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Conditionally Displaying Information On a Report

1 New Member
Hello everyone,

I am a first time user of The Scripts (although I have taken many useful tidbits back to my desk from other discussions).

I am currently developing a database that will track sales performance against forecasts. Forecasts and buy plans are entered through forms into static tables. Actual sales data, including sales, weeks of stock, and inventory OH + OO is loaded in weekly using a macro.

The information comes out of the local ICS in a text report, which I then import and format. In order to store the new data, I strip the report through a series of queries, and make new tables with the appropriate fields added to them. The new fields are assigned a name based on the week, so I always know what the data in the future will be called.

The problem I am having is that my report shows all of the data on a quarter by quarter basis - but not all of the sales data is present. The report is designed with controls for the future fields of sales data, but as they are not in the database, I get a long series of #NAME? errors.

How can I format the report to not show the controls with a #NAME? Error?

Thanks
Oct 23 '07 #1
1 1324
Rabbit
12,516 Recognized Expert Moderator MVP
There may be a better way to design your report but you can use the On Render event and the IsError function to set the visibility of your controls.
Oct 23 '07 #2

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

Similar topics

3
1735
by: alwayswinter | last post by:
I currently have a form where a user can enter results from a genetic test. I also have a pool of summaries that would correspond to different results that a user would enter into the form. I ideally I would like to have the user enter their results and then have a master summary created with the different word or HTML files on submit. (condition 1 + condition 2 = combining/displaying corresponding HTML files) I've gotten as far as...
5
2226
by: Robert | last post by:
Hello Accessors I have some reports created in Access that are very good for what they do. However, it seems to me that when you are displaying information you don't need to print out that a printer-friendly report is not the best way to go. So, I tried converting one of my Access reports to an Access form. I selected the continuous view to allow displaying multple records but when I went to define my sorting and grouping there was none...
2
2034
by: Master.Shankar | last post by:
Hello Friends, I am working on a C# windows Application which generates a crystal report . There is a subreport embedded in the main report . I want this subreport to open automatically in a new tab when the main report is generated and displayed. As of now , since it is an OnDemand report, it displays a link for the sub report clicking on which will open the sub report in a new tab page.I dont want to have the report as an OnDemand...
0
1514
by: latin & geek via DotNetMonster.com | last post by:
hi! ok, im working on a database application. ive successfully managed to establish a relationship between two tables and display them on a datagrid, edit and add new records to them. now i need to generate a report using the parameters in the child table, and two columns from the parent table. this is where the problem starts. when i use two seperate connection links and extract the required data, adding it all to the same dataset,...
1
976
by: ATroy | last post by:
Hello: I've created a strongly typed dataset which I know has rows of information but the information in the dataset isn't displayed on the report form. All that are visible are the report buttons and the column headings. Any suggestions on what I should be focusing on or what I'm missing? Thanks, AT
20
4497
by: Tim Reynolds | last post by:
Team, I am developing a web service. In testing in on my enw PC, I am expecting to see exceptions thrown appear on my browser. Instead I am getting an HTTP 500 Internal Server Error page and I am not seeing my exception details. The web.config file being used has the setting <customErrors mode="Off"/>. This should allow me to see the detailed exception info. On a different computer - same code - same web config - the exception details...
1
1464
by: jeffrey.bergstedt | last post by:
I'm using VBA to dynamically add rows of textboxes to a Report, then assign values to those textboxes. The values are definitely being assigned as I can MsgBox them afterward and the values come up, but they are NOT actually showing on the Report. Here's the code: Private Sub Command0_Click() Dim NewTextBox As TextBox DoCmd.OpenReport "UserReport", acViewDesign
3
2074
by: Naushad | last post by:
Hi All, I am trying to open the report conditionally from the dialogue box form. In the form there are three field. cboEmployees StartDate EndDate I have used these field in criteria to open the report. If I use the
4
3052
by: =?Utf-8?B?ZGNoMw==?= | last post by:
Is there a way to conditionally format a dateTime field to produce on result if the value is 10/31/2008 12:00 AM (user didn't enter a time) and another result if the value is 10/31/2008 5:30 PM (user entered a time). I'm looking for this result... Value Result 10/31/2008 12:00 AM FRI 10/31/08 10/31/2008 12:01 AM FRI 10/31/08 12:01 AM I also need to figure out the cell spacing to force the time...
0
9518
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
10430
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...
0
10211
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
10159
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
9033
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...
0
6776
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
5436
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
5560
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3719
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.