Power Tip: Password protect your VBA project
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.
Refine results
Product
Audience
Publish date
-
-
Ready for widescreen? How to manage aspect ratios in PowerPoint (16:9 vs. 4:3)
Widescreen, with its 16:9 aspect ratio, is taking over video screens faster than Godzilla in a scale model city.
-
Solutions to Three Common Problems when Using VLOOKUP()
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. -
5 things you wanted to know about OneNote 2010
You’ve read so much about OneNote 2010 getting the Office ribbon interface, but you can’t find (or control) it.
-
Running a SQL Stored Procedure from Excel (No VBA)
In some organizations, the IT department wants all interaction with the server to be done through Stored Procedure. -
Download Access 2010 Runtime, Database Engine Redistributable and Source Code Control
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. -
Power Tip: Create an AutoNumber field that starts with a number greater than 1
Today’s guest blogger is Luke Chung, President and Founder of FMS, Inc. -
How to create, view, and share Word 2007 templates
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! For guidelines on how to create templates that are easy to use or that will print correctly, and for tips on using some […] -
Scatter charts with PowerPivot
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. -
Cross version compatibility between Access 2010 and Access 2007
Today’s guest writer is Lois Wang—PM for reports and version-to-version compatibility. -
New and Improved Solver
Thanks to Eric Patterson for putting together this post. -
Windows 7 Volume License and Trial Availability
Last month we made Windows 7 available to customers with Software Assurance and to MSDN and TechNet Subscribers.