Results 1 to 10 of 10
  1. #1
    Join Date
    Aug 2003
    Posts
    68

    Unanswered: Creating a Wizard like feel extract program

    I'm trying to create a program that will do several things:
    Have multiple questionaire forms answered by user..
    Save those answers in a table called WIZARD PROFILE TABLE.
    Discard those answers if they decide to stop the extraction.
    Extract content from table derived from questions on forms.

    The trouble I'm having is mainly around how to move from one form to another saving the Q answers to the Wizard Profile table...Really lost on how
    to do this one at all.
    jm

  2. #2
    Join Date
    Aug 2003
    Posts
    68

    NEED HELP!!! Please!

    Need a bit a help with this problem..
    thx
    jm

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    There's a bunch of ways you could do it, unbound controls and an update statement, bound controls and input parameters... all sorts of stuff.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  4. #4
    Join Date
    Aug 2003
    Posts
    68

    agreed

    How about bound controls... Since I do have them bound to the Wizard Profile table. But thats it... Any help would be great..
    jm

  5. #5
    Join Date
    Aug 2003
    Posts
    68

    I could send the DB

    I can send the DB if someone can help point me in the right direction..
    Again mainly, I'm not sure how to pass the recordnumber from form to form to making sure the same record is being updated by the same person for all forms answered.
    Thx
    jm

  6. #6
    Join Date
    Aug 2003
    Posts
    68

    Help Help

    Really need some help.. Can anyone give me guidance... about the application..
    jm

  7. #7
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    Okay you are just needing to know how to make another form open with that forms record id?

    JS
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

  8. #8
    Join Date
    Aug 2003
    Posts
    68

    Basically

    Ya, I think that would work.. That way as they answer questions they are filling in the table from form to form. At the end I'd like them to save or discard what they have done also.
    thx
    jm

  9. #9
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    I dont know about saving or discarding... except if at anytime they press cancel it just deletes the record with that primary key. I will leave that alone for now. Lets get your forms talking to each other first.

    Are you comfortable with VBA? (I have seen you helping other people so I will assume that you are).

    What type of form transfer methods are you using? (Click a 'Next' button and it opens the next form and closes the first?) The code for that method would be as follows...
    Code:
    Private Sub cmdNext_Click()
        On Error GoTo cmdNext_Err
    
        DoCmd.OpenForm "SecondFrmName"
        [Forms]![SecondFrmName]![SecondRecordID] = [Forms]![FirstFrmName]![FirstRecordID]
        DoCmd.Close acForm, "FirstFrmName"
    
    cmdNext_Exit:
        Exit Sub
    cmdNext_Err:
        MsgBox Err.Description
        Resume cmdNext_Exit
    End Sub
    Let me know how that works. I havent done much VBA recently. My company put that project on the back burner for a while but I am trying to stay current and learn more so let me know.

    JS
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

  10. #10
    Join Date
    Aug 2003
    Posts
    68
    Yes indeed am using Next. Can I send you the program and you take a peek.
    Needs some cleanup but it you should be able to get what I'm trying to do very easily..
    jm

Posting Permissions

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