Introduction Combo boxes are a handy way to select values for various purposes, such as filtering forms and reports. The row sources can be of three types; this article discusses how to select the appropriate type of row source query, and use them to open a filtered report. The Form
If you need to filter by a Text value, such as person’s name or a company name, you may run into this problem: An error caused by an apostrophe in a Text string This is because the apostrophe is a Text delimiter. The way I deal with this problem is
The Outlook preview pane isn’t just convenient, it’s a good front line defence against hackers and viruses. Here’s an in-depth look at a deceptively simple part of Outlook. The standard preview pane hasn’t changed a lot for many versions of Outlook. Microsoft now calls it a Reading Pane which recognizes
How can you put an obvious visual warning on the screen for file types you should be wary about? We’ve warned about opening old or potentially dangerous file types like .doc .xls or .rtf . There are options to totally block opening these files from Outlook. That can be frustrating
The latest issue of Private Eye (No. 1421 to 7 July 2016) notes that Microsoft UK is paying an amazingly low tax rate. We wondered how Office 365/2016 prices in the UK compare with those ‘across the pond’ in the USA? How much extra is Microsoft grabbing off UK consumers.
Starbucks and Microsoft have released a tool to help promote the famous coffee chain through Outlook. But there’s more limitations to the offer than the hype suggests. Starbucks for Outlook is promoted as for Outlook 2016, Outlook 2013 and Outlook.com but it’s more complicated than that. We’ll look at that
Office 2016: the real startup guide has been updated to include all the recent changes in Office 2016 for Windows. Office 2016: the real startup guide isn’t a single release, anyone who buys the ebook gets the free updates too. It’s a bit like the rolling updates to Office 2016 itself, but
Slide 10 of the Microsoft/LinkedIn investor presentation caught our eye: Source: Slide 10 of presentation with “Microsoft and LinkedIn Conference Call” 13 June 2016. Microsoft’s 2012 claim that a billion people use Office has now grown to 1.2 billion! We weren’t the only ones to point out how extreme that
Randall Stross has an interesting piece in The New York Times about the possible effects on Office of Microsoft’s latest purchase. He refers to a slide sent to Microsoft investors to explain the LinkedIn purchase: “A professional’s profile everywhere Today, there is no one source of truth for an individual
If you’re not careful, Military and Veterans can pay more than they need to Office 365. For many years, Microsoft has offered a ‘Military Appreciation‘ discount to qualifying members of the US and Canadian armed forces. It doesn’t get a lot of attention but Office-Watch.com has done its best to
Microsoft has released the June 2016 updates to Office for Windows (Office 365 subscribers only) – both security and other updates. The new features are things we covered many months ago but are now available to the public. Office 2016: the real startup guide has full coverage of all these
Here’s the complete list of June 2016 updates to Office 2016 for Windows. This is what Microsoft calls the ‘Deferred Channel’ that’s sent to all subscribers every four months. June 14, 2016 Version 1602 (Build 6741.2048) Access: Security updates This channel release contains security updates covered in the following security bulletins:
The Microsoft Support and Recovery Assistant for Office 365 sounds promising for anyone with Outlook troubles – but what does it actually do and for whom? Go to https://diagnostics.outlook.com/#/Download?env=Outlook to get about a 50MB download. It promises to “Support and Recovery Assistant works by running tests to figure out what’s
Office for Windows Mobile has some additional features now available in preview. If you’re in the Windows Insiders program, you can download v17.7070 or later from the Windows Store. Color selection is better with a wider range available including Recent, Theme and Standard colors. The More Colors option has a
Microsoft is adding to Office naming confusion by giving us THREE products they call ‘Office 2016’. First Office 2016 for Windows – the traditional desktop suite for Windows that most people think of when you say ‘Office’ or ‘Office for Windows’. Confusingly, Microsoft decided to also call the latest version
Microsoft has paid $26.5 billion cash for LinkedIn, does that mean some good news for Outlook users? $26.5 billion is a lot of money, even by Microsoft’s standards where mere millions are considered as petty cash or rounding errors. Maybe, just maybe, we’ll see LinkedIn return to Outlook? Outlook 2010
Microsoft’s Delve now has a Windows 10 app. You need a school or work Microsoft account to use Delve. Check out our article What is Delve? to find out more.
Though it’s probably no real surprise, a new report ranks Microsoft Office skills as highly desirable for any prospective employer. First, a note about the source of these ‘facts’ and who paid for the report. The report comes from IDC and is ‘sponsored’ by Microsoft. IDC makes that clear at
Microsoft has released ‘Office Online Server’ but what is it and should we care? Everyone can use the ‘Office Online’ services, Word, Excel, PowerPoint and OneNote which let you use basic versions of those programs in your browser. Even for regular Office software users, the Online versions are a handy
It’s that time of year again and Office-Watch.com has a little fun seeing how Microsoft Word’s dictionary compares to the winners of the Scripps (US) National Spelling Bee. Surprisingly, Word did better in 2016 than past years, despite the words being harder. Still, no chance of Word reaching the finals
The stream of updates (or feature ‘catch up’ depending on your point of view) continues with Office for Android getting the ‘Tell me’ help system that’s already in other incarnations of Office. The ‘Tell me’ icon is a lightbulb. Office for Android (Word, Excel and PowerPoint) has it on the
The Norwegian experiment of reading out Terms and Conditions got us wondering about how long the Microsoft Office Terms and Conditions really are. It’s a bit like asking ‘How long is a piece of string’? It depends on what you think is part of Office. There’s the initial software licence
It’s almost hard to believe it’s 2016 and yet Office for Mac customers still can’t rely on password compatibility with Office for Windows. In Office for Windows we’re used to making password protected documents with long passwords, up to 255 characters long if you’re enthusiastic. But Office 2016 for Mac
If you like The West Wing, you’ll probably enjoy http://thewestwingweekly.com/ a podcast that’s going per episode through the series. What makes it special is that the co-host is Joshua Malina, who joined the cast in later series as Will Bailey. He gives some insight into the making of TV from
