Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2013
    Posts
    15

    Unanswered: Replacing command DSum from Access desktop DB with Web Macro, Access 2010?

    Hello,

    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

    DSum("[Entry]", "Q_StockEntry", "[ItemNumber] = " & [ItemNumber]) - DSum("[Exit]", "Q_StockExit", "[ItemNumber] = " & [ItemNumber])

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

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24
    Can you use a query that does the sum?

  3. #3
    Join Date
    Mar 2013
    Posts
    15

    Reply

    Quote Originally Posted by ranman256 View Post
    Can you use a query that does the sum?
    Hi ranman,

    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?

    Click image for larger version. 

Name:	explanation.jpg 
Views:	2 
Size:	90.4 KB 
ID:	16701

    Best regards.
    Adi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •