Recent content by Liz A

OK, so I have figured out how to make this work, based in large part on what I've learned from other threads on this forum, but have encountered a new wrinkle. The code that's working (using generic identifiers for the controls) is: Private Sub MyListBoxControlName_Exit(Cancel As Integer) If...

Just found this post for a MUCH simpler and more flexible way of determining whether an item is selected: http://www.access-programmers.co.uk/forums/showthread.php?t=115652 Don't know why I didn't find this earlier...

OK, I've made some progress with this, but still have questions. I've used the following code to get a message to appear when the user skips the listbox without entering data. Private Sub lstResponseCodeID_LostFocus() If Me.lstResponseCodeID = 66 [my code for "not yet entered"] Then MsgBox...

Thanks Gemma, To clarify, I am working with survey/questionnaire data entry where each subform represents a given survey and each record is a question in that survey. I'll start playing around with some of your suggestions and post again with the inevitable follow-up questions...

I have a main form with several continuous subforms. Each subform consists of several listbox controls. I would like to require the user to select an item from the listbox before being allowed to move to the next record in the subform, and upon reaching the last record in that continuous...

Thanks for your response namliam. I am a bit of a novice when it comes to VBA (am trying to learn, but admittedly on a bit of an ad hoc basis and so far, mainly by looking at the code generated by wizards). Can I include a VBA function within the query and how would I go about that? I don't...

I am trying to write an expression that calculates a new field in a query. The new field is simply recoding values from another field (survey question responses) using IIf statements. This new field, let's call it RecodedResponse, will eventually be summed in a totals query to get the total...

Figured it out! No temporary table necessary, and I guess it was exactly what Pat was telling me to do, but I didn't get it. In case anyone is interested, here is where I reposted this question in more detail, then posted how I resolved it...

Nevermind! I figured it out and it was ridiculously simple. In case anyone else needs this, the correct query is: INSERT INTO tblTakenSurveys ( VisitID, SurveyQuestionID, ResponseCodeID ) SELECT [DEMO Lab Session Info].VisitID, tblSurveyQuestions.SurveyQuestionID, 66 FROM tblSurveyQuestions...

So, I've been searching through this forum and can't seem to find the answer to this one. I would like to capture a value from a main form and have it used as a value in an append query, in order to populate a subform based on the main form, like so: INSERT INTO tblTakenSurveys ( VisitID...

OK, so I am trying to create an append query to populate the subform, but it is not working. I think this is because I need to pull autonumber PK fields from other tables to append to tblTakenSurveys (all the fields in this table, other than the PK, are foreign keys). In looking into this, it...

So, I'm still working on this one and could use some more help... I've set up the table structure according to the above, and am working on the forms, but am getting a bit stuck. As per what you wrote: Any chance you (or someone) could explain in a bit more detail how and what needs to be...

Right, I understand what ResponseCodeSetID refers to, but am confused as to how it is actually used. I would have thought one would want to relate ResponseCodeSetID back to the actual response codes in tblResponseCodes. How am I to be using this exactly? I mean, where does this information as...

OK, I'm starting to get this. Now maybe I'm missing something, but why would ResponseCodeSetID be a foreign key in tblQuestions and not tblResponseCodes? Also, I should mention that these surveys are part of a larger database, which is why I did not include a table with the "survey taker's"...

Thanks for the tip Pat! So, I've been attempting to create this database the way you pros have suggested and so far so good with setting up the tables, but beyond this, my lack of experience is getting the better of me. So here is my series of questions/concerns: 1. Is there any reason...