Results for:
Macros

• Not all equals signs are created equal

  2 May 2011

  If you've ever played the guessing game about where to put (or where not to put) an equals sign in an Access macro, this post is for you. The choice depends on whether you're dealing with an expression or a string, and getting it right is especially important if you plan to publish your database to Access...
• Streamline reporting on recurring data imports

  26 Apr 2011

  Do you often have to summarize large data sets that have been extracted from your corporate database? Access can be very helpful when you need to work with a huge stream of data. We've published a new article that shows you how to make the data easier to import, analyze, and summarize in reports, even...
• Macros search form

  21 Apr 2010

  Today’s guest writer is Kerry Westphal—our resident macro expert. A common feature in well-designed applications is giving users the ability to quickly focus on the data they care about. A search or filter form allows users to specify criteria to limit the records returned. This also enhances performance...
• 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...
• Access 2010: data macros to create aggregates

  2 Mar 2010

  Access aggregate queries provide a popular and powerful way to keep track of totals and summarize all the data in a table. Data Macros introduce a new way to keep track of these types of totals traditionally done in aggregate queries or populated in reports. Using the calc and store model, you can store...
• Composite keys in Web databases through data macros

  18 Feb 2010

  A composite key consists of more than one field in an index. They are often used to ensure uniqueness across fields in a record. You can use unique multiple field indexes to define a set of columns that uniquely identify a row so as to prevent users from entering in the same record twice. Composite keys...
• Access 2010 data macros (similar to triggers)

  13 Aug 2009

  Last week we outlined improvements to the Access 2010 macro designer , parameter support , and IntelliSense . These improvements build upon Access 2007 macro improvements of macro sandbox, embedded macros, TempVars, debugging, and support for error handling. The natural next step in macros is to provide...