Search results

  1. K

    Using >= in cell as part of formula

    Probably right about better / worse but the slider is a. used to put a value in a field then it spawns values in several other fields which makes it a tad better than typing all the values in and, b. kind of sucks the user in watching a graph dynamically change as you slide it up and down... :)
  2. K

    Using >= in cell as part of formula

    I'll try that - thanks Edit = actually got it to work this way as well: =">="&M2 where I adjust the val in m2
  3. K

    Using >= in cell as part of formula

    Hi all, long time since I've been here. Anyway, I have a countif() where the if refs a cell that contains <=250. It all works but now I would like to make the 250 dynamic, like maybe it comes from a slider bar, etc. Any suggestions? Here is the countif()...
  4. K

    Create sql server table

    I will give it a look - thanks!
  5. K

    Create sql server table

    Wow - Thanks for both replies. I will see if I can get SSMS first!
  6. K

    Create sql server table

    Hi all, We just got access to sql server database and I need to know the best way to create tables in it. Is it easy in ms access? we have an older version of access, 2010 I think. I can connect to it and see all the system tables but for the life of me can't figure out how to create tables...
  7. K

    Groundhog Day

    According to the wiki it has roots in German tradition, so maybe just leveraged by Hollywood to make money :)
  8. K

    The Crown

    We saw The Darkest Hour as well - thought is was real good!
  9. K

    The Crown

    Did churchhills sec'ty really get hit by a bus and it changed his opinion?
  10. K

    Update formula

    Thanks - Yes that is what I plan to do. I will tinker with the code - Thanks!
  11. K

    The Crown

    Hi all, Watched a couple episode of the Crown. Just curious how factual it is if anyone happens to have seen it. The 1950's fog episode was pretty dramatic and something that missed our history books, go figure...(or maybe I was asleep again...)
  12. K

    Update formula

    Greetings, Been a while since I've logged in.. Anyway, I have a spreadsheet with many cells that have formulas and part of the formula is the number 1000. This is used as a multiplier in the formula and I need to change all of them to 10,000. I thought I could do this with the replace tool. It...
  13. K

    System.mdw missing

    Thanks Doc - I'll give that a try.
  14. K

    System.mdw missing

    It won't let me even create a blank database now... ugh. I'm stuck. A second dialog pops up saying to quit the ole server. I can't find out how to do that ....
  15. K

    System.mdw missing

    Thanks - I'll give them a try. I am trying to do this on a imac/VMware...
  16. K

    System.mdw missing

    Hi all - long time :) I am trying to open an accdb on a new Win10 install and it says it can't find the system.mdw. I've tried everything I can think of and can't get past this. Anyone have any suggestions?
  17. K

    Is a subform Control not a subform control if...

    You may have to test to determine which subform is active before you refer to controls on it.
  18. K

    Best practice for running reports from a form?

    You can create a linked config type table that would flag which reports are active etc.
  19. K

    What is wrong with most people?

    . . . Golden :p
  20. K

    Validate Form Date only for Current Year

    Cool thing is now that you have in it in a module you can create a table for configuration data like this and if you need to change the date parameters all you have to do is change the value in the table and not have to poke around in code. You go from a hard coded parameter to a dynamic one...
Top Bottom