Re: Start and End Dates show error
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
Calculated controls typically show #Error when there is no data.
A simple way around that is to cancel the No Data event of the report, so it
doesn't open if there is no data.
Or, you can test the HasData property of the report, using IIf() in your
expression. For example, if the problem control currently thas this in its
ControlSource:
=Sum([Amount])
use:
=IIf([Report].[HasData], Sum([Amount]), Null)
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"CB61" <CB61@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:78295DBE-9617-43B2-AC5E-4CB6C18466F4@xxxxxxxxxxxxxxxx
I now have my start and end dates in my report but if there is no data
entered between the start and end date it shows error not the dates how do
I
always show the dates even if there is nothing in the detail of the report
thanks
.
Relevant Pages
- Re: select column name base on users choice
... definition at runtime so that its controls are bound to the selected columns. ... In fact you are going to have to amend the report definition anyway, ... But this will only store the query in a string, ...
(microsoft.public.access.queries) - Re: Microsoft has utterly failed with Access 2007
... Access 2003 already included grouped controls. ... if I have a typical report with a line of details ... property sheet opening ... In other words again the keyboard choices and general design of access 2007 ...
(microsoft.public.access.modulesdaovba) - Re: multiple subform images per main search form record
... Thanks for pointing me to the links to the tutorial and to the report code. ... I have added the textbox controls ImageID1 through ImageID5 on the main ... In the subform itself, you can process a double-click event on each ... enlarged image and filter it analgous to how you filter the popup form ...
(microsoft.public.access.formscoding) - Re: Bug in Access 2002 Reports
... from within the Detail Section format event ... This will give the report a feeling of being "to scale", when you look at it you can see there are smaller, larger or equal intervals. ... Access will format the section but it will remember the last placement of the controls. ...
(microsoft.public.access.reports) - Re: Dynamically change subreport?
... Then I click a command button on this main form, and that fires off a report, which is based on a query which refers back to the customer combo box on the form. ... That report has two subreports, whose record sources are queries which also refer back to controls on the original form, including the customer. ...
(microsoft.public.access.gettingstarted) |
|
