Topics Search

Standard responses

Standard responses
Views: 0
On a number of my forms, I have preferred or standardised text for responses under different circumstances (ie if "this" type "ABC"; if "that" type "XYZ").

I have saved these in autocorrect; however, autocorrect is machine based coding. If I type "STBC" I get "search to be conducted", but no-one else using the database will.

I'm wondering is there a way to (ie how do you) program autocorrect functionality that is part of the database, rather than part of the user's Office settings
Sponsored Links:

Similar posts...


Report that returns the percentage of complete vs. incomplete responses

Report that returns the percentage of complete vs. incomplete responses Icon
The responses are captured via yes/no check boxes with a checkbox for YES, NO, and NA.

I'm trying to create a report that returns the percentage of complete vs. incomplete responses:

1 100% 0% 50%
2 50% 50% 0%
3 NA NA 100%
4 100% 0% 0%
5 NA NA 100%

I can't figure out how to make the report generate "NA" for the YES and NO fields on questions who's responses are NA (questions 3 & 5 above).

I need to show questions that are NA without those #VALUE! deals all over the place.

Storing Responses

Storing Responses Icon
In part I of our case study, we examine one possible means of storing both single and multiple option form responses within the same data table.

Survey Database Design - hit a snag

Survey Database Design - hit a snag Icon
I am working on a Survey / Questionnaire database and have hit a roadblock. I am trying to follow a design that mirrors the At Your Survey database in Roger's Access Library that has been recommended on these forums.

jpg (zipped since forum says new users can't post images) with the current relationship structure that I have. I have removed the Surveys table as there isn't a need formore than one survey any time soon.

Many of the survey questions are set up in sets like below (example only). Each question (Fruit 1-3) uses the same list of possible responses and the responses need to be ranked (Fruit 1= most preferred fruit, Fruit 3 = Least preferred).
List Your Top Three Fruits
Fruit 1: Apple
Fruit 2: Pear
Fruit 3: Orange

Because of this, I have set up an extra table with question categories. Otherwise, I would be storing a lot of redundant values if I had a table with only the QuestionID and PossibleResponses (some sets of questions will ask for as many as ten user responses that use the same set of possible responses)

I want to be able to join the Possible Responses table (SrvQPosResponses) to the table where the Survey Responses are stored (SrvResponses).

The At Your Survey database does not join these two. Don't I want to join them so that if I change a possible response, it will be updated in the survey responses as well (say if I want to rename Apple to Apples).

Count responses based on entires of other table

Count responses based on entires of other table Icon
I want to do a query that counts the responses in one table that match the values of another table. So, for example

Table Options

Table Responses
OrderNum Color
12 Blue
21 Blue
33 Red

So, I want a query that outputs:
Blue 2
Green 0
Red 1

So far I've only built queries using Query Wizard (so SQL code still reads like Greek to me

Multiple Message box responses

Multiple Message box responses Icon
Could someone please tell me how I can handle responses to various msgbox's.

At the end of a from the user is presented with a yes / no msgbox. Depending what the response is relates to what happens next.

So in my case

if they answer
Q1 with yes they get Q2

if they answer
Q2 with Yes form does its normal thing


If they answer
Q1 with No they get Q3

If the answer
Q2 with no they get Q3

And finally

If they answer Q3 with Yes or No form does its normal thing!

I have tried numerous ways to sort these responses and am even confusing myself ! I have tried using the Elseif but to be honest Im not 100% sure I am using it right as depending where I put it in the order of the code it will work but the Questions then don't come up

How do I show only aggregate data for survey responses?

How do I show only aggregate data for survey responses? Icon
I'm trying to develop an Access 2007 report that will allow me to analyze and aggregate raw survey Monkey survey data without displaying the individual responses to each question.

The structure of the data is as follows:
Each respondent's survey is on a separate row
Each column contains the answer to a single question
All answers are constrained to a list of choices (e.g., Best, Bad, What I'd like to do is to build a report that shows the percentage of responses to each question. So, for example:
Question #1: What did you think of our product?
Best: 25%
Good: 50%
Bad: 25%
Poor: 0%

chart with multiple serieS

chart with multiple serieS Icon
I am developing a survey application that has 4 questions with responses. the responses are strongly disagree, disagree, agree and strongly agree. I would like to make a chart of some type in access that would show the over breakdown of the questions and the total answers.

I was thinking something like a bar chart that would have the names of the questions along the x axis and a count of the responses along the y axis.

each question would have 4 bars one for each of the answers (strongly disagree, disagree, agree and disagree). the aim would be to allowmanagement to see where the strong points and weak points across the board.

Counting similar responses from Multiple fields; output into a crosstab type view

Counting similar responses from Multiple fields; output into a crosstab type view Icon
I would like to take a table of data (example below with four rows of responses) as such:

Model ; SN; Date ; Windows; Tires; Interior
Ford; 1234; 1/1/2011; Good ; Good; Fair
Ford; 1234; 1/1/2012; Good ; Poor; Poor
Chevy;9000; 1/3/2012; Fair ; Good; Fair
Toyota;5555;1/3/2012; Good; Poor; Good

and turn it to a crosstab type output that groups the responses of conditions to resemble the following:

.Windows; Tires; Interior
Fair ; 1 ; 0 ; 2

Comparing values from different records

Comparing values from different records Icon
I'm not sure exactly what is the best way to do this, so I have this under queries . I have a listing of survey responses from year A. I have another listing of survey responses from year B. Both are in the same table with a unique record - names and years are separate related tables. What I need to be able to do is find out if each individual's answers to questions X and Y changed from year A to year B and then count how many changed. In other words, I need a way to say that # individuals changed their answer in question X and Y from year A to B. Is there a way to query this

Bar Chart based on report calculations...

Bar Chart based on report calculations... Icon
I am using Access 2002. I have a query with one field called txtUsedKnowledge that has four possible responses. They are Never, Small Extent, Moderate Extent and Great Extent.

I did many calculations with these including counting them individually and getting the percent for each one based on the over all count. Now I would like to create a bar chart with the four responses listed that will update each time it's run.

I created the chart but have to type in the figures for each response myself. Since the calculations are done on the report and not in the query is there a way to use the fields from the report. Unfortunately, this is my first time trying to use the Chart feature in Access. If I can't do this with the Chart option is there another way to have a bar appear on a report?