on no data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that prints transactions. if there are no transactions I
would like to print a report with a message that states No transactions. How
can this be done
 
Add a text box to your report header with a control source of:
=IIf([HasData]=0, "No Data To Print","")
 
Thank you

Duane Hookom said:
Add a text box to your report header with a control source of:
=IIf([HasData]=0, "No Data To Print","")

--
Duane Hookom
MS Access MVP
--

Kathy said:
I have a report that prints transactions. if there are no transactions I
would like to print a report with a message that states No transactions.
How
can this be done
 
The info worked fine but now I get #error in the detail for part number and
report total. Can you help me with this.

Duane Hookom said:
Add a text box to your report header with a control source of:
=IIf([HasData]=0, "No Data To Print","")

--
Duane Hookom
MS Access MVP
--

Kathy said:
I have a report that prints transactions. if there are no transactions I
would like to print a report with a message that states No transactions.
How
can this be done
 
I can't see your control sources, control names, conditions, or what you
have tried in order to troubleshoot this...

--
Duane Hookom
MS Access MVP


Kathy said:
The info worked fine but now I get #error in the detail for part number
and
report total. Can you help me with this.

Duane Hookom said:
Add a text box to your report header with a control source of:
=IIf([HasData]=0, "No Data To Print","")

--
Duane Hookom
MS Access MVP
--

Kathy said:
I have a report that prints transactions. if there are no transactions I
would like to print a report with a message that states No
transactions.
How
can this be done
 
I have a report that is created with a table.

The Control name is REPTOT, control source is a calulation is =Sum([Extended
Cost]). When there is no data the message appears "No Data" and in the
REPTOT field I get #error. I have tried every thing I know to get a zero to
print when there is no data.

Duane Hookom said:
I can't see your control sources, control names, conditions, or what you
have tried in order to troubleshoot this...

--
Duane Hookom
MS Access MVP


Kathy said:
The info worked fine but now I get #error in the detail for part number
and
report total. Can you help me with this.

Duane Hookom said:
Add a text box to your report header with a control source of:
=IIf([HasData]=0, "No Data To Print","")

--
Duane Hookom
MS Access MVP
--

I have a report that prints transactions. if there are no transactions I
would like to print a report with a message that states No
transactions.
How
can this be done
 
I am confused. How does a control with a control source of:
=Sum([Extended Cost])
cause a message "No Data" to appear?

Are you working with expression in a single main report with no subreport?
Does your question involve only one control or multiple controls?
What are the control properties and section:
Control Name
Control Section
Control Source
What do you expect to see?

--
Duane Hookom
MS Access MVP
--

Kathy said:
I have a report that is created with a table.

The Control name is REPTOT, control source is a calulation is
=Sum([Extended
Cost]). When there is no data the message appears "No Data" and in the
REPTOT field I get #error. I have tried every thing I know to get a zero
to
print when there is no data.

Duane Hookom said:
I can't see your control sources, control names, conditions, or what you
have tried in order to troubleshoot this...

--
Duane Hookom
MS Access MVP


Kathy said:
The info worked fine but now I get #error in the detail for part number
and
report total. Can you help me with this.

:

Add a text box to your report header with a control source of:
=IIf([HasData]=0, "No Data To Print","")

--
Duane Hookom
MS Access MVP
--

I have a report that prints transactions. if there are no
transactions I
would like to print a report with a message that states No
transactions.
How
can this be done
 
I know it is probably too late to be of any help here. But I just want to
say I am having the same problem Kathy had. My solution is pretty lame but
it's all I've come up with so far. I am using the text box method described
in earlier messages. I am placing the text box over where the error message
appears and I am using conditional formatting to make the box background
white if the cell equals "No Data To Print". This at least hides the error.

If anyone else searches for old responses like I do and has the same issue,
this may help a little.

Duane Hookom said:
I am confused. How does a control with a control source of:
=Sum([Extended Cost])
cause a message "No Data" to appear?

Are you working with expression in a single main report with no subreport?
Does your question involve only one control or multiple controls?
What are the control properties and section:
Control Name
Control Section
Control Source
What do you expect to see?

--
Duane Hookom
MS Access MVP
--

Kathy said:
I have a report that is created with a table.

The Control name is REPTOT, control source is a calulation is
=Sum([Extended
Cost]). When there is no data the message appears "No Data" and in the
REPTOT field I get #error. I have tried every thing I know to get a zero
to
print when there is no data.

Duane Hookom said:
I can't see your control sources, control names, conditions, or what you
have tried in order to troubleshoot this...

--
Duane Hookom
MS Access MVP


The info worked fine but now I get #error in the detail for part number
and
report total. Can you help me with this.

:

Add a text box to your report header with a control source of:
=IIf([HasData]=0, "No Data To Print","")

--
Duane Hookom
MS Access MVP
--

I have a report that prints transactions. if there are no
transactions I
would like to print a report with a message that states No
transactions.
How
can this be done
 
Back
Top