April 2009 - Posts
Highlights The ability to export reports to Excel has been added. Fixes for issues with the import data wizards, report printing and previewing, macros, Excel integration, and date filters. Updates to Access Developer Extensions and Access Runtime are
Read More...
Access MVP Bob Larson has released a utility that you can use to clear test data from your database. I’ll let Bob tell you about it: It is a “database reset tool” which is for anyone who has been developing a database and they’ve got test data in it and
Read More...
Mike Alexander (Excel MVP) is putting on an Excel and Access Integration workshop in Dallas May 18/19th 2009. The goal of this workshop is to help users explore all the functionality that exists when Excel and Access are brought together. We go through
Read More...
Access MVP Albert Kallal has developed a Ribbon class object that you can use to simplify modifying Ribbon commands at runtime. The office ribbon is an amazing new interface. The problem with the ribbon is that takes a lot of code to change the ribbon
Read More...
The Office Sustained Engineering team has announced the official ship date . Highlights for Access include: The ability to export reports to Excel has been added. Fixes for issues with the import data wizards, report printing and previewing, macros, Excel
Read More...
Reader Patrick Jackman of Vancouver, BC has submitted a useful “fit-and-finish” tip. Here is a simple tip that I use quite often in MsgBox prompts when the message involves reporting the results of a count. Function Pluralize(ByVal varCount As Variant,
Read More...
Sure, that sounds like the frustrated outburst of an overworked technical writer, but when you build Access applications for others to use, you're pretty much on the hook to write the Help for them. Last month, we featured the “ How to synchronize combo
Read More...
Posted by Chris Downs, writer, Access IW Content Team Here’s a great tip suggested by Clint Covington. Using an expression and a Rich Text text box, you can create a traffic light indicator in an Access form or report, as in the following illustrations:
Read More...
Tony Toews (Access MVP) recently released a helpful utility that helps you ensure that all controls in your database are the same width. This is helpful when you find a bug that clips data in a control and want to fix it in all instances where that control
Read More...
I’d like to take this opportunity to announce a new feature of the blog, which some of you might have noticed already. Our Content Publishing team has begun collecting “Power Tips” from members of the Access community, including the product team, Access
Read More...
The last couple of months we have been refining the Access 14 ribbons and working hard to polish features. One invaluable tool we have for making decisions is the Customer Experience Improvement Program . This database provides us anonymous statistics
Read More...
You can download a template for Access 2007 that demonstrates how to synchronize two combo boxes. For example, say you choose a category from one combo box, and you want a second combo box to only display products within that category. The template shows
Read More...
