If you need to create a filter string for filtering by a person’s name, or a city name, you may run into this error: This is because single quotes are used as the delimiter for Text strings, and there is a single quote in the city name. To get around
Microsoft makes a ‘one stop’ page for the latest Office update details. Figuring out what are the latest updates for Microsoft Office isn’t easy which is why we’re delighted to see Update center for Office, Office servers, and related products from Microsoft. It’s been a long time coming but as Sam
Plenty of free ebooks about Office 2013, Office 2010, Office 365 and more. Microsoft has released another 130 free ebooks for anyone to download. It includes titles about Windows 8, Office 2013, Office 2010 and Office 365. A list of the Office related titles with links is below. Free ebooks
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
Google’s End-to-End secure email tool is a great idea – will it force Microsoft to improve Outlook? Google has announced an upcoming tool ‘End to End‘ which promises a way to send and receive encrypted emails from within a Chrome browser using web-based email systems (apparently not just Gmail). That
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.
A quicker way to do some regular tasks in Outlook. Quick Steps is that big block in the middle of the Outlook 2010 and 2013 Home tab Quick Steps let you customize and combine Outlook functions into a single click without resorting to VBA. The defaults are meant to be
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.
Group calling returns to the Skype ‘free’ list. Good news for Skype lovers, group calling has returned to the list of free features. You can now add group calling to our list of Skype hidden extras Group calling is having three or more people on the same video/audio call. Microsoft
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
A better way to view your email in Outlook 2010 and Outlook 2013 Outlook Conversation view is a different way to arrange your email. It groups messages with (usually) the same subject together making it easier to follow an email thread. Conversations also makes better use of valuable screen real
Like almost any web site, we use technologies like cookies to store and/or access device information. We aim to keep that to a minimum. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions. We apologize for this box but it's legally required in some regions.
Functional
Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.