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