"Ninety day e-mail deletion policies address the growing burden and IT cost of corporate e-mail stores, but not the legal requirements for e-mail lifecycle management. In the end, the increasing costs of e-mail storage pale in comparison to the risk and cost of businesses not paying attention to electronic records compliance and e-discovery." by Lynn Haber for October 3,2006 for Symantec
Small businesses we have advised do not have the resources to comply with this law. Most of them have never experienced litigation and have no idea of how to comply with a discovery request. Failure to comply can be very serious and expensive.
Paper documents are easy. Put them in a box and throw them in the closet for seven years. Electronic data is not so easy for a company without an IT department.
We wrote this program for clients using Outlook© 2007 on desktop computers without Microsoft Exchange Server. The program was installed on each computer and run periodically. We accessed their network monthly and merged and compressed all the databases into one and saved it to an outside server.
If you can click a button with a mouse, you can run this program. It will do all the work for you.
Give it a try http://www.smallbsystems.com/sbs/OutlookUtility.htm
d64c251e-b08e-46d9-a994-fda447e9fda0|0|.0
The example I am using is an estimate which has a footer with Installation, Tax, Total of Estimate and Deposit. Many of the estimates do not have Installation or Taxes. The problem is how to print the footer without showing the items not in the estimate.
This code in the designer will set the control text to blank if there is no value returned from the data source:
=IIf([TxtSalesTaxToString]>0,[TxtSalesTaxToString]*[QuoteTotal],"")
The problem is that this blank control will print on the report as an empty line so to complete the solution you need to move the visible controls up and move the blank controls to a empty spot on the report footer otherwise the blank controls will over print the controls you just moved. The last issue is that the Microsoft© Access report, by default, uses a twips as it's unit of measure. "Twip" is a unit of measurement equal to 1/20th of a printers point. There are 1440 twips to and inch, 567 twips to a centimeter.
The following is my solution to this problem if you a using Microsoft Access 2007©. If you are using 2000 or 2003 you have to make two modifications. First, the position must be in a variable of type LONG. For some reason, the "top" position does not accept a literal. Second, put the code in the format section to the section the controls are in. (i.e. ReportFooter_format ). I used DIM v72,v490,v900, v2000 as LONG.
TIP: Put your controls where you want them in design mode and then add msgbox(me!control.top) for each control to get exact position.
0a2819ee-b755-4ff1-89a2-ab15c0df992a|0|.0