Search results

Hi, I'm not ignoring your post, I've been out of the office and will look into this soon. Thanks for the advise!

A married couple were in bed one night when there was a knock on the door. The man went downstairs to find a man wanting a push. He said forget it and went to bed. When he went back upstairs his wife asked who was at the door. He told her some guy wanting a push and he went back to bed. His...

Hi Pat, I removed the 9 but got unexpected results. When I opened the form from form view and entered a bunch of answers they all showed up in tlbQuestionResults in a "straight line" regardless of what the survey number was. See attachment. Then I dicided to try and go through the main menu...

I have a query that sends answers from a survey to a table. This was written by someone who has been helping me to learn Access. For some reason that I am not aware of a "9" was placed in the criteria for Survey Number in tblQuestionResults. The answers in tblQuestionResults only hold answers...

Wooo Hooo!! It worked!! Now that I have one qryGenerateQC my if statement worked! Thanks Chris! You're Number One!!! Private Sub cmdNextStepGen_Click() On Error GoTo Err_cmdNextStepGen_Click DoCmd.SetWarnings False Dim stDocName As String Dim stLinkCriteria As String...

Thank you Rich!!! Now that I have it limited to one query, I still have the trouble of it always opening the QC survey regardless of which button is selected. How can I change my code to correct it. I have tried entering an if statement with laughable results. (I got both forms to open at...

A woman calls the grocer and asks that he deliver 38 qts of milk. He asked; What do you want with so much milk? She tells him; I'm going to take a milk bath. He asks: Do you want it pasteurized? She says no, up to my neck will be fine...

I've been playing around with this. Is this something that the user would have to fill out? I just want the form to open after they select their choice of QC or QA from another form. They wouldn't know what these codes mean. When the database opens to the main menu there is a choice to...

I'm sorry, it was created in 2000. It is also too large. I've been trying to remove stuff but haven't managed to make it small enough. I don't want to remove too much for fear that it won't make any sense. I'm still trying to reduce its size...

Rich, I don't understand. The query uses "b" and "d" to select specific questions to show on the survey. One survey (QC) uses all the questions (b & d) and the other (QA) shows only the questions labeled b. I tried the [Enter Type] and get Enter Parament Value messages and then it wants to...

Hi Rich! If I want to have only one query, I have a "user type" which has a "b" and "d" ...for query generate QC the criteria is "b" or "d" and for query generate QA the criteria is "b". Hate to sound like an idiot but hey... :) How do I write my criteria? Gee I have a lot to learn!

Tony: "Generate QC" is an append query. I didn't write this code, it was written by a guy from my IT department. He is not available to help me at this time. I don't understand much about code yet, but I'm trying! I have two different surveys and there are two queries as well. Each to open...

I have a series of forms that open on click of various buttons. On frmProjectMasterDetail there are two buttons "QC" and "QA", when either of these buttons open a new form opens: frmUser2 which displays the survey type either "QC" or "QA". My problem starts when you click the "Next" button...

I hate sounding stupid but I probably will... I set the record source to a query. And the source object to the subform. I did this inadvertantly. I am not familiar with the source object. I've been playing around with it a little since you brought it up. With no success. My eyes are about...

I must be losing my mind. I thought I had submitted this and can't find it. I also can't find my subform!!! When I view my form in form view the subform does not display. I have placed subforms before in this manner and have never had this problem. Any ideas? Thanks, Rhonda

Hey thanks! Yes it's all there, but I got to looking at my file names and found that I had cmb_county and cmbCounty. I try to stay consistent but don't always manage. I'd have never noticed without your input! Thanks again, Rhonda

I have a form with a combo box and a search button. Select a county and click search...but then get an error "object required". I can't find a problem with my code and thought that perhaps someone could take a look. I'm sending all of it, (there is also an open button) just in case the...

Yes I have. I tried to follow that and lost my continuous subform. I would like to have all questions for the category to show together as it does in my sample.

I'm still chasing my tail and beating my head against my desk. I try one thing and lose my continuous subform, and still my option buttons don't work properly, I get my continuous form back and the buttons still don't work. I've tried making a subform of just the option buttons and putting...

I'm sorry, the questions in were showing up in the subtable before, I just couldn't get the option buttons to work. Didn't mean to make you mad. Thanks for the help that you gave me. Rhonda