Robert
robert at servicexp.com
Tue Feb 15 08:46:45 CST 2011
Try: With Me .ctrsubform.Requery End with WBR Robert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jm.hwsn Sent: Tuesday, February 15, 2011 9:09 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access 2007 - acCmdFind problem 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