Thanks.
Yeah, I reconstructed the Query AGAIN from the starting point, and realized that I had a linking problem. Now works like a champ.
Whew.
JustSteve120
Last Activity: Feb 27 '15, 06:34 PM
Joined: Jan 29 '15
Location:
-
Access Append/Update Query Issue
I have an application, where, at the end of the month, I need a satellite application download data to a collecting database.
The data in the download is managed basically in three tables: a header table, a sub-header table (multiple events can occur within a header) and a detail table, so there is a one to a few many relationship.
Like this:
Audit --> Record --> Question
When... -
Thanks for your assistance on this. I'm going to take a look at seeing how the application can go straight to the permanent table.
Regarding the data loss, I have added a couple of data refreshes in click actions, which has seemingly stopped the problem. Not really sure why.Leave a comment:
-
From the provider record (who is being surveyed), the survey is launched. A header form is launched to set the header info -- date and survey type. Once survey type is selected, the survey tools are returned that can be selected from.
Selecting the tool launches a continuous form with the identified questions in a list of 50 or more questions. There is a dropdown box that allows for selection of Yes/No/NA.
The surveyor...Leave a comment:
-
Hopefully this makes sense...
Questions Table
IDQuestion Number
Question Text Memo
TextResponse Text
Non-scored Yes/No
Survey Tool Table
IDSurveyTool Number
ToolName Text
ToolType Text
ToolQuestionJct Table
IDQuestion
IDSurveyTool
SurveyTypeJctTa ble
IDSurveyType
IDSurveyTool
...Leave a comment:
-
The application has a large number of survey types (around 30), and the surveys are lists of questions that can be scored yes, no, or na. There is a separate table holds the questions. Questions can be used in multiple surveys, so it's not a 1:1 relationship. The temporary table is used to manage the questions that are being displayed from the questions table so they can be displayed on a continuous form. Once the questions are answered, they're...Leave a comment:
-
Access 2010 Intermittent Data Loss
I have an Access Front End/Back End application that gathers data from multiple questionnaires. This is a single user application. There is a questions table that different questionnaires pull from using junction tables. Questions are loaded to a temporary table where responses are gathered, then saved to two tables (header record and detail records). The application also allows to update responses by copied from the save table to the temporary...
No activity results to display
Leave a comment: