Standard responses

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:

Related Topics

Report that returns the percentage of complete vs. incomplete responses
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:

Q YES NO NA
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
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
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
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
Blue
Green
Red

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

But

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


Unlocking standard form layout
I'm trying to figure out how to unlock access' standard form lay out with one column to have multiple columns See image below. I would think this would be fairly easy, but I can't move theboxes out of their standard layout.

Blue = Field

Orange = txt box


Query criteria in linked table
I'm relatively new to the Access game but amd trying to extract some data from a healthcare database that I have created.

There is the main table with standard/simple data which has a linked table that allows multiple values to be entered. I have created queries that will count how often each individual response has been entered however I want to create a query that tells me how many records have more than one (multi)value selected.

This would mean that in our reporting we could say x% of people have this condition, x% of people have this condition while x% of respondents had more than one condition.

NB. The linked multivalue table has approx 20possible responses while the main table has about 1000 records.


Outputto error when trying to create a PDF
In my program (Access 07)I had a prompt for the client to create either a PDF or an HTML file from a report. If the client responses they wish to create the PDF I use the standard DoCmd.outputto acReport, stDocName, acFormatPDF, etc. this works fine on every machine except one and that client is getting the error "The outputto Action was canceled" although if they choose the HTML option that is exactly the same except for the acFormatHTML. The program runs with MS Access runtime, I've tried reinstalling the runtime but that didn't make any difference.


Best Way to Approach Standard Letters?
But I can't figure out the best way to go about Standard letters. We have about 10 standard letters in my company.

I want to print them directly from the editable form, not as a report. I've laid the form out with our letterhead, standard fields, etc so that it prints just fine, but I don't know how to go about the different bodies of the letters.

I wanted to be able to select an [ID] primary key to populate the text box with the appropriate letter body, but the problem is that some of the bodies contain parts that need to be filled in according to the current letter I am printing.

For example, one letter body refers to a $ amount that I enter in another field on the COR form.


Query criteria in linked table
I'm relatively new to the Access game but amd trying to extract some data from a healthcare database that I have created.

There is the main table with standard/simple data which has a linked table that allows multiple values to be entered. I have created queries that will count how often each individual response has been entered however I want to create a query that tells me how many records have more than one (multi)value selected.

This would mean that in our reporting we could say x% of people have this condition, x% of people have this condition, x% of people have this condition while x% of all respondents had more than one condition.

NB. The linked multivalue table has approx 20possible responses while the main table has about 1000 records


How can I print form data in a standard letter
I have a Access2002sp3 database. Data is input via a form into a table and sometimes (at the time of input) we need to print the data out in a standard letter format (basically like a mail merge with a standard letter template and data coming from the single record in the table).

So far we've been doing it by exporting the whole table to Excel and then doing a mail merge selecting only the records that we want printed. Very tedious! Is there some way I can put the standard letter into an Access report and then just click on a control button on the input form to print the particular record's data in the standard letter?


Bar Chart based on report calculations...
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?


Table Design/Relationships
So I'm doing research and have been asked to use access instead of other programs for my current project. I'm doing a survey and collecting responses.

I have the master table which is where I enter the responses. However, each question has been written to match several classification systems so I've been told to link the field/column for each question on the master table to a row on another table where I classify each question. Its not easy to explain so I've attached a picture.

I think they want to be able to run a query which pulls all questions which are classed as 'A' for Cat1. and then pulls those fields from the master table. Thus creating a table which has only got the answers to Q1 and Q2.

I tried dragging Q1, Q2 etc to 'question number' as a relationship but it makes duplicates of the table instead and I don't understand what its doing.

I'm sorry if I'm not making sense. Please let me know what I need to clarify


RDBMS Basics
Basically RDBMS (Relational Database Management System) is nothing but a standard. For many years database industry was not having any standard for storing and retrieving information. As a result to this standard we came up the language called SQL or Structured Query Language. We use SQL to communicate with RDBMS databases including but not limited to MS Access, Oracle, MS SQL Server etc. MS Access database have file extension as .mdb.


Skipping a field if there is a word FALSE in it box or 0
Im trying to get the Standard Deviations but in order for me to do this I need to skip over months that have a false or zero in the cell. Im using a VBA Script to get my Standard Deviation, but if there is a better way, please let me know that also.

The script Im using takes 6 months into account. Then calculates the Standard Deviation.

Im hoping someone can help me fix the code below to skip fields that have false or a zero

VBA Script Im using


Opening a navigation form for a users from a search form.
I am trying to create a form which will allow users to enter responses (using combo boxes for responses) to a series of questions which is to be stored in a table.

In order to access this form (which is a navigation form), the users must enter their unique details into a search form first which will then run a query to check if the user is allowed access.

However, I am finding it difficult to create the code for the search button so that when the user enters the details correctly, the navigation form appears for that person only appears. At the moment, whatever user name I enter, first user listed in the user details table appears.