I'm using Windows 7 with Access 2010 and Access 2013.
I use data macros to create a new record in an "Audit table" whenever a new record is inserted into a table in my database. One of the fields in this audit table is filled with the windows username of the person inserting a record in a table. This is done by calling a VBA function from the data macro.
I have a split database design: the VBA code sits in the front end with the forms that are used to enter data, the tables and data macros reside in the back end.
All of this works fine in Access 2013. However, when I try to use the same set up in Access 2010, I get the following error message in the USysApplication log table: Invalid text 'UserNameWindows' in data macro expression.
The 'UserNameWindows' in the error message is the name of the VBA function that I'm trying to call. Does anybody know if the syntax for calling VBA functions from data macros differs between Access 2010 and Access 2013? Or is it just not possible to call VBA functions from an Access 2010 data macro?
Any insights would be greatly appreciated!
I use data macros to create a new record in an "Audit table" whenever a new record is inserted into a table in my database. One of the fields in this audit table is filled with the windows username of the person inserting a record in a table. This is done by calling a VBA function from the data macro.
I have a split database design: the VBA code sits in the front end with the forms that are used to enter data, the tables and data macros reside in the back end.
All of this works fine in Access 2013. However, when I try to use the same set up in Access 2010, I get the following error message in the USysApplication log table: Invalid text 'UserNameWindows' in data macro expression.
The 'UserNameWindows' in the error message is the name of the VBA function that I'm trying to call. Does anybody know if the syntax for calling VBA functions from data macros differs between Access 2010 and Access 2013? Or is it just not possible to call VBA functions from an Access 2010 data macro?
Any insights would be greatly appreciated!
