Search results

Not so good. I haven't figured it out and have just left it with what I have. I can upload what I have as soon as am back at computer with program. I appreciate the help!

Okay I am sorry, I did what you suggested and I only get all tests based on criteria or no tests based on criteria. I changed around the joins, I added fields in all the ways the things says to do it. I can't figure this out and maybe it is not possible with the tables I am using. I saw how it...

Okay I feel like a complete idiot here! I have followed the link JHB gave and it makes sense but it returns no records on unmatched or records of categories I don't care for. So must be doing something wrong. SELECT T_TestSchedule.ILLNESSID, T_TestSchedule.TESTID, T_TestSchedule.FREQUENCY...

Okay i have uploaded some photo that might help on seeing what I am working with.

Thanks for answering. I am currently reading the article and trying to do the steps on the unmatched query. On JB's questions. I may have set it up wrong but the program is made for the medical individual to do the tracking and they are the one that gets alerts on tests that are overdue, about...

Hello! no I still can't figure it the &%$#@ out! I am basically trying to figure out how to append a list of Tests that need to be done by Age/Gender and if the tests already exist it just appends the needed ones. I can only figure out how to delete all tests and append new ones and can't figure...

Hello, I have been working on my free time helping a friend build a tracking data base for some medical tracking of her staff. I have basically wrapped it up but when I thought I was done I realized a couple things that will cause a problem in the future. I have attached a stripped down...

Hello I have figured out how to use the Northwind Data base's SALES REPORT DIALOG form to print cross tab reports. Everything is working fine but now I would like to know if there is some way to add another combobox to filter down the information by Organization or just have all peoples record...

Thanks for all your answers. On JHB's response do you mean the section under DATA on "Record Locks" being set to "edited Record" instead of "Unlocked Record"? I don't quite understand all the differences between these. I have fixed the form another way but would like to get this figured out...

Okay the error message I am getting is "runtime error you can’t assign a value to this object." Yes I have made sure the control name is the one I am referencing and have even changed all the control names for the the subform combobox [Priority] to another control box name as well as the main...

The error message is run time error "2448" and highlights the following text: Me.EmployeeSubform.Form!Priority.Value = "A - Urgent" or any of the ones like this when the combo box on main form (ILLNESSID) selects one of those. The combo box on the subform is [Priority] Thanks

Hello, I was doing fine on my form creation but now I am getting the error message of runt time error 2448. It worked totally fine on another form but now on a new form it is no longer working and giving me this error. What I am trying to do is after a Combobox is changed and if a specific...

Smoking - thanks, that worked.

I have the following code that works fine: Dim db As DAO.Database Dim rs As DAO.Recordset, i As Integer, ii As Integer Set db = CurrentDb Set rs = db.OpenRecordset("PatientPrescriptions1") ii = [RefillAmount] For i = 2 To ii rs.AddNew rs("PatientID") = [PatientID]...

Thanks for your answer. I will check this out. I also figured out 3/4th of what I was trying to do by following someon elses examples. But what you say makes sense. Thanks.

Hello, I have been asked to help create a access data base (using 2007) on tracking patients medical tests that then alerts you when it is overdue set against a scale: Physical Test - age 20-39 - every 3 years - Male and Female Physical Test - age 40-49 - every 2 years - Male and Female...