Need help in creating macro

Discussion in 'Access Macros' started by Igneshwara reddy, May 12, 2010.

  1. I am trying to build a macro for an answer sheet in such a way that, it
    performs the below functions when I click on the “SUBMIT†. The sheet
    contains two tabs. Firs tab is questions along with the answer options; like

    Question # Answer

    1 Yes
    2 Yes
    3 No
    4 No
    5 Yes
    6 Yes
    7 No
    8 Yes
    9 Yes
    10 Yes

    It should prompt for the USER ID in the question paper sheet

    The answers should be copied to the second tab and have to be pasted in the
    sheet (the data will be in columns and it has to be transposed to rows) along
    with the user ID

    Ex: USERID Answers from 1 – 10

    The same sheet will be used by several people and it has to be shared. Each
    time the user clicks on submit button, the USER ID and the answers from 1 –
    10 have to be passed in a single row in the second tab and then the answers
    have to be validated with the master sheet which would be in the third tab.

    Note: The number of questions may change from time to time and has to be
    compatible to adjust with the numbers.

    In two columns, I would name as total marks and Percentage. It should
    calculate the score and also the percentage and should show up immediately
    after clicking on the SUBMIT button and also have to be stored in the path I
    mention it.

    Kindly let me know how I can do this.
    Igneshwara reddy, May 12, 2010
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.