This article describes several more variations of combo boxes, making them even more useful. Linked Combo Boxes You can use a set of linked combo boxes to filter a list, making it easier to get at the specific item you want to select. As an example, in the sample database
A regular combo box that gives you a choice of an item from a list (usually displaying items from a query or table) is very useful, but sometimes you need something more. This article describes several ways to expand the utility of a combo box. Hard-Coded List Combo Box When
Back in 2002 I wrote an Access Archon article dealing with reference issues, among them the problem of certain references being upgraded when a database is opened in a higher version of Access, but not downgraded when it is again opened in a lower version. You might think that over
A private April 2018 Gartner report confirms what Office-Watch.com has been saying for years. Microsoft is forcing customers away from perpetual licence/one-off software purchases and into software rental like Office 365. As reported by Gregg Keizer at Computerworld, Microsoft will continue ‘encouraging’ customer to annual fees by limiting access to
While North Korea’s leader, Kim Jong Un, was busy in Singapore, his government hackers were busy with new malware called TypeFrame and delivered by, you guessed it, a Microsoft Word document. Typeframe has eleven different elements bundled with a Word document. As usual, the hackers send the document and try
The ASUS Zenbook Pro series comes with a snazzy touchpad which doubles as an extension toolbar for Microsoft Office. Source: ASUS Instead of a blank touchpad, it’s a small high-res touchscreen that can display icons or even full videos (play Lawrence of Arabia on a tiny, tiny screen!). For Microsoft
The news that Microsoft is adding Javascript support to Excel is important for developers and regular Excel user, but also a security concern. Javascript is a programming language that’s used on many web pages to provide the fast interaction we’re used to. Javascript is able to get data from external
Here’s how to convert the Last Trade time in Excel’s Stock data type into an Excel date/time that’s usable in other parts of Excel. UPDATE: near the end of September 2018, the Last Trade Time date format changed to an Excel serial date. No conversion or text parsing necessary. So
Microsoft has announced that the community support forums for Office 2013 and Office 2010 are ending next month, July 2018. The Community Support Forum are online forums where Microsoft staff and volunteers answer questions from Microsoft customers. From July 2018 Microsoft won’t be responding to queries in these forums: Office
Office 2011 for Mac is just one of many programs that won’t work at all on the upcoming MacOS release ‘Mojave’. That’s not a surprise for anyone who follows Apple’s policy announcements. Many years ago, Apple warned that they’d eventually stop supporting 32-bit programs with 64-bit applications becoming the required
Microsoft has announced that a perpetual licence version of Office for Mac will be released later this year. Office 2019 for Mac will come out alongside Office 2019 for Windows. Both are for non-subscriber / perpetual licence customers only. Anyone with Office 365 ‘subscription’ doesn’t need to bother with these
For the first time in a decade, Microsoft is making substantial changes to the Office ribbon interface. But not to worry, the changes don’t appear to be enough to put anyone off Word, Excel, PowerPoint or Outlook. The existing ribbon is retained, that’s an important point that’s not emphasized enough
Modern Excel can grab information from multiple files in a single folder. Just open the worksheet, refresh the query and it’s up to date! This article is a condensed version of just one chapter in Real Time Excel – the new 2nd edition has a lot more detail and example
Criminal have found another way to (mis)use Microsoft Office and infect computers using the latest ‘zero-day’ hack. You may know that Adobe’s Flash was a popular add-in for web pages to display multi-media content. But Flash was very insecure and unstable so it’s been mostly replaced with other secure systems.
As usual, Microsoft has released non-security updates and bug fixes for Office 2016 and Office 2013 on the first Tuesday of the month. A few caught our eye: Late last year, Microsoft was caught out leaving a horribly vulnerable Equation Editor in Office for 17 years. A new patch restores
Two Indian banks clamped down use of unlicensed Microsoft Office, leaving staff to use calculators or open-source alternative spreadsheets. Mid-Day.com reported that Bank of India and Saraswat Bank had some licenses for Microsoft Office but not enough for all the computers the bank had allocated to staff. Branches were instructed
A recent news story about the Australian airline, Qantas, caught our eye because of the email signature block. “We work flexibility at Qantas. I’m sending this message at a time that suits me. Please feel comfortable know that I don’t expect you to read, respond to or action it outside
Both Windows and Office send an astonishing amount of data from your computer to Microsoft. Here’s how to see what’s being sent. The Diagnostic Data Viewer shows, as it happens, what your computer is sending to Microsoft. The tool does NOT give you the choice to not send your private
Later this year, you’ll be able to buy an Office 365 annual ‘subscription direct from the App Store on a Mac. Buying through the App Store will be a bad move for any Mac users. That was one of the lesser noticed announcements at Apple’s WWDC 2018 conference. The whole App
Office Watch reader, John Hoffmann has some more detail on variable fonts, supported in Windows 10 and Windows 11 Variable fonts are a single package that includes many variations (Light, Heavy etc), instead of having separate font files for each variant. That takes up less disk space (important on tablet
It’s time again to put the mighty brains and resources of Microsoft against the best and brightest of American youth. Yet again, the kids put Microsoft Word to shame. Each year, Office-Watch.com get the word lists from the finals of the US Scripps National Spelling Bee and runs them through
An overdue and very welcome addition to OneDrive for Office 365 customers is password protected sharing links. Until now, you could send a link to a OneDrive stored file or folder but there was no control over who used that link. If the link ‘escaped’ to other people, they could
Microsoft has extended their OneDrive Files Restore feature to all Office 365 customers, not just their business users. It’s a simple way to recover files that have been lost, in particular if you’ve been caught in a ransomware attack. Ransomware will encrypt all the files on your computer and network
The increasing popularity of Office 365 hosting has a downside; targeting of the platform by hackers. Just like Microsoft Office software, the wide deployment of Office 365 means it becomes a large target for baddies to try infiltrating. They are succeeding. A report from Beazley Breach Response Services suggests that
