Some great tips on table formatting. Joey Cherdarchuk has a nice posting on a very different table styling to the type that Microsoft prefers. Under the banner ‘Clear Off the Table’ he suggests getting rid of gridlines and colors to simplify the look of tables. In his example, Joey takes a
Access Archon Column #230 – Making Concatenated Strings from Linked Tables and Multi-valued Fields Access versions: 2007-2013 Level: Intermediate Introduction Back in 2001, I wrote an Access Archon article (#89, Flattening Linked Data) which showed how to create a string of concatenated data from values in a one-to-many linked table.
Access Archon Column #229 – Fixing Normalization Errors Access versions: 2002-2013 Level: Intermediate Introduction Sometimes when you take over an Access database created by an amateur (or at least, someone with a minimal understanding of normalization), you will find data such as employee names stored in a Text field in
An interesting font idea from Spain – handwriting of homeless people turned into fonts. HomelessFonts.org is a series of fonts based on the handwriting of homeless people. For example, here’s the Francisco font. There are five fonts at present with more promised. Priced per font at €19 Euros for individuals
You can get match results automatically in Outlook Once great thing about Outlook’s Internet Calendar feature is that it can be updated automatically. The 2014 World Cup (football/soccer) is a good example. As we’ve already explained, you can make a separate Outlook calendar with the match schedule for your time
How to get the World Cup schedule into Outlook automatically. The football/soccer World Cup is about to start with 64 matches being played over the next month. Here’s how to get a reliable schedule into your Outlook calendar quickly and easily. Outlook lets you import an Internet feed of calendar
Gpg4Win is one way to improve and expand Outlook’s poor encryption support. Google’s End-to-End got us thinking about how to improve Outlooks lame email encryption and make it ready for End-to-End. The End-To-End addin uses OpenPGP, an email encryption system not directly supported by Outlook but you can do it
Does pasting an image into Office take up more space than inserting it? Gary Z read our tip about pasting images into Office and asks: “I remember reading years ago that graphics are copied to the clipboard in BMP. Huge files. Then if paste HUGE increase in Word file size.
Google’s video call and conference service gets link to Outlook. Google Apps users can now make and schedule video calls from Outlook using a new add-in. The Hangouts Plugin for Microsoft Outlook adds two buttons to the ribbon for scheduled and immediate video calls. A video call name is added
How to change Word so it’s more to the Game of Thrones author’s liking. George R. R. Martin, author of the Game of Thrones series among other wonderful books* has revealed that he uses an old DOS program (WordStar 4) on a standalone computer to write. That’s great for him
To save you a lot of red squigglies when writing about Game of Thrones Office-Watch.com talked about the spell-check options in Word and how to turn them off to suit George R. R. Martin’s dislike of red squiggly lines. Another option is to have a specialist dictionary of terms that
Finding the location of the Office object model DLL Q: Frank H. writes: “I want to use the FileDialog object to create a browser for selecting a file, but it requires a reference to the Office object library, and I can’t find that library in the list of Microsoft objects.
Access: Disabling a Label control Q: I need to disable a Label control, for a consistent appearance with some other controls on a form. But this control doesn’t have an Enabled property. Is there some way I can do this? A: You can’t disable a Label control, but you can
Exporting Filtered Data to Excel Access versions: 2007 – 2013 Level: Intermediate In Access Archon #200 (Exporting Access Data to Excel), I showed how to export data to an Excel workbook, using various techniques. In this article, I expand on that theme, showing how to export filtered data from
Or survey gives results that suit those paying for the survey. It’s an old PR trick, put together some report or survey that will get lots of free publicity for the company that’s footing the bill. It’s easy copy for overworked journos so you can’t blame them for using them.
Why RE and FW are the best options for email subjects When you reply or forward a message your email program will add a prefix to the subject line. The question is – do you choose the standard ‘English’ prefixes RE: and FW: or your local equivalents? There’s plenty of
Outlook adds holidays from various countries but it’s not very clear or clever about it. Recently we’ve been looking at Outlooks Holiday support. We thought it would a simple matter of clicking ‘Add Holidays’ but instead we found an old-fashioned, unclear and poorly designed system that’s causes lots of hassles
Should Outlook be adding marketing holidays as well as real ones? The US Holidays list in Outlook 2013 adds some unexpected and non-holiday items to your calendar – the full list is below. There were some surprising entries in the list supplied by Microsoft. Administrative Professionals Day There’s no doubt
How to change the date format in Excel Online The default date format in Excel has always been a mystery to newcomers and its stranger in Excel Online (the new name for Excel Web Apps). To change the default date format for display and date entry for Excel Online, go
How to delete ‘duplicate’ holidays in Outlook. When you add holidays to Outlook, sometimes you can end up with duplicate entries because Outlook isn’t smart enough to detect simple duplications in the calendar. Here’s an example of triplication of holiday items in the Outlook Calendar. It’s easy to do given
Put Easter and other public holidays back into Outlook If you check your Outlook calendar for the coming weekend, you might not see Easter Monday marked for Monday 21 April, Good Friday marked for Friday 18 April 2014. Or maybe US Thanksgiving on 27 Nov 2014 isn’t listed? Why? Doesn’t Outlook
Outlook tricks you may not have considered for New, Reply, Reply All, Forward and Resend. New / Compose The simple and easy one first. Click on the New Email button to start a new message. At the very least fill in the TO, Subject and some message text then click
By Helen FeddemaAccess versions: 2007-2013Level: Intermediate The main menu of the sample database for Access Archon #212 (A New Style Main Menu) has selectors for filtering a report by CustomerID or OrderNo. But sometimes you might want to print a filtered report right from the current record of a form.
Which way is best? Share a document by email or cloud? There are two main ways to share a document that needs editing or proofreading. Send it via email and get a revised document back or post to a cloud service like OneDrive, Dropbox or SharePoint. But which is best?
