Search results

I would like to click on button on a form to send an email containing 3 reports. I used the following: Private Sub CmdEmailScoreReports_Click() On Error GoTo Err_CmdEmailScoreReports_Click Dim stDocName As String stDocName = "RptNegativeResponsesByProject" DoCmd.SendObject...

I've been reading about blank records and have tried a few options found here but have not solved all my of problems. (I tried going to the table and making them required fields - didn' t like that, so I used Pat Hartmans 'if statement': If IsNull(Name) Or IsNull(Office) Then MsgBox "Record...

I've been reading about Deleting Records with a Delete Query. I understand that I should create a relationship between tblUser2 and tblQuestionsResults with SurveyNumber and select Enforce Reverential Integrity and Cascade Delete Related Records in the Edit Relationships Box. Because the...

Using wildcard in a combo box search function?? I have a form with a combo box to search (by county) on it. The problem is that the data may be listed by multiple counties and the search is by single counties. There are 99 counties listed. The data comes from a different source and the...

I have the following if statement IIf(Left([tblQuestions].[PageCode],7)="General","_",Left([tblQuestions].[PageCode],InStr(1,[tblQuestions].[PageCode]," ")-1)) & Format(Mid([tblQuestions].[PageCode],InStr(1,[tblQuestions].[PageCode]," ")+1),"0000") This works in one query (qryQCsubform) but...

If[tbluser]![survey_type] = "QA" then [tblQuestions]![UserType] = "b" else ("b" or "d") Do you see something wrong with this? I received an error message that said I had invalid syntax - maybe an operand without an operator...it was highlighting the word 'then'. What I'm trying to accomplish...

I'm faced with another interesting sort issue. I have been studying about functions Left, Mid, and Right. I can't seem to get anything to work. I need to sort from beginning to end and not from left to right. I have numbers and letters both. I have read old posts and can't find any help. I...

I have 5 queries that are run at once. Each query works fine on it's own. The problem is that one query may pick up a question and 2 other queries may pick up the same one, resulting in duplicate questions reported. Does anyone know some code that would limit the queries to reporting the...

I have a form with 5 option groups. Each group has an append query written to retrieve questions pertaining to the choice made in each group. There is a continue button on the form that runs the 5 queries. When pressed the questions go to a results table. The problem is multiple...

I have 5 append queries that I want to run from the push of a single command button but I don't know how to string together the code. I was instructed to build a button to run one query and then copy the code down 4 times and rename each one according to the querie names. Currently the...

Is there a way to make a selection in cmb 1 and have it limit the available information in cmb 2? For example, the info in cmb 1 is contract numbers, the info in cmb 2 is subcontract numbers. The subcontract numbers are specific to the contract number and I only want to show those instead of...

I've been doing some reading in the archives and can't find a solution to my problem. I have a table (tbl_QualityControl)with several hundred questions. These questions are coded to relate to different work types. Some questions may relate to 1, 2 or all of the codes. In trying to normalize...

I've been doing testing in my database, and now that it's ready to go, I want to reset the auto numbers to 1. These are located on a couple of forms. I have the following tables, tblNextSurveyNumber, tblSurveyNumber and a query, qryNextSurveyNumber. I didn't set these up myself, and I'm still...

Help~I broke my query! All was fine until my boss asked to sort between two dates. The original query showed which questions were answered "no" and counted how many times for each question. Then I added a field to display that information between two dates. >=#9/1/03# And <=#9/26/03# Now...

I have a combo box on a list form that opens but will not allow me to make a selection. The combo box is based on a query. the row source is: SELECT [qryCmbUserScore].[Name] FROM qryCmbUserScore; After making a selection I have a search button to filter the information on the list to show...

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!

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

My data needs to be sorted a little differently. First all topics beginning General 1, General 2, General 3, etc., then A1, A2, A3, B1, B2, B3, C1, C2, C3.... Is there an easy way I can accomplish this? Thanks, Rhonda

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...

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...