Results 1 to 3 of 3
  1. #1
    elios115 is offline Novice
    Windows 7 Access 2003
    Join Date
    Jul 2008
    Posts
    5

    user formula setup

    hello guys im just a newbie in access so hope someone will help me!
    suppose i have A, B and C as input box for a user.
    and X, Y and Z as output box for the user
    if i want to let the user setup his own formula with A, B and C to get the results in X, Y and Z how to do it?
    example.


    the user wants
    X = A+B *C
    Y= A*B/C
    Z=C-A*C
    so how will allow him to setup any formula in a form?
    Thank you

  2. #2
    Join Date
    Jul 2008
    Location
    Alexandria, Egypt.
    Posts
    38

    RE: user formula setup

    Dear Elios115,

    You can try the following steps:
    1- Create table with 4 fields ID,A,B and C as numbers (table1):

    2- Create query in design view (query1):



    In each time you entered the values of A,B and C the query will give you the resulte of your formulas.

    You can see the result on the form:
    3- Create form based on Query1 using the wizard:



    4- Creat form based on Table1 using the wizard:



    5- Edit the design of the Table1 form by clicking on design view button.
    6- Use toolbox bar to insert subform and choose form Query1:



    Save the form and open it in form view.
    Enter values for A, B and C.
    when you press tab after entering C ... the calculated values will appear in X,Y and Z.



    I hope the previous steps answer your question and I'm waiting your reply.

    Thanks

    Ahmed

  3. #3
    elios115 is offline Novice
    Windows 7 Access 2003
    Join Date
    Jul 2008
    Posts
    5
    dear mr ahmad

    i think u didnt understand wat i need.
    anyway thx for ur trial to help me.
    i need it in a way dat the user can set up the formula, any formula he wants with a, b and c.
    so he needs to input + or - or * or / calculation with a b and c the way he want it.
    thank you

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

Similar Threads

  1. Complex Date Comm/Amt Formula
    By JLongo in forum Programming
    Replies: 0
    Last Post: 11-21-2008, 10:24 AM
  2. Please help with table setup
    By newhelpplease in forum Access
    Replies: 0
    Last Post: 10-14-2007, 01:15 PM
  3. formula on report??
    By dike969 in forum Access
    Replies: 0
    Last Post: 03-05-2007, 01:58 AM
  4. Max formula in Access
    By mohsin74 in forum Programming
    Replies: 2
    Last Post: 12-26-2006, 07:21 AM
  5. form formula to combine two fields
    By InvGrp in forum Forms
    Replies: 1
    Last Post: 10-20-2006, 12:10 PM

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