how to auto-print if data is on report after each sort?

=?Utf-8?B?U3RldmU=?=

Guest

Posts: n/a

29th Oct 2007

I have a macro that runs on an Excell database that sorts the data according
by the designated "resource" and prints the page. . Certain machine resources
do not have any data associated with them. I would like for the macro to
distinguish between those that have data associated with them and therefore
print page and the ones that don't not to print the page. Machine "resources"
that have data associated with them vary from day to day.
Hopefully, someone has had similiar needs.
Thanks
Steve McFarland
(E-Mail Removed)

« find and copy rows based on dates in two columns | ComboBox font color »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto Detect Data, Auto Print Data, Auto Erase Data Loop	Gamma's and Ruiter's	Microsoft Excel Programming	8	14th Sep 2011 01:40 PM
Auto Send A report to specific print and print tray	neenmarie	Microsoft Access Reports	3	17th Dec 2008 04:03 PM
Excel 2007 - Print Macro with Auto Sort?	=?Utf-8?B?R2F2aW4=?=	Microsoft Excel Programming	0	17th May 2007 09:26 AM
Do not want data to auto sort	=?Utf-8?B?Um9k?=	Microsoft Access Database Table Design	17	11th Aug 2005 10:15 AM
Report loads fine with all data displayed. Print report and data is missing just an empty shell	Alex Richards	Microsoft Access Reports	0	5th Jan 2004 11:57 AM