Results for:
Form

• Social media done easy

  13 Jun 2011

  If you think back to around Valentine's Day of this year, you might remember our post about AccessLove , a social-media-type Access web database that became very popular with Microsoft employees. As a result of that response, the creators of AccessLove decided to present a "how we did it" session to...
• Power Tip: Use the Form property when referencing subforms in your code

  23 May 2011

  Today's Power Tip is provided by Juan Soto. Form variables can make your code sizzle I love using form variables. They make my code faster and easier to read, and they also provide a great way to remote control another form without being on that form or having it be the focus. Another advantage is that...
• Power Tip: Automate an update query

  2 May 2011

  Power Tipster Justin Farrell has posted a new Access tip on his blog, showing how to create and execute an update query by using a form and a small amount of Visual Basic for Applications (VBA) code. After following his tip, you'll be able to update a large number of records just by opening a form, typing...
• Wrap text in Access

  15 Apr 2011

  How do you wrap text in Access? It's a question we hear quite frequently on Office.com. It may surprise you to learn that in most places where text is displayed in Access, text wrapping is on by default. The key is making sure there is enough room for the text to wrap. The process for doing that depends...
• Power Tip: Supercharge conditional formatting by using a bit of code

  6 Apr 2011

  Over the past few versions of Access, the product team has steadily added more conditional formatting functionality for forms and reports. For example, in Access 2010, you can add up to 50 conditional formatting rules for each object without having to write any Visual Basic for Applications (VBA) code...
• Power Tip: Integrate Silverlight into an Access database (part III)

  6 Mar 2011

  Software developer Derrick VanArnam and database administrator Russell Fox continue to experiment with using Silverlight in conjunction with the Web Browser Control that is included with Access 2010. Many of you have been following along on their blog , where you can view the previous two posts on this...
• 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...
• Use code to "undo" things in Access

  31 Jan 2011

  One of the more common tasks on a computer is to undo something you just did by mistake. At least, it's one of my more common tasks. CTRL+Z is my friend. But not everyone uses keyboard shortcuts - that's why there's an Undo button in the Microsoft Office user interface. Trouble is, sometimes folks just...
• Power Tip: Integrate Silverlight into an Access database (Part II)

  17 Dec 2010

  As you may remember from their previous post , software developer Derrick VanArnam and DBA Russell Fox have developed a way to integrate Silverlight into an Access database by using the Web Browser Control that is included with Access 2010. Since that first post, they have been working on ways to improve...
• Power Tip: Integrate Silverlight into an Access database

  17 Nov 2010

  Derrick VanArnam and Russell Fox have developed a sample Access database that shows how to integrate Silverlight into an Access database. The sample demonstrates interoperability between Access and a Silverlight Treeview control, but you can also use other Silverlight controls, such as the Treeview,...
• Power Tip: Scale Access Chart objects at runtime

  26 Aug 2010

  Today’s guest blogger is Peter De Baets of Peter’s Software , providing Microsoft Access tools to developers for over a decade including ShrinkerStretcher ,  KeyedAccess and many other products and free downloads. I've recently discovered an easy way to scale Access Chart objects at runtime to fit...
• 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...
• Power Tip: Change the default behavior of controls

  25 Mar 2010

  Today’s guest blogger is Nadia Szucs, president of N-Soft , a provider of IT consulting services to businesses of various sizes in the Greater Toronto Area (Canada). N-Soft specializes in custom Microsoft Office product solutions centered around Microsoft Access implementations. I would like to share...
• 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...
• 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...
• Add color formatting to columns in Combo Boxes and List Boxes

  17 Nov 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/ . As we all know, a List Box control has a Fore Color property. It sets the fore color for column values and headers simultaneously...
• Sorting a Listbox Using Command Buttons

  13 Nov 2009

  Today’s guest blogger is Daniel Lamarche. Daniel is the Training Director at ComboProjects , which specializes in providing custom training solutions in Microsoft Office products. I always thought it was cool to be able to sort a list by clicking the column heading once, for ascending order then once...
• Displaying Data From Related Tables on a Form

  6 Nov 2009

  Today's guest blogger is Access MVP Scott Diamond. Scott is the principal of Diamond Computing Associates and the author of Microsoft Office Access 2007 VBA . This is a very frequently discussed issue. But before I get into the methods, you need to understand one of the principles of relational databases...
• 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 .