By Helen Feddema Access versions: 2007-2013 Level: Intermediate Introduction Word has a sophisticated Table of Contents feature that automatically creates a table of contents from designated headings in a document. Access reports don’t have such a feature, but I managed to create one using VBA code, custom database properties and
On the TV show ‘The West Wing’ news stories the administration wanted the public to overlook were released on ‘Friday Trash Day‘. In the real world, the US National Security Agency (NSA) has another term for the same practice. The NSA calls it ‘Christmas Eve’. It was on the afternoon of
The Florida Center for Investigative Reporting has released the emails of Governor Jeb Bush during his tenure as Florida’s governor. That’s of interest to us since the information is available in its original Outlook data file form. Before anyone gets angry with us … we are not making any political
One of the automatically installed patches for Office causes a new bug! Ouch. The new bugs aren’t common but even so, they are embarrassing. You can find the details under the Knowledge Base article headed ““Cannot insert object” error in an ActiveX custom Office solution after you install the MS14-082
Slow, but surely, the online version of Microsoft Office gets better. Word online will never have everything that Word for Windows or Mac does, but it’s becoming more viable for occasional users and as a backup in case your usual software fails. It also adds some interesting features that’s aren’t
When you type or paste a web link into Office, it normally converts it into a web link automatically. But occasionally that feature doesn’t work right. We found one example when researching the famous artist Roy Lichtenstein and one of his best known works. Click on the image to see
A friend is expecting a parcel via Fedex and got the email shown below, so they wondered if it was really from the courier company or not. This particular email got past both the Gmail and Outlook spam filters. We thought it was a good example to use of the
John Harcourt-Rigg writes …. “Could you tell me why Microsoft do not offer a similar discount programme for users of Microsoft Office 365 that users receive in USA. That is a discount for: Serving Members, and retired Military Veterans Australian VETS have served side by side with USA veterans in
UPDATE: we’ve totally updated this article see How to get a refund of Office 365 With the release of the ‘free’ Office for iPhone/iPad apps with many editing features, there’s probably some unhappy Office 365 subscribers out there. If you bought Office 365 for the editing features in Office for iPad
We’ve already mentioned that the ‘free’ Office Mobile apps (for iPhone, iPad and soon Android) actually have some features that are only available to Office 365 subscribers … but what? The editing options available in the current apps is quite extensive and surprisingly generous. For most people, they’ll be able
Q: Arne Johnston writes that he has four phone number fields in a table, but that is not enough. How can he handle this better? A: For phone numbers, emails and other IDs, a separate linked table is best. I have one with just three fields: CompanyID (links to the
Access Archon Column #234 By Helen Feddema Access versions: 2007-2013 Level: Intermediate Introduction Sometimes, when working on an Access subform, you will get the “Field Cannot be Updated” error (no error number), generally when typing the first character into a new record: The Help topic for this error is of
Microsoft is having a good laugh having just fooled journalists and customers all over the world with their announcement of ‘free’ Office for iPad and iPhone. It’s not free at all. For as long as Office-Watch.com has existed (19 years now) we’ve known to closely read Microsoft announcements and press
As part of the Outlook for Mac release, Microsoft has indicated their Office for Mac plans. A new Office for Mac (Office 2015 for Mac?) will be released in the second half of 2015. Office 365 subscribers/renters will be able to switch to the new Office for Mac at no
Microsoft has released a new version of Outlook for Macintosh computers with new features but it’s not available to everyone. This Outlook is separate from Outlook 2011 that comes with Office 2011 for Mac. It’s called Outlook for Mac version 15 and is only available to Office 365 subscription/rental customers.
These days, Outlook Categories are saved within the PST data file. If you move the PST to a new computer, the categories will move too. Exchange Server saves categories with each user mailbox and they show up automatically when you login (even with Outlook Web Access). Backup and Restore Even
The Office rumor mill has been running hot this week. Office for Android Plenty of rumors that Office for Android is coming soon, possibly in early November. If that’s the case it can’t come soon enough for Office users. If Office for Android is as good as Office for iPad
Microsoft has really made Office 365 more compelling by raising their online OneDrive storage from 1 Terabyte to Unlimited for Office 365 subscribers. If you have Office 365 Personal, Home, University or Business account, the OneDrive storage limit will be effectively removed entirely. For Home subscribers, shared among several people,
An iOS 8 trap for iPad users who have an external video connection cable. Many people have a little plug-in for their iPad that lets them put the video on any HDMI display … like most monitors and TV sets. This is great for anyone who needs big screen support,
We’ve already looked at Microsoft Office document properties features. They are fully featured in Word and have limited availability in Excel so now we look at PowerPoint. PowerPoint has little document automation. Word users are often surprised to discover that even basic field codes don’t exist in PowerPoint. As a
We’ve already told you about document properties and how useful they are in Word. We also complained about the poor support for properties in Excel. You can add and edit document properties in worksheets much the same as in Word documents. Go to File | Info in Excel 2013 (Prepare
While delving into the details of Office document properties, we found some curious anomalies. They aren’t major but worth keeping in mind if you use document properties in Word documents. When you enter a document property it should just add the text and the same document property will show the
Microsoft Office has Ebola … meaning it’s in the supplied dictionaries for Word 2013, Word 2010 and Word 2007. As a proper noun, the disease name has a capital letter. Without it, Word marks it as a spelling error. The surname Pooley isn’t in the dictionary and, as we’ll see,
Document Properties is one of those long-standing parts of Office that is worth another look. It can be quite useful and not always in the ways that Microsoft intends. At first, document properties looks like a fixed and rigid feature with limited use. However it can be used in much
