Search results

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

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

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

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

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

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

Hi, Sorry for the number of posts recently. I'm our department's data geek. The Rehab Department has several sub departments like PT, Cardiac, Wound, and Speech. I keep dept stats and productivity info on all of them in Excel with the spreadsheets located on 2 different network drives, in a...

Hello, I need to prepare my Excel spreadsheets to be imported to Access. The column headers look like this: DrName Site Discipline Month Year John Smith North unit PT July 2009 I need to ask Access...

I am brand spankin new to Access so I appreciate your help (and your understanding). I don't mean to be long winded but I don't know how else to explain this. Example: 4 tables: Books, Category, Publishers, and Author. Building the Books table it was suggested to use the OrdersID...

Hello, I'm brand new to this forum and brand new to Access. Please be gentle :). If I am posting incorrectly please let me know. I gather stats & productivity info for a PT department in a hospital. We also have 4 offsite treatment centers. I collect and store info in a number of Excel...