I assume this will be easy for you guys! (1 Viewer)

[piedpiper]

Attached is a saved down version. thanks guys - This will be really cool once completed.

If we can have a summary of their responses before the end, so if they made a mistake to can go back and correct it - that would be cool... does table queries do this, and as per the code above can it be tied to "ID" field?

 

[piedpiper]

Forget about the reporting, they can select wich record they want to edit and make changes from there. thanks so much for your help!

 

[boblarson]

Well, let me give you the bad news first. Your design is not normalized. It is nowhere near normalized. That will make getting meaningful data out of your database a huge pain in the @$$. And you cannot add, or delete, questions easily should that happen.

I'll see what I can do about the summary but essentially the design really shouldn't go any further until you normalize. And, you really needn't be doing all of those forms. You could just use a tab control instead of opening up, and creating, form after form after form for one question.

And anytime you have more than one answer possible, it should be a junction table for storing multiple data for one record and then used as a subform on the form.

So the main thrust of the info here is that you have a design which really isn't going to be all that easy to work with and it will be hard as hell to get meaningful data out and compare with other records. I hated to have to tell you this, after you have been working so hard on things, but I need to share the truth.

Read this on proper design and normalization.

 

[piedpiper]

Well, let me give you the bad news first. Your design is not normalized. It is nowhere near normalized. That will make getting meaningful data out of your database a huge pain in the @$$. And you cannot add, or delete, questions easily should that happen.

I'll see what I can do about the summary but essentially the design really shouldn't go any further until you normalize. And, you really needn't be doing all of those forms. You could just use a tab control instead of opening up, and creating, form after form after form for one question.

And anytime you have more than one answer possible, it should be a junction table for storing multiple data for one record and then used as a subform on the form.

So the main thrust of the info here is that you have a design which really isn't going to be all that easy to work with and it will be hard as hell to get meaningful data out and compare with other records. I hated to have to tell you this, after you have been working so hard on things, but I need to share the truth.

Read this on proper design and normalization.

Thank you so much... The design was requested this way, not that I would know any better way... what we are going to do is export the data into SPSS and run data tables from there, where SPSS can take the string of data and do meaningful things with it.

As for changing the forms and edits to options, every time I need to work on it, I get a perk. So not too bad having the owner dependent on me?
I do not need a reporting tool now. As I figured something out, just wanted to make sure inputers made a mistake with data entry that they can go back and make corrections?

Thank you for your time!!!! Everyone has been a great help...

The last piece of the puzzle is that I will need to figure out how to auto populate fields using the <5 = simple (value of 1) >5 = complex (value of 2) – I will have more detail on this soon, as I’m waiting for the owner to give me specifics.

Thanks Again... will post soon!

 

[piedpiper]

If you are using the same table for each then it SHOULD be:

Private Sub Command1_Click()
Select Case Me.Frame77
   Case 1
      DoCmd.OpenForm "s6_Form6", acNormal, ,"[COLOR=red][ID]=" & Me!ID[/COLOR]
   Case 2
      DoCmd.OpenForm "s9_Form9", acNormal, ,[COLOR=red]"[ID]=" & Me!ID[/COLOR]
End Select
End Sub

Oh no - I don't know what I did...the skips no longer works... can you or some one else look at the file and see what is wrong?

 

[boblarson]

No events have been assigned to the buttons.

 

[piedpiper]

No events have been assigned to the buttons.

Ok how do I do that?

 

[piedpiper]

Ok how do I do that?

I can't figure it out?!?!

 

[piedpiper]

No events have been assigned to the buttons.

Ok weirdest thing... I run the wizard to produce the radio buttons and it completes but when the buttons are on the form there is no event? - What is going on...also this cause the skip pattern to not work...please help?

 

[piedpiper]

No events have been assigned to the buttons.

I'm lost again... worked before and now it does not... I really don't know what I did to break it...can you please take a look...I'm so close from finishing! thank you! thank you! thank you!

 

[boblarson]

I looked. There was no code behind any of the events for the buttons (except the last I looked there was for the form that we had been talking about).

So, add the correct code just like we did on the other. You have to include the ID field on each of the forms and then open the next using the same code (with the correct form name) as we did with the other click event.

 

[piedpiper]

I looked. There was no code behind any of the events for the buttons (except the last I looked there was for the form that we had been talking about).

So, add the correct code just like we did on the other. You have to include the ID field on each of the forms and then open the next using the same code (with the correct form name) as we did with the other click event.

Ahhh yeah right... man - what can I do, I need the buttons (not radios) to skip.

Frame has 2 radios (p0_Splash2) - Special and Stock quote = this will determine how to skip

Next form
p0_Splash3 - has 3 buttons.

Step1
Step2
Step3

If in p0_splash2 they select "Special" then in form p0_Splash3 they skip
Step1 skip to = p1_Form2a_Special_Order
Step 2 skip to p2_Form1_Special Order
Step 3 - don't worry it works as intended

If in p0_Splash2 they select "Stock" then in form p0_Splash3 they skip
Step1 skip to = p1_Form1_Stock_Order
Step 2 skip to p2_Form1_Stock_Order
Step 3 - don't worry it works as intended


I got a feeling that the previous skip is not going to work anymore?

Can you help? thanks so much!

 

[piedpiper]

I looked. There was no code behind any of the events for the buttons (except the last I looked there was for the form that we had been talking about).

So, add the correct code just like we did on the other. You have to include the ID field on each of the forms and then open the next using the same code (with the correct form name) as we did with the other click event.

I hope your still around...can't do this without you.

 

[boblarson]

I hope your still around...can't do this without you.

Come on, you can do it. It isn't rocket science. You already have the code I gave you for the one form, correct? So go into the event for the next buttons and copy the code I gave you:

DoCmd.OpenForm "s6_Form6", acNormal, ,"[ID]=" & Me!ID

and paste it into the event and change the form name which is supposed to open. Do all of those and we can deal with the "BACK" buttons later.

 

[piedpiper]

Come on, you can do it. It isn't rocket science. You already have the code I gave you for the one form, correct? So go into the event for the next buttons and copy the code I gave you:

DoCmd.OpenForm "s6_Form6", acNormal, ,"[ID]=" & Me!ID

and paste it into the event and change the form name which is supposed to open. Do all of those and we can deal with the "BACK" buttons later.

Oh yes, I know how to do it... but the situation has changed... the skip pattern is more elaborate now. I introduce 3 buttons 2 of which skip differently.

I spent all day redesigning the database, as I've been getting a lot of constructive criticism from the help here and I've tried to improve my design. At the same time keep what the customer (brother) wants...

Have you read this?

Ahhh yeah right... man - what can I do, I need the buttons (not radios) to skip.

Frame has 2 radios (p0_Splash2) - Special and Stock quote = this will determine how to skip

Next form

p0_Splash3 - has 3 buttons.
Step1
Step2
Step3

If in p0_splash2 they select "Special" then in form p0_Splash3 they skip
Step1 skip to = p1_Form2a_Special_Order
Step 2 skips to p2_Form1_Special Order
Step 3 - don't worry it works as intended

If in p0_Splash2 they select "Stock" then in form p0_Splash3 they skip
Step1 skip to = p1_Form1_Stock_Order
Step 2 skips to p2_Form1_Stock_Order
Step 3 - don't worry it works as intended

Thank you again...
for your patience and help!!!

 

[piedpiper]

Come on, you can do it. It isn't rocket science. You already have the code I gave you for the one form, correct? So go into the event for the next buttons and copy the code I gave you:

DoCmd.OpenForm "s6_Form6", acNormal, ,"[ID]=" & Me!ID

and paste it into the event and change the form name which is supposed to open. Do all of those and we can deal with the "BACK" buttons later.

Ok on splash 3 - in event for the button "Step1" I put the following code:

Private Sub Command95_Click()

Select Case Me.Frame88
Case 1
DoCmd.OpenForm "p1_Form2a_Special_Order", acNormal, , "[ID]=" & Me!ID
Case 2
DoCmd.OpenForm "p1_Form1_Stock_Order", acNormal, , "[ID]=" & Me!ID
End Select
DoCmd.Close acForm, Me.Name, acSaveNo
End Sub

Ok on splash 3 - in event for the button "Step2" I put the following code:

Private Sub Command88_Click()
Select Case Me.Frame88
Case 1
DoCmd.OpenForm "p2_Form1_Special Order", acNormal, , "[ID]=" & Me!ID
Case 2
DoCmd.OpenForm "p2_Form1_Stock_Order", acNormal, , "[ID]=" & Me!ID
End Select
DoCmd.Close acForm, Me.Nam

______________________________________

It's not working

I'm thinking, do I need to change "me" (Me.Frame88) from the code to something else?

 

[boblarson]

It's not working

I'm thinking, do I need to change "me" (Me.Frame88) from the code to something else?

ME is a programming thing that refers to the current class object it is on. So, it refers to the form the code is on. You don't need to change it to something else. However, you DO need to make sure that you are referring to the correct option frame name AND the options start at ZERO (0) not 1 so you should have:

Case 0


Case 1


not
Case 1

Case 2

 

[piedpiper]

ME is a programming thing that refers to the current class object it is on. So, it refers to the form the code is on. You don't need to change it to something else. However, you DO need to make sure that you are referring to the correct option frame name AND the options start at ZERO (0) not 1 so you should have:

Case 0


Case 1


not
Case 1

Case 2

Thank you, so having the code in the button event is cool?

I'm I going in the right direction...? I could spend all night on this, I don't care.. as long as I get it to work...again I'm sorry for being a noob... I am learning a lot - and I'm inspired to pick up a book...

So with your suggested edits you just instruct me and with my explaination above where I'm inserting the code in the button (not the radios, but the "step 1, open form button, step 2, open form button) events - things should work out?

 

[boblarson]

Thank you, so having the code in the button event is cool?

So the code goes in the VBA window and in the Event Property you should see a drop down that shows [Event Procedure] which is selected in the property dialog. See here for how to get to the VBA window (just in case you needed it).

 

[piedpiper]

So the code goes in the VBA window and in the Event Property you should see a drop down that shows [Event Procedure] which is selected in the property dialog. See here for how to get to the VBA window (just in case you needed it).

Thank you....

I figured it out... the reason it wasn't working with your code is the the skip buttons were on another form, and could not see frame88...so I moved the buttons to the same form that has frame88 and now it works.

At the same time this eliminates a form...which is good!