Results for:
Data Macros

• 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...
• 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...
• 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...
• 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...