Recent content by FrJonathan

  1. FrJonathan

    Catholic Priests Abuse - A Whole New Dimension

    I'm a little puzzled. What has any of this do to with MS Access? I joined this forum for an opportunity to discuss how to get Access to perform tasks, get some help solving problems with the software, and maybe give some help in return. Yes, the sexual exploitation of others is both criminal...
  2. FrJonathan

    Help with bookstore db

    Here's an example of the table organizations you're identifying in your attributes grid. Because each employee can have more than one certification, you'll put the certification data in a separate table, and create a foreign key field that you will use to connect it to a specific employee, by...
  3. FrJonathan

    Help with bookstore db

    @Pat Hartman, I'm pretty sure that D.J. said that the db that D.J. is working with just now is "the ZYX laboratories example," - just trying to learn the skills - not the db for D.J.'s bookstore. So of course it sounds like a school assignment. That doesn't contradict D.J.'s statement about the...
  4. FrJonathan

    Drawing data from combo box in subform

    Boy do I feel dumb. I've been trying to get the deceased patient's relationship to the next of kin into tblNextofKin, so that I could extract it to make a customized message on condolence mailers. E.g. "Dear Jenny, I was so sorry to hear of the death of your father, Bill." I just realized I...
  5. FrJonathan

    Drawing data from combo box in subform

    It took some doing to strip it down to a size that the forum would accept, but here it is. I also had to strip out all the Veterans and Next of Kin information due to privacy laws, so there's no personal information in the tables.
  6. FrJonathan

    Drawing data from combo box in subform

    @arnelgp, I think you have misunderstood me. "The SQL statement in the Record Source property is SELECT DISTINCT tbl_Input_Relat_Pt_NOK.Pt_is_to_NOK FROM tbl_Input_Relat_Pt_NOK WHERE (((tbl_Input_Relat_Pt_NOK.Pt_Sex)=Forms!frm_InputVets_2!Vet_Sex) And...
  7. FrJonathan

    Drawing data from combo box in subform

    I have a parent form, frm_InputVets2, with a child form, frm_InputNOK_2. The parent form is for entering data related to a deceased military Veteran. The child form is for entering data related to one or more next-of-kin of the Veteran. I also have a table, tbl_Input_Relat_Pt_NOK with four...
  8. FrJonathan

    Pleased to meet you! (Eugene, Oregon, USA)

    Hi, everyone. I'm very glad to have found this site. I've been muddling about with Access for a couple of years now. Still pretty new at it. Mostly I've been learning more about Access and refining/streamlining the same application the whole time! I'm a Priest in the Charismatic Episcopal...
Top Bottom