Search results

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

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

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

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...

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

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...

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...

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...

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...

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...

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

Anyone? I could use some guidance.

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...

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

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...

Glaxiom, I have tried that with no success. I'm still exploring other options. Thanks for your reply, Don

I'm very new to Access so please bear with me. My report is asking for the number of doctor referrals by site from 1/1/09 thru 7/31/09. I'm using Site, Som of RefNo, and RefDate. It displays as Site1, 7 dates (one for each month) with the total # of referrals for each month. What I wold like...

Bob, I appreciate your reply. But I'm still stumped as to how I prepare my tables to be imported. Do I use the ID's from the other tables in the DrRef table, or do I use the actual text? Thanks, Don

Hello all, I’m not sure how to handle the import process. I want to take all data in my Excel spreadsheets and create an Access database so I will be doing a lot of importing. The question doesn’t concern the import process but does concern table structure. In the process of preparing &...

Thank you again, Galaxiom, :) In the interest of brevity I left out the details. The doctor referral "database" I keep in Excel is already separated into Access like design. The data entry sheet is like I described earlier. But I have separate lists for specialties, doctor name and info...