Search results

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...

This is doing the same thing as my original string Me!outputWindow.Form.RecordSource = "SELECT firstName, LastName, department, fppeID, fppeDate FROM FPPE WHERE fppeDate >= #" & Beginning & "# AND fppeDate <= #" & Ending & "# ORDER BY " & fppeDate I should have mentioned that the subform is...

Here’s my issue. I have a form with a subform. I’m trying to filter my subform with a button click and two text boxes on the main form. The two text boxes are the begin date and then end date which filter the subform based on the date in the subform. When I click the button it only shows the...

I actually figured it out, I was obvioulsy calling it incorreclty. Here's what ended up working, probably don't need to set up a separete sub procedure but this works. Forms![formQuery_MemberInfo]![hospAdmits]![hospAdmitsComments].SetFocus Call hideConditions

First off I have 3 tables: Table 1 has a one to many to table 2 and table 2 has a one to many to table 3. I have three forms, the main form that houses subform1 to table 2 and subform1 houses subform3 to table 3. Table 1 (formQuery_MemberInfo) One to many...

thanks you!!