Recent content by Carey27

Thanks will play around with it this afternoon

Rookie thanks for the help but I think two of the queries would not give me what I need. I think this would give me the oldest lab test and not just the one closest to the date they started therapy. I think a problem with this query would be that it would simply return the highest CD4 count...

Im trying to construct a query for my clinic that lists the patients who's HIV medication is failing. Once upon a time I was serviceable at programing but I have no clue how to do this... Any help would be very much appreciated The two WHO criteria we need to apply to the query are: 1) The...

Got it working... Created a form from scratch using the wizard which tied it to the Lab table. Thanks for pointing me in the right direction

Im using Access 2007 and had the option using for other forms. Not sure whats happening now. Ive checked Linqs Form properties and tried making forms from scratch to reset any other properties I might have changed...

Missinglinq Thanks for the help. Ive used that for all but forms, but tonight i was trying to add a combo box for the same reason and the wizard no longer gave me the 3rd option. Do you know why this might be?

Thanks that would be great. I tried googling it but might not have worded my search correctly...

Im working on a database for a clinic this summer. I've created a form to input patient data and it is working well. I now need a mechanism for the admins to update existing patient info. What I would like is for access to prompt the admin for the patient number (similar to a data dependent...

Thanks guys, its running smoothly now (Amazing how quick you replied). Kind of embarrassed how simple that was, but glad MS had it wrong on their site. Thanks again.

Im working at a non-profit clinic for the summer and have been tasked with updating their DB. Years ago i worked with access and have been able to build the tables, queries, forms, switchboards etc... but have been running into problems adding bells and whistles that require VBA. I followed...