locked
Procedure Code not executing in Access runtime RRS feed

  • Question

  • I am just a hobby programmer. I tried the following:
    Wanted to create an application for invoicing. Created tables: - Invoice &
    Items& set the relation. Created a form including a subform to enter invoice details. & a report to show the actual invoice. A switchboard containing Enter - View - Exit (Total - 3) options.
    The form is having some minimum coding - When amount gets focus, it
    automatically displays results of (Rate * Quantity) in the amount column.
    After entering one line of Item (SrNo.1) Msgbox asks if more to enter. If No.
    then control goes to subtotal on main form There also some event procedure.
    to display value of subtotal as sum of all amount & then to calculate (% of )
    Tax & to calculate Total etc.etc.
    The whole logic works fine in Access 2007. But If I take it to other computer
    where only Runtime is installed, then, everything except the code works (i.e.
    I do not get amount / subtotal / tax / total calculated) It shows the form /
    report perfectly.
    I have set 'd:\My Document' as trusted location in my Access (on the computer having Full version of Access as well the computer where I am using Access runtime) . And on 2nd comp
    the file is kept in the same location.
    Being a very small & single user application, I have not split the Master &
    data   / Fornt & back end.
    Any Idea why this problem comes? any solution to it?
    Thanks.

    Saturday, April 23, 2011 11:45 AM

Answers