Charlotte Foust
charlotte.foust at gmail.com
Mon Feb 14 12:14:09 CST 2011
I'm not sure I understand #1. You find an instance of the value and allow the researcher to modify that instance? Then use acCmdFindNext and it doesn't work? Charlotte Foust On Mon, Feb 14, 2011 at 8:18 AM, jm.hwsn <jm.hwsn at gmail.com> wrote: > The project I am working on administers a questionnaire to students in an > attempt to bring down the attrition rate. > > The questionnaire is designed and administered by one or more researchers. > > The questionnaire is not static. that is the researcher can add, delete or > modify the questions at any given time. > > This allows the researcher to place a question anywhere within the > questionnaire. > > There are 20 different types of questions, e.g. true/false, scale (1-10 or > 1-100), 4 point Lickert type, etc. > > The researcher can change the text of each response in a question as well as > change the text of the question. > > We are currently going through usability testing. The entire "class" is > around 500 students. The class has a 3 digit identifier that is used in the > questions. There are about 350 questions in the current questionnaire. > > > > The researcher uses a Question form to modify the questions. The question > form has a sub form that shows an example of the question as it would look > on the questionnaire. When a search is done using a list box for combo box > the sub form changes to reflect the text and type of question. When the > question type changes the sub form updates the sample. For example a > question might change from a fill-in question to combo box self-lookup > question OR a question might change from a 4 pt multiple choice to a 4 pt > Lickert type question. > > > > Here are my questions: > > > > Question #1: > > As I mentioned above the class has a 3 digit identifier embedded in some > questions. The researcher puts this identifier within the question to > personalize it for the students. I have a button on the question form that > is used to search for questions with the 3 digit class identifier. I use: > DoCmd.RunCommand acCmdFind because, the 3 digit class identifier will need > to change periodically and this allows the researcher to do a "replace all" > after the search. > > > > I cannot figure out how to update the sample question sub form after the > "Find Next" button is clicked on the Find dialog box. > > Does anyone know how to run a custom function (update sub form) while the > dialog box is still open? > > > > Question #2: > > When the search button on the question form is clicked, I use SendKeys to > ensure that "Match" is set to "Any Part of Field" and that the cursor goes > to "Find What" field. That works, however, occasionally the Num Lock key is > turned off. I understand that I could use: Application.SetOption "Default > Find/Replace Behavior",1 - but that would set it for all users. Is there > some way to achieve the same functionality without using SendKeys? > > > > Thanks in advance, > > Jim > > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >