Results for:
Power Tips

• Roll-your-own “traffic light” icon set

  16 Apr 2009

  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: First, add a text box to the form or report, and...
• Changes coming to the Access blog

  14 Apr 2009

  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 MVPs, user group members, and other Access enthusiasts...
• Template demonstrates how to synchronize combo boxes

  2 Apr 2009

  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 you how to make it happen. On the Getting Started...
• Accessing external data using the IN clause

  27 Mar 2009

  Someone sent us a question the other day about one of my favorite dark corners in Access and we thought it might be interesting to dive into this area a little. Microsoft Access SQL supports two uses of the IN keyword. The most commonly used case is as part of the WHERE clause of a SQL statement to provide...
• Review of ribbon design tool

  27 Mar 2009

  Access MVP Garry Robinson and editor of vb123.com recently wrote a nice review article on IBDE Ribbon Creator . You all should find it enlightening. http://www.databasejournal.com/features/msaccess/article.php/3803996/Making-Your-Own-Access-2007-Ribbon.htm
• Constructing Readable Time Elapsed Strings – MSDN article

  25 Mar 2009

  There is a new article on MSDN that has some useful code samples. This was based off a post by Kerry Westphal on the Access blog a while back. Here is the intro: Many Web 2.0 applications are designed to make it easy to visualize complex data. I found myself recently challenged with this task while working...
• Data bars in an Access query

  18 Mar 2009

  Mike Alexander (Excel MVP) recently sent me a very cool trick that I hadn’t seen before. He uses some simple hackery and trickery to get data bars in a query. This is the first installment of a long series about how Access can be used to create cool dashboards. You can see more free training videos from...
• Video demo: Mail and email merge with Word

  5 Nov 2008

  Demo: Merge Access data with Word is now live on Office Online. I think this is a great short overview of a some what complicated process. Enjoy!
• Video demo of conditional formatting in reports

  30 Oct 2008

  The video Watch this: Highlight values on a report by using conditional formatting is now live on Office Online. Enjoy! Edited: October 31, 2008--updated link with correct URL.
• Article: Create a tab form with video demo

  15 Aug 2008

  The article Create a tabbed form , and the companion sudden demo Watch this: Create a tabbed form ,  are now live on Office Online.
• Two new Allen Browne (MVP) articles

  11 Aug 2008

  The famous Allen Browne has published two new articles on Office Online. Validation rules Want to ensure that users enter valid data? Validation rules might be the answer. This article describes when validation rules are appropriate, and provides examples of commonly-used validation rules. Relationships...
• Article: Learn to think relationally

  25 Jul 2008

  Learn to think relationally by Allen Browne is now available. Great advice for our non-developer audience. “As your database application grows, do you find yourself adding multiple Yes/No columns to existing tables? If so, you might not be using the relational features of Access to their fullest. This...
• Article: Top 10 reasons to use Access with Excel

  8 Jul 2008

  Mark Gillis, who has written extensively for Access and Excel, recently published, Top 10 reasons to use Access with Excel . In this article, there are also five “sudden demos” that work together to build a Customer database solution based originally on an Excel workbook. Here’s the table of contents...
• Community Clips about Access from Office Labs

  26 Jun 2008

  This is your chance to become famous! The Office Labs folks have released a cool site for help video. They have a free video recorder that makes the process really simple. There are already 15 Access videos available. Go make a quick demo and share it with the community!
• Article update: Create a form that contains a subform

  26 Jun 2008

  The revised topic Create a form that contains a subform (a one to many form) is now live on Office Online. The topic has been revised to include suggestions from the community, new graphics, rewritten procedures, and two new video demos.
• Designing Applications

  23 Jun 2008

  So while most people spend their free time with family, sports or relaxing; I like to make Access Databases. One of things I heard over and over during my years building apps for customers at M7 was; Access database are so ugly!!!! They look like windows 3.1 Design is an art and for myself I know function...
• Demo: Set the relationship between 2 tables

  6 Jun 2008

  The video demo, Demo: Set the relationship between 2 tables , is live on Office Online. This seven minute video gives enough information so that the user can intelligently select these options: I think this video is a great resource for anyone new to Access.
• Free training courses for Access 2007 and Access 2003

  3 Jun 2008

  Today’s guest writer is Colin Wilcox from the Access content team. Hi, all: I’m Colin, and I write online training courses for Access. These are self-paced courses that you take in your browser. You can start or stop them at any time, and most courses have hands-on practice sessions. Even better, they...
• Dot or Bang?

  30 May 2008

  Here's a question that comes up from time to time. The other day, someone internally asked about the difference between using a dot "." vs. a bang "!" for control references in a form in VBA. In other words, given a form - Form1, with a control - Control1, what are the differences...
• Three new video demos on Office Online

  29 May 2008

  People seem to really like the Access 2007 demos we have been doing. The team has recently published three more on Office Online: Watch this: Add or remove controls from a layout Watch this: Create a form that contains a subdatasheet Watch this: Create a subform by dragging one form onto another form...