A question came in recently regarding whether you can password protect just the VBA code for an Access database, but not the rest of the database. The answer is yes! Here’s how to do it: In Access, press ALT+F11 to open the VBA editor.
Widescreen, with its 16:9 aspect ratio, is taking over video screens faster than Godzilla in a scale model city. And that’s a good thing, with PowerPoint. As the name implies, widescreen brings wider, more beautiful images onto your TV and computer screens. So why does your PowerPoint presentation suddenly look terrible?
This article assumes a basic familiarity with the VLOOKUP() function, one of the easiest ways to lookup up a key value in one worksheet or block of data and return a related piece of information from a second worksheet or block of data.
You’ve read so much about OneNote 2010 getting the Office ribbon interface, but you can’t find (or control) it. What’s up? There seems to be no way to browse, apply, or download OneNote templates now, even though you could before. How come?
Today’s template is an Employment application for Word 2007 or later. You can download this template now, or get more free templates or free clip art & photos from Office.com. Have you designed a useful template? Share your own templates here. You never know when we might feature yours!
In some organizations, the IT department wants all interaction with the server to be done through Stored Procedure. This adds a level of risk management and makes the DBAs feel better.
Download Access 2010 Runtime, Access Database Engine Redistributable (office connectivity components) 2010 and Source Code Control Add-in for Access 2010 today! Access Runtime 2010 Available in both 32-bit and 64-bit, you can download the Runtime here. It is currently offered in 13 languages and more languages will be offered at a later time.
After several months of beta testing, Microsoft Outlook Hotmail Connector 14.0 has officially been released as a replacement for Outlook Connector 12. Outlook Hotmail Connector 14.0 is compatible with Outlook 2003, 2007, and 2010. Why use the Outlook Hotmail Connector? If you have been using Outlook Connector 12.
Today’s guest blogger is Luke Chung, President and Founder of FMS, Inc. Luke has written and presented a wide range of topics related to Access over the years. In addition to their many Access related products, FMS offers a wealth of great Access papers, tips, and video on their site.
Many of you ask how to create templates, plus how to apply them to another document or share them with other people, so here are the instructions you need to get started!
Rob over at http://powerpivotpro.com has a interesting post on scatter charts and PowerPivot: At right is a list of all chart types in Excel. But not all of them are supported as PivotCharts.
We recently published an energy calculator template from one of our content partners in Canada, Microsoft Home Magazine. During that process, they let us know about a board game activity that they recently published on their site, and we love it!