[AccessD] Access 2007 - acCmdFind problem

I do not use acCmdFindNext at all.  But yes, the user can modify any
instance of the value being searched.
When the button is clicked, the Find Dialog appears.  The user has the
option to search for any text they need to find.  They also have the option
to do a global change (e.g. 68W to 92C) within all the question texts.
Anytime the "Find Next" button in the Find Dialog box is pressed the sub
form does not update.
The user can use the dialog box for anything within the question text.

Thanks, Charlotte

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Monday, February 14, 2011 12:14 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access 2007 - acCmdFind problem

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
>

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com