Small b Systems blog

Information for small businesses

Outlook© Email Database released

clock January 14, 2010 12:00 by author Administrator

"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

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5


How to reposition Microsoft© Access report controls at print time

clock January 10, 2010 04:03 by author Administrator

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.

Screen capture of MS Access Report Footer positioning code.

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5


About the author

My name is Paul Steinberg and I am the owner of Small b Systems. I am 71 years old and have been working with computers for 32 years. I have been designing business and manufacturing systems for 49 years.

A system is a collection of orgainized tasks which guide an operation to a predictable conclusion. Unlike an individuals's routine, a system can be used by anyone.

I have worked on Wall Street, in military electronics, retailing, professional photography, manufacturing, barter and woodworking. I have designed systems in all of these industries.

Sign in