Results for:
Macro

• Data Macro Aliases and the Where Condition Demystified

  11 Mar 2010

  Whenever I debug a data macro , one of the most common mistakes I find is misusing aliases, especially in the Where Condition of a ForEachRecord or LookupRecord data block.  This blog post is an attempt to demystify this area.  Hopefully, by the time you are done reading this you will have...
• Write expressions faster with fewer errors

  11 Aug 2009

  The Expression Builder sports new features and simpler UI in Access 2010. You will spend less effort thinking about syntax and available functions/properties because IntelliSense features provide all the information you need as you type. Expression Builder The first thing you’ll notice about the dialog...
• Set query parameters with macros

  5 Aug 2009

  Last week we blogged about changes to the new macro designer . I promised to write about IntelliSense but the first draft was lost in an unfortunate hard drive crash. I thought this is a good time to tell you about changes to the macro designer that encourage good design through better support of parameters...
• Meet the Access 2010 macro designer

  28 Jul 2009

  Today’s guest contributors are Kerry Westphal, Chris Downs, Krunal Sheth, James Rivera, and Michael Tucker—from the macro designer feature crew. The Macro Designer is a revamped editor that allows you to automate repetitive tasks; wire together forms and reports to create productive UI; and...
• 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...
• Kiosk Forms

  28 Apr 2008

  One of my favorite tricks with forms in Access has always been what I call a kiosk form. A kiosk form is a form that takes up the entire screen and is one that you might find in a store or shopping center displaying information. For example, a real estate kiosk might display homes for sale in the area...
• New Access 2007 Articles on Office Online

  13 Aug 2007

  Thanks to Jeff Conrad on the Access test team for this: Office Online now has published four articles with material pulled from the Microsoft Office Access 2007 Inside Out book. This enormous book, published by Microsoft Press, is co-authored by Access MVP John L. Viescas and recent Microsoft hire Jeff...
• Report View

  13 Jun 2006

  The last regular post was on Sorting and Grouping in Reports , and that followed a post about Sort & Filter in Forms . This time, we'll go into the new Report View, which provides interactive reports at view time and so improves on the old Print Preview view, which was static. The goal of this feature...
• Overview of Access 12

  7 Nov 2005

  I've had a series of posts talking about the guts of Access 12, but haven't really talked about the gestalt of the product yet. It’s time to fix that. There are 3 key goals for Access 12. First, dramatically expand the number of people who are successful using Access by making it much easier to build...
• Security followup

  1 Nov 2005

  This is a consolidated post covering the main things that came up about security. Again sorry for the delay on getting this out. Also note the post has links to the pictures rather than in-place thumbnails. I'll get them moved to a better home where I can reference them directly tomorrow. I took away...