Search results for query: *

I just want to thank everyone who contributed to this string. It helped me on a very similar issue. Just a reminder that this forum is beneficial to not only the original poster. Thanks all!

Yay! It worked. Thank you so much! I knew I was close.

I reviewed other post, and still can't seem to come up with a working solution. I have a dataset similar to below: id category 1 Fever 1 Headache 1 Nausea 1 Fever 2 Nausea 2 Accident 3 Fever 4 Accident I want to create a new variable: "conditions" that has a concatenated list...

I have a dataset with 5 variables (syndrome, patientClass, datatype, location, date). It is possible that multiple records can match on everything but date. So as an example: Dataset ======= Obs Syndrome PatientClass DataType Location Date 1 S1 Inpatient Pediatrics Hosp1...

I'm getting a Run-time error '438': "Object doesn't support this property or method" When I run the code you listed. I'll keep trying to fiddle with it. Thanks again for all of your help with this.

Forgive me for not knowing the answer to this. I've never coded VBA in Excel, only Access. I now have a macro called colorCount and the code looks like this Sub ColorCount() clrval=Cells(1,1).InteriorColorIndex If clrval=vbYellow Then Cells(2,2) = "yes" End Sub However, when I run the...

I'm trying to create a column, that is populated with "Yes" if the cell background color for a different column is "Yellow". So in other words if: If A1 Cell Color = Yellow, Then A2 = "Yes" Is there any way at all I can do this in MS Excel? Thanks in advance for any help.

I'm trying to create a column, that is populated with "Yes" if the cell background color for a different column is "Yellow". So in other words if: Format Cell Color A1 = Yellow, Then A2 = "Yes" Is there any way at all I can do this in MS Excel? Thanks in advance for any help.

Thank you so much!! That worked!

I'm using MS Access, and programming in VBA. I have a form, and want the code to run when I open the form, so I've created an event for on Open. I'm using the code below. Baseically, I want it to evaluate each record, and populate my comment field with "new" if the condition is true. This is...

So I'm trying to apply the following conditional code to each record in the dataset that is loading in my form. I know I need to loop through each record, but I can't remember the code necessary to do so (is it something like recordset.EOF). Any help on looping through records is greatly...

Does anyone have a good definition (without the word index in it) for what the the index= means in the dataset below. data new(index=var1); set old;run;

This might be a simple thing to do, but for the life of me I can't figure it out. I'm trying to schedule a task where someone might do a total of 8 hours of work over a 2 month period. For example, as mail comes in, they might spend 1 hour a week recording the mail, but this task needs to...

Thanks so much for the help. Any thoughts on how to still make sure indifferent could match up with other indifferents? Again - thanks for the logic help - super appreciated.

I'm stumped. I need to create a SAS program that randomly matches names for dinner. There are a few criteria to consider: There are 3 categories of folks, those that can go to dinner in groups of 3 only, can go to dinner in groups of 2 only, or are indifferent. The program needs to match folks...

If you are looking for even more thourough stat analysis, try proc univariate; run; just to see what you come up with. You can also generate a histogram out of that as well. proc univariate data=test cibasic(type=twosided alpha=.003)noprint; var dosage; class...

IT WORKED. YOU ARE AMAZING! wow, thank you guys SOOOO MUCH for you patience!

Both bound to 1 - customerID. The SQL for combo box 1 is: SELECT tblCustomers.customerId, tblCustomers.firstName FROM tblCustomers; Thanks for all your help so far. Its giving me hope! :)

Yes, I am Requerying my 2nd combo box in the "After_Update" event. Sigh.

So I apologize in advance. I know this question continually pops up, but I'm to the point of frustrated and have no idea what to try next. My problem seems simple, and I've read all the postings I could find about the issue, but nothing I seem to try works. Scenario: tblCustomers <customerID>...