Recent content by kawai6rr

Thanks again for the replies, once I got the error to go away it started working, I was missing a parenthesis. YesPatOcc:IIf(Not IsNull([P0_Count]), "X", IIf(Not IsNull([P1_Count]), "X", IIf(Not IsNull([P2_Count]), "X", ""))) Thanks again!

I was able to get the first one figured out with your help where I checked for 3 values and if they're null then put X NoPatOcc: IIF (IsNull([P0_Count]), IIf(IsNull([P1_Count]), IIf(IsNull([P2_Count]), "X", " "))) This says that no occurrence was detected. Now I need to check for an...

Thanks for the responses with your input I was able to get it figured out. NoPatOcc: IIF (IsNull([P0_Count]), IIf(IsNull([P1_Count]), IIf(IsNull([P2_Count]), "X", " ")))

I have 3 separate field counts and if all 3 counts come up as NULL then it needs to be an X or else nothing. NoPatOcc: IsNull( [P0_Count] And IsNull( [P1_Count] And IsNull( [P2_Count], "X", "") wrong number of arguments?

This is a little embarrassing but for some reason the primary tables connection was lost once I reconnected it everything is working properly. Thanks for all the replies much appreciated.

I have a datagrid/list box that populates a few row/columns, one of which is a primary key “FacilityID”. When double clicking the a specific row a new form will open with that FacilityID assigned to it. This worked fine until I put a tab control on realizing I needed more. How do you reference...

I had it as an onDirty so this is where I was running into problems. I changed it to after update and this seemed to be the better way.

below I have some code that calculates the age from their brirth date. I keep getting the Invalid use of Null Error when I insert a DOB and the age is already dispalyed. Does anyone know how to correct this? Dim lngAge As Long Dim dteBirthdate As Date dteBirthdate = Me.DOB.Value If Not...

That worked great, thanks!!

I have this query where I'm trying to query everybody who's last visit was <= 90 days from todays date. SELECT DISTINCT memberInfo.MRN, memberInfo.Last, visits.LastSeen FROM memberInfo INNER JOIN visits ON memberInfo.MRN = visits.MRN WHERE (((visits.LastSeen)<=Date()-90)); but this does not...

you could use something like this if you knew the date of the escalation SELECT Glasgow, Number, date FROM what table is exists in WHERE date = 15/10/2010 syntax is missing but the idea is simple.

I’m trying to create a database to track melanomas. I need to split the excel sheet into a one-to-many relationship because one member can have multiple melanomas. Tables memberInfo ß---- one-to-many ------à melenama meberInfo structure Name Type Size id Long Integer4 MRN Long Integer4 Last...

I'm using access 2002

I've created a table that stores an image as an OLE Object. I go through the insert object wizard to create a link to this image. This works but the image shows up very small, how can I get it to show up in it's true size. I attached the original test image and a screen shot of the image as...

I have a list box that I'm filling with this sql statement. When the form loads I get a parameter value error that wants values for department and fppeDate. Does anyone know why? Me.OutPut.RowSource = "SELECT FPPE.LastName As [Last], FPPE.FirstName As [First], fppeSub.department As...