Results for:
User Interface

• Valentine's Day app brings out the love for Access

  25 Mar 2011

  In the weeks leading up to Valentine's Day 2011, three Access team members got together and created an Access web database that allowed users to post their plans and/or wishes for themselves and their loved ones on Valentine's Day. The team published the database to Access Services and then promoted...
• Power Tip: Search as you type in an Access form

  21 Feb 2011

  Today’s Power Tip comes from Brandon with OpenGate Software, offering Microsoft Access products for Access users of every experience level, including UI Builder , Designer , and Dashboard Builder for Microsoft Access. "Search-as-you-type" has become a pervasive feature of any modern user interface...
• Power Tip: Count the number of rows in a subform

  15 Apr 2010

  Today's guest blogger is Access MVP Garry Robinson, who offers the Smart Access collection of articles at http://www.vb123.com/kb . Here's a great tip from the Smart Access collection that I used recently. I needed the count of rows in a subform to display on the main form. It's surprisingly easy--all...
• Access 2010: Shared images

  10 Feb 2010

  Today’s guest writer is Ric Lewis--PM in charge of publishing to SharePoint, Web Services, and Shared Resources. Traditionally in Access, images have been bound to individual objects on a form or report. Then, if you wanted to change the image for a group of controls across multiple forms and reports...
• Power Tip: Making forms easier to use and maintain

  25 Jan 2010

  Reader Štefan Masič provides today's Power Tip. In today’s post I would like to share with you some tips about form design that I’m using consistently in all applications I develop. Maybe you can get some benefit from my approach to form design. As we all know, analysis and preparation of user needs...
• Dashboard graphics in forms and reports

  8 Jan 2010

  Mike Alexander, Excel MVP recently sent us a pointer to a blog post with some cool ideas to spice up your application with data visualizations . Here is a quick sample: Mike didn’t mention attachments in his post but the attachment control works really well for storing images. I have a similar technique...
• Manage large groups of controls by using the Tag property

  5 Jan 2010

  Today's guest blogger is Access MVP Garry Robinson, who offers the Smart Access collection of articles at http://www.vb123.com/kb . In Smart Access Answers , Doug Steele was asked “What if I have a number of different controls–say, text boxes, labels, and check boxes and I want to make them invisible...
• Use late binding to improve the performance of tabbed forms

  9 Dec 2009

  Luke Chung, President and Founder of FMS, Inc., 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. If you use the Tab Control to pack a lot of...
• A better way to reference tab control pages

  5 Nov 2009

  In VBA, a common way to refer to the pages of a tab control is to use the Value property. However, Luke Chung, President of FMS Inc., recommends using the PageIndex property instead. Click here to find out why! Send your Power Tips to Mike and Chris at accpower@microsoft.com .
• Expand only the subdatasheets you want

  21 Oct 2009

  Today's guest blogger is Pavlo Pedan of ARGO Business Corp. He has 15 years of experience with Access and has a great site of tips  at http://sites.google.com/site/msaccesscode/ . If you have a form that contains subdatasheets, you can use the following VBA command to expand all of them: Forms!...
• "Convert" a TextBox to a ComboBox at a run-time

  14 Sep 2009

  Today's guest blogger is Pavlo Pedan of ARGO Business Corp. He has 15 years of experience with Access and has a great site of tips  at http://sites.google.com/site/msaccesscode/ . Some people do not like having ComboBoxes on a form because of drop-down buttons. Microsoft offers a solution here ...
• Use a validation rule instead of the Required property

  9 Sep 2009

  Reader Štefan Masič provides today's Power Tip. When you want to require users to enter a value in a field, a common technique is to set the Required property for that field to Yes (for example, tabPerson.Name.Required = Yes). However, when the user is then adding records to the table and neglects to...
• Cool Tool Tips: A Better Control Tip

  24 Aug 2009

  Tony D'Ambra of aadconsulting.com , maker of Access add-ins and switchboards, wanted to share his method for providing help to users when and where they need it. In Access, the functionality of tool tips has not changed since they were introduced in Access 95 ten years ago. In a free sample Access 2000...
• Create custom menus and shortcut menus by using macros

  18 Jun 2009

  About a month ago, we posted a Power Tip from Edwin Blancovitch about creating shortcut menus by using VBA . However, if for some reason you’re not interested in cracking open the Visual Basic Editor, there is a way to create shortcut menus (the menus that appear when you right-click an object) just...
• Creating Web 2.0 Visual Effects in Access

  17 Jun 2009

  Once of the most interesting trends in the web application space has been a refocus on user experience improvements. Often times Access gets a bad reputation for not keeping up with the times from a look and feel perspective. Our good friend Brandon from OpenGate Software created a great white paper...
• How to: Create a Shortcut Menu for a Form, Form Control, or Report

  21 May 2009

  Today’s guest blogger is Edwin Blancovitch. Edwin is president of Advanced Developers.net , creators of Easy Payroll , a software package to manage your human resources, payroll, scheduling, time and attendance needs. When you're designing a form or report, you may want to provide a method for...
• Showing hidden controls during development

  7 May 2009

  Today’s guest blogger is Michael Groh, co-author of the popular Access 2007 Bible . I often use hidden controls on Access forms and reports to hold intermediate values, temporary "flag" values, and the like. Because these controls are invisible at runtime, it's useful to set their colors to...
• Simplifying Ribbon Modification at Runtime

  27 Apr 2009

  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 at runtime. Solution: With my ribbon class you can...
• 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...
• 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...