Results for:
VBA code

• Display real-time information with the ControlTip Property

  28 Nov 2011

  Today's Power Tip is provided by Juan Soto, Microsoft Access MVP and an expert on Access with SQL Server. Using ControlTipText property to display real time information The ControlTipText property is usually associated with providing static information, usually a helpful tip for the user - for example...
• UtterAccess Wiki adds libraries for class modules and APIs

  27 May 2011

  The folks at UtterAccess have added two new libraries to their Wiki Main Page : The Class Library has sample class modules and demonstration applications that illustrate how to use the classes. The Class Library is a good place to start if you are just beginning to program Visual Basic for Applications...
• 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: Managing Access Add-ins with a SurfaceController

  20 May 2011

  Extending Microsoft Access solutions with managed code has traditionally been a challenge. Visual Studio Shared Add-ins have been available for some time; however, managing the details of releasing Access.exe after closing an Access application has been a challenge. Office Add-in .NET developer Derrick...
• 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...
• 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: 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: Add Sparkline-like graphs to Access reports

  10 Feb 2011

  Today's Power Tip is contributed by Philippe Bonnardell, an Access developer and contributor to the French Access forum Developpez.net . He was inspired by the new Sparkline feature of Microsoft Excel, which enables you to create tiny graphs that summarize data across many cells. Philippe worked up some...
• 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...
• Enhance the quality of your VBA code

  30 Sep 2010

  Today’s guest blogger is Access MVP Thomas Möller, an Access MVP since 2007, and an avid developer of Add-Ins to enhance Access and the VBA Editor. Check out his website at http://www.team-moeller.de/en/ . When coding, it's easy to make small mistakes. Usually these types of mistakes have no direct effect;...
• Power Tip: Use explicit objects when referring to Excel in code

  16 Sep 2010

  Today’s Power Tip comes from Bob Larson of BTAB Development . Bob is a former Access MVP (2008-2009, 2009-2010), and offers a host of tips and code snippets on his site. When you use code to refer to Excel (and other programs as well) you need to be careful not to use any code that does not refer...
• 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: Password protect your VBA project

  28 Jun 2010

  A question came in recently regarding whether you can password protect just the VBA code for an Access database, but not the rest of the database. The answer is yes! Here’s how to do it: In Access, press ALT+F11 to open the VBA editor. On the Tools menu, select <Database Name> Properties … On the...