Results 1 to 2 of 2
  1. #1
    adi2011 is offline Novice
    Windows XP Access 2003
    Join Date
    May 2011
    Posts
    19

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

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Normally, a macro recognizes domain aggregate functions. They can also be used in queries and textboxes.

    However, seems that web form does not allow domain aggregates. http://www.utteraccess.com/forum/Dlo...-t2014699.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 08-21-2013, 07:02 AM
  2. Replies: 1
    Last Post: 08-14-2013, 06:29 PM
  3. Replies: 3
    Last Post: 06-19-2013, 04:45 PM
  4. Replies: 2
    Last Post: 03-28-2013, 06:02 PM
  5. Replies: 5
    Last Post: 01-01-2013, 09:15 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums