Search results

Thanks for the advice ...I'll do forms. Thanks to everyone for the help and especially namliam for hanging in there with me...

Sorry, I didn't ask that question very well. The other queries I needed are working with popups asking the user for between 1 and 3 drug names inclusive, utilizing the WHERE clause. Can I adapt your code to have user popups??? Maybe adapting the HAVING or should I be looking at a dialog...

Hi namliam Still no go with only the added brackets....but it does run with this change to INNER JOIN... Thank You! SELECT tblPatients.FirstName, tblPatients.LastName, tblPatients.City FROM tblPatients INNER JOIN (tblMedications INNER JOIN tblPatientMedications ON tblMedications.Med_ID =...

Thanks jdraw for the pointers...I'm doing some learning. namliam, thank you very much for laying that code out for me. I would have struggled for a long time. I'm working at it but I am getting a syntax error (missing operator)with both the join and count method...I'll get it, but if you have a...

Thanks to David. Namiliam and jdraw. It looks like the dialog form is the way to go and thanks again to jdraw for the link to the tutorial. I need to start by creating the queries. The SQL I tried in my first post returns nothing. How do I correct that so I can find only patients who are on...

I am an Access Beginner, I have a medications database based on 3 tables...tblPatients, tblPatientMedications and tblMedications. I can query for patients using a single medication. I need to query for patients who use: 1. both MedA AND MedB 2. both MedA AND MedB but NOT MedC 3.MedA OR MedB but...

Thank You vbaInet for willing to take a look. Thank You Galaxiom for the answer I was looking for, that works perfectly! Adding the concept behind the code helped me even more! Thanks Again

I will, Thank You

Thanks for stepping in. The Patient_ID field still does not populate with the ID from the current form. Maybe a BeforeInsert? If I enter the Patient_ID manually works perfect. Here's how it behaves: Thanks Again

Thanks Galaxiom, I used the code below and the Patient_ID field populates with the correct ID and the ProtPat_ID is at autonumber, but when I pick a choice from the combobox The autonunber reverts to the last record for that patient and overwrites the fields for that record...what am I...

I have simple form (2 fields and a combobox) bound to a single table. The form needs to open with the Patient_ID taken from the current main form and the ProtPat_ID at autonumber. It works now with one hiccup, the form opens with ProtPat_ID at autonumber but with an empty Patient_ID field. If I...

Thanks RuralGuy, I am fairly new to Access... could you elaborate a bit? Do you mean that I or the user would need to enter the new Patient_ID manually with this form/subform arrangement because they are linked by Protocol_ID? Or do I need to change the design of the query so that Patient_ID...

Subform Autonumber doesn’t update many side table I’ve got an Access form (ProtocolPatients) containing a continous subform based on a 3 table many to many relationship query. With a comboBox in the main form, I select a protocol number and the subform populates with the patients for that...

I'm trying to figure out why when I create a new record in my main form the autonumber doesn't update in the subform. I created a quickie test DB (dbBWorks) because I couldn't believe it wasn't working, and sure enuf it worked and updates as expected but I would really like to know why my...

I have a tab control with 2 tabs. I start a new record and the autonumber gives me a new number. I switch to tab2 only "autonumber" shows where the new ID should be in both the header and subform. The kicker is with existing data everything works as it should. Thanks

I have a medical database setup with a form including a tab control with two tabs…patients and medications/conditions. The patients tab holds a single form. The medications/conditions tab holds two individual continuous subforms by query for medications and conditions. This is working perfectly...