Search results

  1. B

    Someone has hacked the forum :(

    I'm sorry that this happened. It's really hard to move around the forum now. What a waste of an excellent resource! But at least you got rid of that annoying music. :D
  2. B

    Has the forum been hijacked?

    Is there a way to back track this little shit and blow his computer up?!
  3. B

    Has the forum been hijacked?

    This is really irritating!!!! So how do we get rid of it?
  4. B

    Having some subform fields auto fill from mainform fields

    RG, It still won't let me add or change a record because a related record is required in table [Names of Household Members]. Is there a major flaw in my design somewhere? I had hoped that from the data entry form a name could be typed in, and if a record existed that matched, the form would...
  5. B

    Having some subform fields auto fill from mainform fields

    RG Hi, Just got back to this, sorry it's taken me so long. Haven't had a chance to look at the improvements you've made, but wanted to let you know I'll look at it first thing tomorrow morning. Too much other stuff going on these last few days. But I do need to get this project finished as I'll...
  6. B

    Having some subform fields auto fill from mainform fields

    Are these two things something that should always be done when using Access? (Just in case I need to know it for the future. The church that I'm volunteering at has two other database projects that I'm working on along with this one. I just haven't been able to give them as much time, so they...
  7. B

    Having some subform fields auto fill from mainform fields

    I'll try this again! I seem to be having problems today!
  8. B

    Having some subform fields auto fill from mainform fields

    Okay, here is a copy of the most current version I'm working on. Question: should I add another table that will draw together the [RecipID], [HeadOfHouse] and [MemInd]? The way I have it now causes errors when trying to add or edit a record to either table. Error states that a record is required...
  9. B

    Having some subform fields auto fill from mainform fields

    Hi, RG! Thanks for defining hth for me. I will post another copy of the database in a bit. I'm a little bullheaded and just have to keep dogging it for a while longer before I give up. In addition to this issue, I have some query questions too that will probably be easier to answer if you can...
  10. B

    Having some subform fields auto fill from mainform fields

    RuralGuy, I'm working on this, but after several hours of hitting my head against the laptop, I'm not sure it's within my ability. I've removed the HH fields from the HouseholdInfo table and replaced them with a single HeadOfHouse field. I've tried linking the HouseholdInfo table and the [Names...
  11. B

    how can i tab off to another textbox?

    Okay, will do. Thanks!
  12. B

    Having some subform fields auto fill from mainform fields

    Okay, help me break the mindset that I'm in. Since the [MemInd] is unique for each member of the household, how do I structure the [Names of Household Members] table so that only the HeadOfHouse [MemInd] value is passed to the [Household Info] table? Won't it try to pass each members' [MemInd]...
  13. B

    how can i tab off to another textbox?

    Ouch! Well, I tried to explain to the food bank volunteers that my skills were entry level at best, but you know that old saying about beggars not getting to choose. Go ahead, as gently as you can, tear it apart. I'll do my best to keep my ego out of the way. :o
  14. B

    Having some subform fields auto fill from mainform fields

    I'm going to think about this over the weekend; I'm too befuddled right now and I gotta go. Thanks!
  15. B

    how can i tab off to another textbox?

    AAAHHHHHH!!! Okay, so I'll wear the dunce cap for the rest of the day! Thanks so much for your help. That's the biggest frustration in doing this solo project, not having another readily available pair of eyes to take a look at what I'm doing.
  16. B

    how can i tab off to another textbox?

    I'm setting this in the LostFocus event of the last control on the first subform? If so, it still throws the same run-time error as before.
  17. B

    how can i tab off to another textbox?

    It displays the same name as in the Household Members subform MemLstName field.
  18. B

    Having some subform fields auto fill from mainform fields

    Sorry, I should have told you this was Access 2000
  19. B

    Having some subform fields auto fill from mainform fields

    I know you are right about that. And believe me the Head of Household's name and DOB went back and forth between the two tables several times. I finally decided to leave it in the Household Info table after reading some threads here. The advice was to include in one table all of the data that...
  20. B

    how can i tab off to another textbox?

    RG, I tried it this way but it still gives the same error. I even tried it with the bang out of the first line as well ... still the same error. Do I need to put the second line of code in an event in the subform control? Charlotte
Top Bottom