Search results

I did try creating another query that uses the query that I made the measure list in and I still had the duplicates and it won't let me group by or select distinct.

I guess I can just make another database object and copy in what I have. I will do that.

I would love to, but it would take a while to get it all cleaned up to the point where I could post it with fake data. It is a really big database. I will try to do it soon. If any other thoughts come to your mind let me know. I will keep experimenting. Thank you!

I tried putting it in the function too, select distinct, but it still gives me the duplicates.

I tried that, but it seems to get hung up. I am waiting still and its been a few minutes with no results and no errors. The green bar that says running query is almost full, but nothing happens.

I do have one more question for you. :) It gives me the measure list for each encounter but it still duplicates. If there was going to be 3 instances of the encounter before with three separate measures it shows the encounter 3 times each time listed with the three separate measures as the...

I got it. I read more into that article and my primary key is actual a text and number mix value so I added the brackets and that solved my problem. MeasureList: ConcatRelated("[ActualSpecificVariance]","qry_VarianceMeasureTracking","[EncounterNbr] = """ & [EncounterNbr] & """")

No I did not :). I fixed that. Good to know! Okay so I put this in a query instead of a text box control source is that okay? I get an error 3061: too few parameters. Expected 1. I thought I was passing it in below. I didn't change anything in the function that was on your site...

Thank you! This is exactly what I need. I created the function in a module and compiled like you described and then I am using it in a query. MeasureList: ConcatRelated("ActualSpecificVariance","qry_VarianceMeasureTracking","EncounterNbr = " & [EncounterNbr]) I get an error Undefined...

Hello, I have a query that has a field called encounternbr. For each encounternbr multiple measures may be attached. Is there a way that I can return just one row for each encounternbr and have a new field called MeasureList for example that looks at each measure that was attached and just...

Thank you both for your response. So I definitely need to copy the converted code into an actual click event. That is good to know that autoexec runs before table links are checked. I am going to continue to rework it. The entire database needs rebuilding.

I have a database that is highly driven by macros. I have been working on rewriting the VBA where I know how. I ran the performance analyzer on a few macros and it said to use the convert to VB tool and I did that and it converted it to VB and I am not sure how to use the VB code for example...

Thank you this works perfect!

This is what I try using a combo box. I do not get any errors, but I do not get any results. I chose the option from the combo box that is #2 and it goes through the second IF statement, but it just refreshes the form to be blank when there should be rows. Any ideas? If...

Thank you I will try this out.

Is there a way to query a continous form while in form view from a drop down list? For example I have a field on the form called encounter status. The form includes a list of encounters each with their status. I want the user to be able to select a status from a drop down list at the top...

That linked worked perfectly. Thank you!

Thank you for the link. I just now got back in to look at it. I will test it out and see if I have any other questions that come up.

Hello, I have a list box with 5 separate facilities. I want to give the user the option to select just 1 or multiple facilities. The list box is on a form. There is a button on the form that opens a report that is tied to a query that takes the value from the list box...

Thank you for the information on how to write proper VB code. I do have it in the after update event and I switched my Is null to be in the front and the object required error went away when I did that and the field updates like it should now. I would like to understand the last part in...