[AccessD] My form has a little problem

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Thu Jan 19 10:54:41 CST 2006


Tina:

I understand.  My father died two years ago.  But he was almost 88.  So 
he had a good run, but that doesn't make any difference in the 
difficulty of the process.  It wasn't quick for him, either.  couple of 
years of very bad health. 

We are contemporaries, I assume, so we see more and more of our friends 
are going through this. It's inevitable and unstoppable.  I guess we 
just have to accept it.  It's hard to see the people we love decline 
especially our parents.  We'll keep you in our thoughts and hope that 
there are some bright moments among the sadness.

Rocky


Tina Norris Fields wrote:
> Hi Rocky,
>
> Thanks - that fixed it.  The simple generosity of spirit I find in this 
> list always amazes and delights me.  
>
> This next part of my message is OT and personal - but here goes, anyway. 
>  A year ago, on January 29, my mother died - she had been dying for some 
> long time, slowly, from a vascular demntia that robbed her of her 
> ability to think and to act for herself.  We grieve the loss - the long 
> term loss and the final loss - and grief is amazing in its ability to 
> disrupt.  My father is also in bad shape, because of life-long habits 
> that did him great harm, but also because two years ago he fell getting 
> down from a speaker's platform - he had just presented an environmental 
> excellence award and was descending steps that had no hand-rail.  The 
> fall broke his right leg where it goes into the hip joint.  That had to 
> be surgically repaired.  As he was convalescing, he had other things go 
> wrong - a virulent infection we had a really hard time stopping, for 
> example.  By July 12 it was clear something awful was happening - we 
> thought it might be stroke - it turned out to be a subdural hematoma 
> (blood clot on the brain) - actually two, but only one looked active to 
> the neurosurgeon.  Craniotomy on July 14 to save his life.  Well, the 
> second one gave us the next two emergencies August 3 and October 2. 
>  Since then, he has worked on recovering his strength, learning to walk, 
> learning to think, and becoming active again in his passion - clean 
> water.  (And, he lost his wife, you may recall).  We have seen his 
> valiant effort, and also witnessed his continuing intellectual decline. 
>  It is heart-breaking, but also encouraging to see a man keep on trying. 
>  Recently, his only sibling, my uncle, was diagnosed with kidney cancer 
> - and we are all in the throes of doing the necessary - surgery to 
> remove the diseased organ, strategy to heal enough to begin a medication 
> regimen to help fight the cancer, which has, of course, metastisized to 
> the lungs.  Now, we're struggling with the acculmulation of fluid in the 
> pleural space around his lungs - and it looks as though we are  winning 
> this round.  The whole family is cheering for him to fight back - and he 
> does have a strong, cheerful, optimistic will to live.  I ache for these 
> loved ones.  Any of you given to prayers - know that I welcome your 
> prayers for my dad Jack Norris, and my uncle Brad Norris..
>
> Thanks for everything,
> Tina
>
> Rocky Smolin - Beach Access Software wrote:
>
>   
>> "Should I be adding an After Update event procedure to my unbound combo 
>> box - to set the focus on the button to get the student information form? "
>>
>> That's the first thing I'd try, Tina.
>>
>> Rocky Smolin
>> Beach Access Software
>> 858-259-4334
>> www.e-z-mrp.com
>>
>> Tina Norris Fields wrote:
>>  
>>
>>     
>>> Hi all,
>>>
>>> I have a form for either creating a new student profile, or editing an 
>>> existing one.  To create a new profile, the user clicks a button that 
>>> opens the student information form in add mode.  To edit an existing 
>>> profile, the user selects the student's name from an unbound combo box, 
>>> and then clicks the button to open the student information form for that 
>>> student in edit mode.
>>>
>>> When I first made this little form, it all worked well, but it no longer 
>>> works just right.  If I select a student's name from the combo box, and 
>>> I try to click the button to open the student information fomr, the 
>>> button does not get the focus - it does not respond.  If I wait around 
>>> for a while, eventually the button will let me click it.  If I tab out 
>>> of the combo box, the focus will shift to the the buttons in their 
>>> established tab sequence.  
>>>
>>> I remember there have been heated discussions on this list about unbound 
>>> controls.  I am ready to learn - do I have a problem because I'm using 
>>> an unbound control?  
>>>
>>> This is what my button does when I can get it clicked:
>>> ==========
>>> Private Sub cmdEditExistingStudentProfile_Click()
>>> On Error GoTo Err_cmdEditExistingStudentProfile_Click
>>>
>>>    Dim stDocName As String
>>>    Dim stLinkCriteria As String
>>>
>>>    stDocName = "frmStudentInformation"
>>>    stLinkCriteria = "[StuID]=" & Me![cboFindStudent]
>>>    DoCmd.OpenForm stDocName, , , stLinkCriteria
>>>
>>> Exit_cmdEditExistingStudentProfile_Click:
>>>    Exit Sub
>>>
>>> Err_cmdEditExistingStudentProfile_Click:
>>>    MsgBox Err.Description
>>>    Resume Exit_cmdEditExistingStudentProfile_Click
>>>   
>>> End Sub
>>> ===========
>>>
>>> Should I be adding an After Update event procedure to my unbound combo 
>>> box - to set the focus on the button to get the student information form?
>>>
>>> Thanks for whatever lessons you will send my way.
>>>
>>> Tina
>>>
>>>  
>>>    
>>>
>>>       
>>  
>>
>>     
>
>
>   

-- 
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com




More information about the AccessD mailing list