You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
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 beta testing, I was most excited about the new Data Macros (table triggers) in Access 2010. At the time I had trouble getting them to work but I attributed that to my lack of understanding. Now that the public release version of Access 2010 is available, I'm looking more closely at Data Macros and while I'm still excited, I'm only a little less confused about how to implement them. "I had wanted to write a comprehensive article about how to build Data Macros but no longer think I'm qualified to do so. Instead, I'll settle with demonstrating how I replicated a SQL Server table trigger I currently use into Access 2010 and explain some of the tricks along the way."
"During beta testing, I was most excited about the new Data Macros (table triggers) in Access 2010. At the time I had trouble getting them to work but I attributed that to my lack of understanding. Now that the public release version of Access 2010 is available, I'm looking more closely at Data Macros and while I'm still excited, I'm only a little less confused about how to implement them.
"I had wanted to write a comprehensive article about how to build Data Macros but no longer think I'm qualified to do so. Instead, I'll settle with demonstrating how I replicated a SQL Server table trigger I currently use into Access 2010 and explain some of the tricks along the way."
Read the full article here.
Danny J. Lesandrini holds Microsoft Certifications in Access, Visual Basic and SQL Server and has been programming with Microsoft development tools since 1995. Danny maintains a web site with free code samples at http://www.lesandrini.com/datafast/Articles/.
Thanks to Garry Robinson with vb123.com for the heads-up!
Comments: (2) Collapse
Very interesting
Thanks to all how participate
If you haven't already read it, this post may help with understanding data macros: blogs.msdn.com/.../data-macro-aliases-and-the-where-condition-demystified.aspx
Comments: (loading) Collapse