Search results

Update, THIS IS the cause of the problem, however I do not have a solution. No matter what, if I enter a new record on the main form, then move to the subform, the record source saves the record and re-sorts, effectively 'moving' me to a different record. I have tried putting an...

The main form is a single form, the subforms are continuous forms, linked to the PK of the main form's control source table, so the links are all correct....but for some reason when I click onto one of the subforms (when entering a NEW record only), it takes me to a different record...

I have a form with 3 subforms. They are all correctly linked. Main form is MainID (PK auto) field1 field2 etc Subform 1: subform1ID (PK auto) MainID (FK to mainFormPK 1 to n) field1 field2 etc Subform2 subform2ID (PK auto) MainID (FK to mainFormPK 1 to n) field1 field2 etc Basic...

THank you for the response, David! Oh Yes, believe me. Myself and the statistician have discussed this many times, unfortunately often the survey design is completely out of our control, and we are forced to work within the constraints of each different survey. This particular one has two...

second bump - is anyone familiar with this? If you need more info I can provide it!

bumping thread

relationships

Hello. I use a survey database design based largely from Duane Hookum's "At Your Survey" This allows for multiple surveys, each with their own set of questions, and each response to a question is stored in a surveyResponse table. For those of you that are familiar with this design and other...

Beautious! Thanks! repped

Yes, definitely! Thank you for the response. This is one half of what I would need. Im looking to bulk insert these values based on the "questionType" field. There could be any number of questions (QID) that require this insert. Like: If questionType= "YesNo" then INSERT these values

Hello. I made this database, based on Duane Hookum's "At Your Survey" design. It was made for medical survey-questionnaire responses. It is attached with some sample data so you can see what I am talking about more easily One of the tables, "questionTable", lists all of the questions...

The way I learned to do this was mostly from user CraigDolphin: Make a form bound to tblStudents and a subform(continuous) bound to tblResponse. The idea is to write SQL code that, once a student number is put into the textbox, inserts the list of questions into tblResponse. All that is...

bumping the thread

Before I begin: yes, I have searched the forums :D I was looking for some help on VBA syntax. I have a continuous form with a text box. I am trying to limit the entry validation of the textbox to a set of numbers (most likely 0,1,2,3,4,5,95, and 99) BUT ALSO allow text strings of any...

Right, this is what I am doing (or aiming for, rather), however it seems as if the Answers table was solely a lookup, the combobox rowsource would return every value in the Answers table. Under normal circumstances this would be fine, but for my purposes I need to limit the responses based on...

Oh boy....I think I may be screwed here The join based on the AnswerValue field only exists in the query design view, its not in the actual Relationships. I pretty much just made that messing around... I personally assign the AnswerValue and AnswerText for each question, because they are...

I provided some screenshots in the attachment Im actually storing the AnswerValue field into the ActualAnswer wherever a combobox is used, this is because a number needs to be stored. (The statistician uses numbers to analyze the data). I just wanted to be able to associate the text with the...

Ive been posting a lot of questions about survey DBs, I think I may be able to help you out a bit on this one. This is the way I would approach it: [code] tblStudents StudentID - pk Gender ModeOfStudy Age tblQuestions QuestionID - pk QuestionText tblAnswers 'this is the lookup table for your...

You have the scenario exactly... I'd much rather live with a small detour from normalization which makes things way easier in the long-run. I tried to design a query which would list the patientID(tblStudyInfo), the questionID (tblStudyInfo) the question Text (tblQuestions), the actual answer...

Hey, I have a question about the Answer table and its relation to the Question table. The Question table has a 1 to many relation with the answer table. As you know the answer table is used as the rowsource for the actual answer combo. AFter testing out some queries, I am wondering if this...