Browse by Tags
All Tags »
User Interface (RSS)
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
Read More...
Today's guest blogger is Michael Merlin, Lead Software Developer at Electronic Communities . I recently wasted an hour trying to set a field's Back Color property to the hex code generated by the color picker. I figured it out after some searching, but
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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,
Read More...
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
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...
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...
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...
If you've tried to create a Ribbon customization that included one of the built-in controls in Access you've probably seen that you can use the Customize page in the Access Options dialog to get the names of groups and controls. You can also download
Read More...
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.
Read More...