The two procedures will let you easily clear up redundant Word documents, and alphabetize lists of declarations. Access versions: 2007-2013 Level: Intermediate Introduction The two procedures described in this article will let you easily clear up redundant Word documents, and alphabetize lists of declarations. When working on the 3rd edition
Microsoft confirms Office across devices, including Android. There has been plenty of unquestioning press reports from the Microsoft Worldwide Partner Conference 2014. Statistics and commitments are quoted without much consideration for their worth. The good news is another commitment to Microsoft Office ‘cross platform’ meaning, for the moment, not just
Q: Susan H. writes that she has some standard code that creates a Word document and puts some Access data into it, using VBA Automation code. But sometimes the Word window is hidden behind other windows, either the Access window itself or some other window. A: This is a long-standing
Q: Lou writes that sometimes when he clicks on a label in Design view, in order to change the caption, it displays with a dark back color, which is disconcerting. The Label control’s BackStyle property is set to Transparent, so it shouldn’t be displaying as a color. How can this
Word: how to find the character code used for a particular letter or symbols. Last week we talked about the Unicode v7.0 symbols and how to use symbols in Word. With over 100,000 characters in the Unicode specification, it’s important to know the character code number for the symbol you
A funny example of how you can’t trust the spelling and grammar checks in Word. We laughed at this sign, seen in a Tesco’s supermarket in the UK. Guess what – according to Word 2013 that entire document has no grammar mistakes at all! Even ‘incontinence’ doesn’t get a contextual
Microsoft delivers 1,000GB for Office 365 users. As we mentioned last month, Microsoft decided to greatly increase the OneDrive storage available for Office 365 subscribers. The base storage for paid customers is now 1 Terabyte. That change has now been implemented. If you’re an Office 365 subscriber, go to OneDrive
What is Delve and what does it mean for Microsoft Office? At the recent Microsoft conference there was mention of Microsoft Delve. But what the ?^%$ is ‘Delve’? It’s an enhanced search tool for your documents and online info. Not just standard Office documents but also videos, audio, links to
How can you get the new Unicode symbols in Office documents? There’s plenty of new symbols included in the Unicode 7.0 standard, here’s how to get them into your Office documents. Most fonts do NOT have all the Unicode characters, after all, there are over 133,000 of them. There are
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
Back in Access 2003, you could easily change the font name and size for a datasheet form by clicking the square in the upper-left corner of the datasheet (in datasheet view), and selecting the font and size from the selectors on the Formatting toolbar, or by selecting Font from the
Unicode adds more characters to an already large list. Unicode has added another 2,834 new characters in the Unicode 7.0 specification, mostly support for 23 new scripts. That takes the total to a whopping 113,021 characters! But we’ll have to wait for these new characters to appear automatically in Office,
Miracast gives you a wireless external screen for PowerPoint and a lot more. Miracast is a clever trick that lets you wirelessly connect some Windows 8.1 portable computers, Android and other devices to any HDMI capable monitor or TV screen. All you need is a Miracast dongle available online for
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
A guide to getting more life and value from your printer. The Guardian has a nice little guide to maintaining an inkjet printer and saving money. We’ve never had good experiences with recycled ink or toner cartridges and have always found their quality to be poor. But others swear by
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
A smaller Surface machine isn’t coming soon but Office for Android surely is. The rumor mill is running hot about the Surface Mini (comatose, possibly deceased) and Microsoft Office for Android (in gestation). Microsoft did have a plan for a smaller version of their Surface computers but it was apparently
Join the list of testers for future versions of Microsoft Office. Microsoft has opened their waiting list for people to test future versions of Microsoft Office. Businesses and individuals can apply here http://prereleaseprograms-public.sharepoint.com/ There’s no guarantee you’ll be selected nor which version of Office you’ll be offered (Office for Windows,
Do the latest Microsoft data encryption promises mean much? Microsoft has announced more encryption services for customers but it’s more ‘papering over the cracks’ than a real effort to protect customer’s data. Microsoft has made some vague changes to protect the transmission of your emails and documents, but nothing to
Finding web pages some people don’t want you to see. The European Court of Justice has decided that citizens have a ‘right to be forgotten’ when there are web pages that are “inaccurate, inadequate, irrelevant or excessive”. The results of that ruling are now being seen with Google removing links
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
Microsoft doesn’t see the main problem as they apologizes & explain the Lync and Exchange outages. In a blog post, Microsoft has explained what happened in the cloud service breakdowns earlier this week but exposes their lack of understanding for customers’ needs with cloud services. The break in Exchange Server
Updates to Office Mix – a new way to make PowerPoint interactive. A while ago we told you about Office Mix, Microsoft’s way to put a presentation online with quizzes and other interactive elements. Mix has been updated with a wider range of examples via a Public Gallery It’s nice
QuickOffice is no more but Google improves MS Office document support Google has announced improvements to their direct support for Microsoft Office document formats as part of a reshuffle of their apps. The Google apps for viewing and editing documents will be updated to include editing of Microsoft Office document
