6/30/2012

Conditionally format a field in a report in Access 2003/XP/2000/97

Conditionally format a field in a report in Access 2003/XP/2000/97 Question: In Access 2003/XP/2000/97, I have a database and I want to change the Background color of a field on a Report based on the value. Is this possible?
Answer: We've created a sample Access database that demonstrates how to apply a conditional format to a report in Access97.

Conditional formatting - Change the formatting of a field in a report when the field contains a NULL value in Access 2003/XP/2000/97

Conditional formatting - Change the formatting of a field in a report when the field contains a NULL value in Access 2003/XP/2000/97 Question: In Access 2003/XP/2000/97, I'm trying to create a report that will highlight a field that "Is Null". How can I do this?
Answer: If you want to highlight a field that "Is Null", you can apply conditional formatting. To do this, open your Access report and highlight the field that you want to change the behavior of. In this example, we've selected the OrderDate field.

Conditional formatting - Change the formatting of a field in a report based on its value in Access 2003/XP/2000/97

Conditional formatting - Change the formatting of a field in a report based on its value in Access 2003/XP/2000/97 Question: In Access 2003/XP/2000/97, I am trying to create a report that will have one field change colors based on the results of a query. How do I do this?
Answer: If you want to change a field in a report based on its value, you can apply conditional formatting. To do this, open your Access report and highlight the field that you want to change the behavior of. In this example, we've selected the CategoryID field.

6/29/2012

Fill in missing data on a graph in Access 2003/XP/2000/97

no image Question: In Access 2003/XP/2000/97, I've created a report bar graph and each bar represents the data from a different year. There are some years where there is no data, in other words, there are no records with that year in them, so that year is skipped on the graph. How can I get the years without data to appear on the graph with no bar because there is no data?
Answer: To force the years without data to appear on the graph, you'll have to create some additional queries.
Let's take a look at an example.

Create a graph (ie: chart report) in Access 2003/XP/2000/97

no image Question: In Access 2003/XP/2000/97, is it possible to create a graph?
Answer: Yes, in Access you can create a graph. This is called a Chart report.
Let's walk through an example.
Open your Access database and click on the Reports tab in the Database window.

Run-time error '424' (Object Required) in Access 2003/XP/2000/97

no image Question: In Access 2003/XP/2000/97, I'm using VBA code to set a value on another form and I keep getting a "Run-time error '424': Object Required" error. I can't seem to figure out why it won't work. The object that I'm referencing is valid and it should work. What am I doing wrong?

Trim function will not work in a report in Access 2003/XP/2000/97

no image Question: In Access 2003/XP/2000/97, I've created a report and I'm trying to use the trim function in a field on the report. But when I try to, the field shows up as #Error.
How can I get the trim function to work in a report?
Answer: To use the trim function in Access, there are 2 steps that you must perform.
Let's take a look at a report to demonstrate.
In the picture below, we've tried to use the trim function on the Category Name field and it is generating a #Error for each line.

How to fix a "Compile error.in query expression" Error in Access 2003/XP/2000/97

How to fix a "Compile error.in query expression" Error in Access 2003/XP/2000/97 Question: In Access 2003/XP/2000/97, I tried using the Left function in a query and I get the following error:
"Compile error.in query expression"
I've seen this function work in other Access databases. How come it does not work in mine?
Answer: This error can occur when there is a broken Reference in your Access database and you've tried to use one of the built-in Access functions such as Left, Instr, Len, Year, Mid, etc.

MS Access: Database variable "not defined" error in Access 2003/XP/2000/97

MS Access: Database variable "not defined" error in Access 2003/XP/2000/97 Question: I'm running an Access 2003/XP/2000/97 database with some VBA code in it.
Within the VBA code, a database object is declared as follows: