Unanswered: Replacing command DSum from Access desktop DB with Web Macro, Access 2010?
In my Access 2010 desktop database (DB) I have VBA code behind form "Purchase orders" which task is to calculate current stock of the item. It is set-up on AfterUpdate event of combobox and looks like this
Since I have moved one part of my Access 2010 desktop DB to Access 2010 Web App., first thing I have to do is "convert" above VBA code to Web Macro and I am stuck Does Web Macro supports DSum? I guess not, because I tried it all.. How can I turn my VBA code into Web Macro?
Any help is appreciated and many thanks in advance for prmopt replies.
I am not sure if I can use the sum in my example. example_db.zipI have prepared simple DB (in attachment) based on my first post. I am not sure where exactly I could start and how to achieve wanted result from step 3. (image bellow) using Web Macro?