Results for:
Power Tips

• 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: Improve the security of database connections

  8 Apr 2011

  This post about making ODBC connections more secure is provided by Access MVP Ben Clothier. Now and then, we come to a point where we decide to upsize an Access database to a server-based RDBMS. The reasons for upsizing can vary, but a common theme is security. With a server-based RDBMS, we have more...
• 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...
• 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...
• Power Tip: Experiment with dynamic event callbacks

  17 Jan 2011

  Access Power Tipster Joel Graff has been refining his Composite Control Object Model, which he first blogged about last August . Joel has now created a CodePlex site where you can download and experiment with his demo, and he has posted the details on his blog . Here's an excerpt: "...some of the most...
• Power Tip: Leveraging data macros in Access 2010

  15 Oct 2010

  Danny Lesandrini, IT Director at Pharmatech Oncology Inc. , has a great article on the Database Journal site that shows a real-world example of using an Access 2010 data macro to solve a common data entry problem. He also includes a downloadable database for your reference. Here's an excerpt: "During...
• Power Tip: Maximize the use of TempVars in Access 2007 and 2010

  27 Sep 2010

  Today’s tip is provided by Juan Soto, Senior Access Developer at AccessExperts.net . His blog is at AccessExperts.net/blog and you can subscribe to it by clicking here . Juan is a frequent speaker at Access user groups nationwide and was a participant in the last Access developers kitchen for Access...
• Power Tip: Speed Up Microsoft Access and Visual SourceSafe Integration

  20 Sep 2010

  Luke Chung of FMS, Inc. has written an article about how to avoid performance slowdowns when adding lots of Access objects to Visual SourceSafe. Here’s an excerpt: Using Microsoft Visual SourceSafe (VSS) with Microsoft Access for system development is great for tracking old versions, maintaining a professional...
• 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: Pin Access applications to the Windows 7 taskbar

  13 Sep 2010

  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. I like to be innovative and use new features from programs. Recently I updated...
• 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: Use dynamic event callbacks to simplify complicated applications

  10 Aug 2010

  Today’s guest blogger is Joel Graff, Operations Field Engineer with the Illinois Department of Transportation . Many of the Access projects I’ve developed have used VBA extensively, and the more I became involved in developing user interfaces, the more I saw a need to customize the behavior of the controls...
• Power Tip: Exclude data from a query by using a table

  22 Jul 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. If you have a long list of items to exclude from a query, and you don’t want to type a big IN statement in the query to...
• Power Tip: Navigate around a ‘Save as’ roadblock

  16 Jul 2010

  Today's guest blogger is Luke Chung, President and Founder of FMS, Inc. Luke 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 videos on their site. It seems so...
• Power Tip: Take advantage of Rich Text textboxes in Access

  7 Jul 2010

  Today’s Power Tip comes from Philippe Riondel of text2texte . Philippe is an English to French certified translator based in Québec. I am currently developing a terminology managing database for my main occupation, which is translation. The interface is mainly made of 2 parts, one for the...
• 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...