Recent content by AbeA

Well, I believe I've discovered my Normalization issue, and now I have a new problem. In my "Patients" table, I have several duplicate names listed. Since this table has relationships with three other tables in my database, each patient record in my Patients table has a plus sign next to it that...

Correct, this: SELECT DISTINCT Patients.FullName FROM Patients ORDER BY Patients.FullName; Doesn't show dupes, and it lists correctly, only in Datasheet view in the Query Builder, not in the form (it displays blank entries). Yes, A lot of the dupe full name fields have distinct ID's. So, it...

I've got a combo box that lists duplicates. I want the dupes removed. I went to the Query Builder for my Combo Box and set Unique Values from "No" to "Yes" - Saved, then re-opened the form. It still lists dupes. I went back into Query Builder and unchecked the box for the Patient_ID...

Thanks again JHB. I got it working. I had to add/ click and drag the "*",( the first entry) for each table in Design View of my Main Query.

OK, I've figured out the reason why it wasn't sorting by two columns in my query. I had to add "rx date" in twice, uncheck the visibility, then sort by "descending" and it displayed correctly. The two issues remain: 1:"Cannot add record(s): join key of table 'Prescriptions' not in record set"...

Awesome JHB, Thank you. I was able to get it listed in the Form the way I wanted, with help from you guys, again, thanks. One more problem: I cannot add a new prescription for a patient on my main form (screenshot below). I can input data in the "Drug" column, but when I attempt to type...

OK, I attempted to do what you said, and I'm getting close here. I added the patient list form as a tabular form. I then I created a Query that filters by patient name and by medication, then added this query as a subform on my patient form. But unfortunately, what I am getting now is a single...

I work at a small mental health clinic and am trying to accomplish the following. Access skills a little rusty, it's been a while. What I have: I have one table that lists all of the patients, their phone number, address, etc. In another table, it lists the medications that each patient takes...

Thanks, bob. But, I'm still confused. I created the query, and now my report is showing the patient and drug name, however they do not match with the patient and drug ID fields. For instance, the first row shows a patient ID of 12 (lets say the correct name for patient ID #12 is John Smith -...

We have a database that was being used with a psychiatrist office program, but we aren't using the program anymore so we've stripped the database. We want to create reports with it. The database has three tables: Drugs, Prescriptions, and Patients. Drugs has two columns: drug_id and drug_name...

Hello, I have a table that contains a bunch of records, the fields are Employee ID, Task, Date and Vehicle. All I need to do is create a report that will list all records correlated with only a single employee. For instance, when I open the report, it asks for the Employee ID, you enter it...

Thanks Ken and Bob. Ken, I put in your code and it only lists the first "time" field (not the total of all fields) in the report. e.g. the report lists all time fields "3:20, 3:40, 5:40, etc) when I add the totaltime field to the report it only lists the first one, (3:20).. If I set the...

I'm trying to enter the FormatDateTime code in my query but it keeps putting the vbShortTime in brackets: TotalTime: FormatDateTime([Time],[vbShortTime])

this should be an easy one. Not sure why I can't figure this out. I have one table, Leopard Test Scores 2007, that has only two fields, employee and total. The total column has a "Date/Time" data type with a short time format. All entries in the total are in the "mm:ss" format, e.g. 03:23...

Thanks for the reply. That will work, but the subform looks a little messy (there's another record progress set of buttons at the bottom, scroll bar and whatnot)... isn't there a way to set it up so that when a user inputs all info and goes to the next record to set up the next task, access...