Search results for query: *

I have a multi column report with 2 groups and 5 columns. The outer group has a header, and since I changed the layout to columns, this header will only expand as wide as a column! I have it stretched all the way across in design view, but in report view it doesn't stretch. Also, the first...

I have a table of 50 different multiple choice answers to about 8 questions. Each question has a set of 5 answers to choose from. I want to make a query that will count how many of each answer was given for each question. Here is the problem - I want to show the 5 possible answers for each...

Wow, thanks. That sort of works! However, I get the same group of answers for every question! Any idea why? Here is the code: SELECT [qryQuestionQuickAnswer].[QuickAnswer] FROM qryQuestionQuickAnswer WHERE ((([qryQuestionQuickAnswer].[qID])=[Forms]![frmCityState]![tblAnswers...

The table data is a textbox (I give the user a textbox, a combo box, or a checkbox depending on the question type). I looked at Access help files and it keeps telling me to change the "format" property of the checkbox, but I don't see it! :(

Hi, I am sorry about this dumb question, but it is confusing me. I have a checkbox, with no format property. I thought the format property should be the first property under format? I am using Access 2000, is it somewhere else in this version? Is there another place I can format this in? I...

I have a survey and some of the questions are multiple choice. Each question has it's own set of multiple choice answers. I have a table called tblQuickAnswers which has the text for each multiple choice answer. I have a table tblQuestions, which has the text for each question. I have a table...

Hello, Please help. I have a subform with a combo box. I want to look at the value in the combo box and show different controls depending on what that value is (for example, if the value is "Combo/list" or "3" I show a combo box for data entry, if it is "Text" or "1" I show a text box, etc)...

You ROCK! Thanks - :)

I get the same message. Am I putting in my form name incorrectly? I have DoCmd.GoToControl [Forms]![frmCityState]![tblQuestions subform] I thought [Forms]! told Access it was a form, [frmCityState]! is my main form, [tblQuestions subform] is my subform ...

Hi, Does anyone know how I can control 2 forms with 1 command button? I have a form with 2 subforms, one is linked and one is not linked. I want to put a command button on the linked form that when clicked will 1. Move to a new record on the linked subform, and 2. Move to the next record on...

Thank you. This really helped!!!

Hi, I have a table of questionnaire data with multiple columns of multiple choice questions (you can pick from 5 different answers) and several columns of true/false questions. I am trying to write a report showing what percentage of people chose each answer for each question. I have written a...