[AccessD] My form has a little problem

Jim Lawrence accessd at shaw.ca
Thu Jan 19 11:59:06 CST 2006


Tina:

My prayers go out to you.... I know where you are coming from having lost
two parents, a father-in-law, an aunt, an uncle and three close friends in
quick secession (a warning to you fanatic programmers out there to lay off
the all-nighters, coke, coffee, potato chips and smokes). These will be very
tough times for you and five years seems like yesterday,

Best Regards
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tina Norris
Fields
Sent: January 19, 2006 8:36 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] My form has a little problem

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
>>
>>  
>>    
>>
>
>  
>


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




More information about the AccessD mailing list