Hi,
I have an ACCDE file which contains forms, VBA and tables used to manage data in the calling front end. The ACCDE forms manage changes to the data in the ACCDE tables and works fine.
However one of the tables contains a log table of actions taken and is updated by calling an insert function located in the ACCDE and when called from the front end db for some reason fails with the message 'The expression After Update you entered as the event property setting produced the following error: The setting you entered isn't valid for this property'. It doesn't fail if the ACCDE is opened and called from there.
The code I am using is:
SqlStr="INSERT INTO....
codedb.execute SqlStr
Can anyone suggest what I am doing wrong?
Many thanks
I have an ACCDE file which contains forms, VBA and tables used to manage data in the calling front end. The ACCDE forms manage changes to the data in the ACCDE tables and works fine.
However one of the tables contains a log table of actions taken and is updated by calling an insert function located in the ACCDE and when called from the front end db for some reason fails with the message 'The expression After Update you entered as the event property setting produced the following error: The setting you entered isn't valid for this property'. It doesn't fail if the ACCDE is opened and called from there.
The code I am using is:
SqlStr="INSERT INTO....
codedb.execute SqlStr
Can anyone suggest what I am doing wrong?
Many thanks