Jessica- It would really help if you would include all the prior text from the thread in your replies. I had to go to the forum to figure out what is going...
Beth, In the next few days, I shall try to put together a sample db covering more than four generations, using the alternative approach mentioned in my earlier...
Sorry - I post from the board Okay, I am not quite sure how this will work. Right now I am pulling one record from each table. So I have one client per car...
I have a subform on my main form that I want to require entry on. Searching online I see this is a common scenario with a not so straightforward solution. I...
Dear Sir, Extremely Superb ! ! ! Your RuningAmount sample db I run.......(http://www.rogersaccesslibrary.com/ADTejpal/RunningAccount.Zip') and I could not...
Dear Sir, Extremely Superb ! ! ! Your RuningAmount sample db I run.......(http://www.rogersaccesslibrary.com/ADTejpal/RunningAccount.Zip') and I could not...
Hi Kelly, Welcome to the group. I am surprised that no one has replied yet. It is probably because it's the weekend and the weather is so nice. It is very nice...
Hi Cayce, Try doing it in the AfterUpdate Event. If you do it in the BeforeUpdate and Cancel=True then you will cancel the update so the BeforeUpdate happens...
Hi Forumspot, Yes you can. Just add a blank line to the underlying query or list and either sort in alphabetical order or otherwise arrange that the blank...
Hello to all. I live in the midwest city of Kansas City and would like to find anyone who might enjoy helping someone new to access learn the ropes. I am using...
Hi Clive, Thank you for the response. If I understand you correctly you indicated I should put the code for the subform in the AfterUpdate event. I gave...
Welcome to our group, Paul. We're certainly willing to help you in any way we can. If you have a specific question, just start a new thread, give it a...
Hi again Jessica, I guess I'm the one with the most knowledge of your data at the moment, so here goes. One of the expansion things you may need to think about...
Lee, sounds like you may have missed Kris's point. When you develop the fornt end and link the tables, you use the UNC address, not a mapped one. You do this...
Paul I would say that you have found the best tutors right here. What is good about the list is that you can address specific stuff that seems to you to relate...
Hi all, I am having trouble with the last part of this code: ************************** Private Sub EyeColor_DblClick(Cancel As Integer) On Error GoTo...
In my email it looks as if it's the lowercase letter o not zero? Brett ... -- Brett Collings Strengthening Families Administrator D2D 46422 DDI (04) 916 3422 ...
Hi, I am trying to compile my pedigree database and keep running into an error that says "invalid use of Me keyword" in this function (strFormField =...
Thank you AD, that is more than expected, so please do not feel obligated. I will credit your code in the project of course! Beth G ... -- BG [Non-text...
Brett You were on hiatus when we added of group's Twenty-Something Rules (a compilation from many of our gurus). It includes a lot of what you mentioned and ...
Beth, It looks like you are using Len() properly. Have you tried putting a breakpoint in your code on that line so you can check that Len returns what you...
Yeah, I have tried a breakpoint and basically the If just tests out that Len(Me.Eyecolor) >1 is a false statement, so it sckips the code. The point of that...
Another forgotten skill that i can't seem to find in Access help: how do I refer to the value of an option group in code? I have radio buttons that I want to...
OK, well I seem to have guessed right and now I need to know how to direct this to a subform. I tried SetFocus, but that doesn't work. The option buttons are...
Beth You test the value of the frame (option group) not the individual buttons. I usually do this in the frame's AfterUpdate event, but it can be tested at any...
I took a different tactic and got this to work on the after update: Private Function FilterEvents() 'apply filter to events subform based on option button...
Beth If the control is bound and the record is dirty, the value might still be Null. If you are not in one of that control's subs, try setting focus and...
