Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tweaked2005

    Search String

    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!
  2. tweaked2005

    Retain and First.var

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

    Retain and First.var

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

    Looking at similarity across rows

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

    MS Excel - Counting on Cell Color

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

    MS Excel - Counting on Cell Color

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

    MS Excel - Counting on Cell Color

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

    Count based on cell color in MS Excel

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

    Change values in a table

    Thank you so much!! That worked!
  10. tweaked2005

    Change values in a table

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

    Easy question, but I'm brain dead - looping through records

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

    data step option index=

    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;
  13. tweaked2005

    MS Project Question

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

    Randomly Match 2 lists of names

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

    Randomly Match 2 lists of names

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

    PROC MEAN

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

    Same old problem: Multiple Combo Boxes

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

    Same old problem: Multiple Combo Boxes

    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! :)
  19. tweaked2005

    Same old problem: Multiple Combo Boxes

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

    Same old problem: Multiple Combo Boxes

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

Part and Inventory Search

Back
Top