jm.hwsn
jm.hwsn at gmail.com
Tue Feb 15 14:26:05 CST 2011
That's correct. Thanks for the clarification. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Tuesday, February 15, 2011 2:20 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access 2007 - acCmdFind problem Just to clarify - am I right in saying: The problem is not: the content of the sub sub-form doesn't refesh when the parent record changes. The problem is: the subform's source object doesn't change to a different form when the parent record changes. -- Stuart On 15 Feb 2011 at 8:09, jm.hwsn wrote: > I have a tendency to obfuscate ideas... let me try again. > The find works perfectly... it locates all the records in order as it > should. When the user clicks the "Find Next" button on the Find dialog > box, the data in the main form moves to the appropriate record and the > main form refreshes. What I can't get to work is a sub form on the > main form which doesn't refresh. The data in the sub-form refreshes > but the SourceObject; a separate form for each question type, doesn't > update. I created a function that updates the SourceObject but I can't > seem to figure out how to run it after the "Find Next" button on the > Find Dialog Box (standard MS control). Is that clearer? Or did I > muddy it up more? Thanks, 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 5:54 PM To: Access Developers > discussion and problem solving Subject: Re: [AccessD] Access 2007 - > acCmdFind problem > > If it doesn't work, that would ordinarily mean that there was nothing > more to find. Why not post the code that isn't working and tell us > specifically what should be happening. > > Charlotte Foust > > On Mon, Feb 14, 2011 at 10:25 AM, jm.hwsn <jm.hwsn at gmail.com> wrote: > > 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 > > > -- > 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 > > > -- > 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