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 the last 16 years Microsoft […]
There is a way to make a shortcut or menu button to jump directly to the Find dialog box, as compared to the Navigation pane which is now the default for Ctrl + F. Thanks to all the Office Watch readers who sent in the tip including: Karen, Ron, Geoff, Calvin and Alice. Also thanks […]
You can use Find combined with your own actions and easily switch between the Find and editing. That’s great for situations where a simple Replace command isn’t enough. Because Find results show up in the left-hand pane or dialog box, you can move between find results, change the text in or around each result before […]
Following on from our introduction ‘Find in Word’ here’s some Word Find tricks that you might find useful. Select and Find If you select some text in a document then use the Ctrl + F shortcut, Word will find other instances of the selection in the current document. Find blank lines Finding and removing blank […]
We’ve all seen the standard Find/Replace in Word, either the ‘new’ pane or the older dialog box. Like so much else in Word, there’s a lot more available than the obvious features. Here’s a look at some of tricks. Press Ctrl + F to start a Find. In recent versions of Word, the Navigation pane […]
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 the Wikipedia article about Whaam! […]
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 tell-tale signs to look for […]
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 most international conflicts, have done, […]
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 or Office Mobile for iPhone, […]
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 main table), Description, and IDOrPhone. […]
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 little help, attributing the problem […]
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 extra charge. There will also […]
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. Office 365 Personal, Home, University […]
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 so, there’s occasions when it’s […]
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 then it will be a […]
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, each account attached to the […]
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, for example with PowerPoint for […]
Outlook has had a Categories feature for a long time … here’s how you can use it and why. Categories let you group Outlook items (emails, contacts, calendar and tasks) into broad topic areas or subjects … all without moving from their original folders. They can be subjects that a normal Outlook search could not […]
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 same text in each place […]
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 wider and creative ways. Any […]
