Recent content by Toolman

  1. T

    Moving from command button in main form to subform

    Thanks very much RuralGuy! It works great. I really appreciate the help. Don
  2. T

    Moving from command button in main form to subform

    One line of code: DoCmd.OpenForm "ParentF", , , , acFormAdd Don
  3. T

    Moving from command button in main form to subform

    Sorry RuralGuy, No disrespect intended. I simply don't know what you mean by "behind the OpenParentbtn button". it opens the ParentF form. I used the on click event to open the form to acAddNew. Beyond that I'm not sure what you mean? Don
  4. T

    Moving from command button in main form to subform

    This has all stemmed fom trying to find a solution to a many-to-many problem. I undestand the need for a juction table and how to set it up. But what I struggled with was an easy method to populate the junction table. I found an example and modified it slightly. I have children that are on...
  5. T

    Moving from command button in main form to subform

    RuralGuy, Thank you. But I don't know where to use this code. Sorry, I'm very new. I've tried using this in the ParentF's OnClose event, but its my guess it doesn't work because PatientF doesn't yet have focus. Could you give me an idea on where to use this code? Many thanks, Don
  6. T

    Moving from command button in main form to subform

    Hello, I have a PatientF, with a SubFormF. PatientF has several fields to enter info about the patient. The last item in PatientF is a command button (OpenParentbtn). This button opens the ParentF to enter the parent information. When ParentF closes. OpenParentbtn has focus. From this...
  7. T

    Many-to-Many relationship?

    I beg for help one last time. I built a test db per spikepl's specs. I set up the relationships as recommended. I added 6 fake patients to PatientT, and 12 fake parents to ParentsT. But I have a data entry problem now. How do I populate the junction table RelationsT? Or rather the db...
  8. T

    Many-to-Many relationship?

    Thank you for your quick reply! Sorry to be a dummy, but how do I set up the relationships? I think it might be: PatientT.PatientID to RelationT.PatientID ParentT.ParentID to RelationT.ParentID RelationsTypeT.RelationsTypeID to...
  9. T

    Many-to-Many relationship?

    Hello, A little background: I started to build a database for children in our speech department. I built a PatientT, with PatientID, Lastname. Firstname, (and other stuff). I built a RelationshipT, with RelationshipID, Relationship. The idea being we have to notify the parents, and...
  10. T

    Query criteria using dates

    Hello, I have a table that I record all doctor referrals each month. All dates are entered as the 1st of each month. EG the first week of October I entered all the referrals for September, and they were all given the referral date (RefDate) of 9/1/09. I want to run a query that asks for...
  11. T

    Entering data in multple tables

    Larry, I think I've stumbled on to something. I'm going to explore it a bit more before I put the fake db together. But I thank you very much for weighing in. Don
  12. T

    Entering data in multple tables

    Anyone? I could use some guidance.
  13. T

    Entering data in multple tables

    As you'll be able to tell from my question, I'm new. My attachment shows my tables and their relationships. The Referral table has ID's from the Site, Disciple, and Doctor tables. The Sites and Disciplines could see additions, but probably never will. But every month I have to add anywhere...
  14. T

    Append Query-Specific How to

    Sorry for taking so long to respond. Thank you. I will try to set this up.
  15. T

    Append Query-Specific How to

    Hello everyone, I'm very new to Access and I think I have to make a major change to a table. I have attached a pic of my relationships. I think I need to add the SpecialtyID field (Specialty table) to the Referrals table. I know to use an Append Query. But I'm unsure how. There are over 1000...
Top Bottom