Report to show message if no information is available.
Posted by admin on 25 Sep 2008 at 10:28 PM
$5.00
Is there a way on a report to have an unbound textbox in the report footer to show if the report comes out with no information (when it gives you the # Error when it does not bring back any information). Or say no permits issued for the period, for the unbound textbox to recognize that and say "No Permits Issued for this Period". I know what it means but other people will call and say there is a problem with the reports.
Any suggestions greatly appreciated.
Thanks
Any suggestions greatly appreciated.
Thanks
Accepted Answer:
| Answer provided by admin on 25 Sep 2008 at 10:28 PM I would do it differently. I would use code like the following BEFORE I run the report. |
| Rating: * * * * * Awarded: $5.00 |
Ask a Question
Most Recent Questions
Most Recent Answers
Home Page
Login
Register
Information Technology
Programming Languages
Database
- Microsoft Access
- MySQL
- Oracle
- PostGreSQL
- SQL Server
- Visual FoxPro
Graphic Design
Operating Platforms
Hardware and Networking
Math and Science
Biology and Geology
Math and Statistics
Chemistry
Physics
Engineering

Are you an information
Most Recent Questions
Most Recent Answers
Home Page
Login
Register
Information Technology
Software, Hardware, Design
Programming LanguagesDatabase
- Microsoft Access
- MySQL
- Oracle
- PostGreSQL
- SQL Server
- Visual FoxPro
Graphic Design
Operating Platforms
Hardware and Networking
Math and Science
Homework Help
Biology and GeologyMath and Statistics
Chemistry
Physics
Engineering
Are you an information
technology or
math/science expert?
You can earn money by
providing answers to questions
at AnswerArchive.com.
Learn How