Monday, December 29, 2008

Access Report Margin Problem

While using Access 2003 to create a report to print on 4" x 6" labels on my SATO GL 408e label printer, I ran across some very strange problems with margins.

I had created a custom paper size in the print driver on my print server (called custom stock in SATO lingo) and things seemed to be OK as I could see the new paper size in Access. The problems started when I tried to adjust the report margins to use as much of my label real estate as possible. The margins I set for top, left, and right would "stick" but the bottom margin kept resetting itself to 20.02 mm each time I left the page setup form. This was resulting in a large amount of unusable space at the bottom of each label.

Access 2007 was showing the exact same behaviour. Strangely, Word 2007 was not showing this behaviour and would allow me to select the custom paper size and print on the entire label. It seemed to be an issue related to Access.



After some banging of heads on walls, we stumbled across a setting in the print driver that solved the problem. On the "Printer Settings" tab the bottom section is titled "Override Application Default Settings". The field within is called "Always use drivers settings" and this needed to be set to true. I have no idea why this fixed the issue but it did and I am documenting in case this is of help to someone else!

Wednesday, December 10, 2008

Favicon for OWA on Exchange 2007

A minor thing but I wanted to use a favicon for our new Exchange Server 2007 Outlook Web Access site (also known as OWA or Outlook Anywhere). It was significantly harder to find the answer to this one than I expected . . . eventually, the secret was found on this developer forum posting. The (slightly modified) answer:

This is done by modifying the asp file for the logon page.

Locate the logon.aspx file. This is usually in ExchangeServer\ClientAccess\Owa\auth

Place the following under the *SECOND* <> tag:
< rel="SHORTCUT ICON" href="favicon.ico">

Note1: You need to remove the space I inserted after the initial "< ". I did this as Blogger interprets the HTML and messes up this post!

Note2: You can change the text between the TITLE tags under the *second* HEAD tag to whatever name you want to call your site. I did this too. Very nice.

Sunday, December 07, 2008

bug.gd - Error Search and Collaboration

"This site helps you search for errors that other people have encountered. Someone's bound to have run into your error before, right?"

There's also a Firefox extension with this description:
Search the world's database of error solutions and the web simultaneously. Later, provide your solutions to help the next poor soul.

The goal: No human should work on an error that has already been solved.

Free Online File Conversion

Zamzar allows you to upload a file and convert it from one format to another. The list of supported file types is quite lengthy.

Free Online Storage

Sometimes it's convenient to have a web-based option to deposit large files. This can facilitate the transfer of files that are too large to e-mail, etc.

4Shared - 5 GB of space, private or shared, max. 100MB, files deleted after 30 days

DropBoks - 1 GB, simple site, no sharing yet

Openomy - 1 GB free, can share via links

Box.net - 1 GB free, can share, max. 25MB

DropBox - Installed app, sychs, 2 GB free

RapidShare - no frills, max. storage space=?, max 300MB, files deleted after 30 days

YouSendIt - max. storage space=?, max 100MB

Live Spaces / Mesh?

Tuesday, December 02, 2008

Open Additional Mailboxes - Exchange 2007

An excellent blog posting describing may useful Exchange Management Shell "one-liners":
http://msexchangeteam.com/archive/2006/09/05/428833.aspx

To grant full mailbox access permission:
Add-MailboxPermission [MAILBOX] -AccessRights FullAccess -user jcross