Search results

I thought I had responded to this. I'm sorry! It worked and thank you very much for making things easier for me to understand!!! :D

I had some information turned around. It works now. button 1 If IsNull(QaDone) Then stDocName = "frmUser2" DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormAdd Forms![frmUser2]![ProjectNumber] = Forms![frmProjectMasterDetail]![Project Number]...

My query is attached. I have the ProjectNumber field available from both tblProjectMaster & tblScoreResults tables. My code is For button one: Private Sub cmdQA_Click() On Error GoTo Err_cmdQA_Click Dim stDocName As String Dim stlinkcriteria As String If IsNull(QaDone)...

I'm receiving Enter Parameter Value on 2 buttons on a form. One is tblProjectmaster!ProjectNumber and the other tblScoreResults!ProjectNumber. Can you help me track down the problem? thanks!

:rolleyes: I'm just here to torment you!! I have the equation in the query working. I went to the form and changed the values on the option buttons because I got the values backwards. Sorry I'm such a screw-ball. It's part of my charm :p I don't know how to total them though. Thanks for...

Which day do you suppose if worse for me? Monday morning or Friday afternoon??? I went to the form and changed the values on the option buttons to the opposite order and the equation now works!!! Now 1,2,3,4 does indeed equal 2,5,8,10.

IGNORE THIS POST sometimes I'm an idiot Wait a minute, I got myself confused. 1,2,3,4 equals 10,8,5 2. I said that in my first question on Friday but somehow got it turned around. Too bad, that's a really cool trick!!! I tried it out and it worked! I screwed up Friday evening and told...

Each project will only be scored once. The results will be viewed by project number. The 1,2,3,4 will always equal 2,5,8,10. I'm using Access 2000. I'll try the calculated column. But then how do I get them to total?

I don't want to forget that I want to turn the values of 1,2,3,4 inton 2,5,8,10 as I mentioned in the first question. IIf statement!? You know I did PRINT the last lesson! :D Gotta go, this is partly a reminder for myself, got a big weekend! Talk to you later!

Uh Oh, It's asking for me to enter the parameter value for Response2 through Response5. I was afraid I'd get something like that. Any ideas?

Okay, so here's my table. I have two columns QuestionID and Response. Do I need to worry about the Question ID or can I just say Total:[Response1]+[Response2]+[Response3]+[Response4]+[Response5]? Well, I am going to try it, but I'm wondering about the way this table is set up. Do you forsee...

Ah heck! I sent you the wrong design view!!! Doubt that it matters! But it sure doesn't look like that! That's the questionaire. LOL I'm sure glad it's friday!

It's a continuous form that you scroll down. I don't want the total to appear on that form. I want the total score for each record (which contains 5 questions) to go to a query or table so the the total can be displayed on another form. Is this possible? PS It's only one record on the...

Well, Hi there! Your question confused me. I don't think I have either, so I'm sending an example of the design view and the form view. The form view only shows one question, but on the 'real' form you can scroll down and answer each of 5 questions. Make sense?

I have a continuous form that has an option group. There on 5 questions on the form, each with a scoring range of 10, 8, 5, 2 and an option value of 1, 2, 3, 4. Can I write a query that will total the scores, and display the total in one field? How? Thanks, Rhonda

Wooooo Hooooo!!!! :D You are the King (or Queen) whatever the case may be!!! Thank you so very much! I have learned alot from you. I know that I have gobs and gobs left to learn, but it's people like you that keep me plugging away!! It's really great when someone has the time and patience...

What is an invalid procedure call? Expr1: IIf(Left([tblQuestions.PageCode],7)="General","_",Left([tblQuestions.PageCode],InStr(1,[tblQuestions.PageCode]," ")-1)) & Format(Mid([tblQuestions.PageCode],InStr(1,[tblQuestions.PageCode]," ")+1),"0000") I added the tblQuestions. to your formula, it...

Okay, I keep getting invalid syntax errors so I obviously don't know what I'm doing...but I already knew that. I'm not sure how to build this. Help? Ya know, I'll have to print this out and put it in my book!! What an education!!!

I hope not, but in the future I guess it might be possible. I would think if it happened it would be AA 1 AA 2 AA 3, I would think that it never went over 2 letters.

Yes, try adding A 1 A 2 A 3 A 10 A 11 B 1 B 2 B 10 C 1 C 2 C 10 Or something like that I'm getting A 1 A 10 A 11 A 2 A 3 B 1 B 10 B 2 C 1 C 10 C 2 I guess I didn't have to get so carried away! :p