Search results

  1. thtadthtshldntbe

    Metallica on Stern Show

    you know normally don't pick internet fights but I am bored. so you lost interest over Metallica fighting against Napster, a band of fucking corporate thieves. People bitch corporations doing heinous shit except I guess its ok for corporations to steal from musicians... I remember my cousin...
  2. thtadthtshldntbe

    Does anyone listen to heavy metal/death metal anymore?

    Has a thrash semi punk with less melody feel...i agree the lyrics are not great but they are still good and work with the feel of the song. If this is indicative of how the whole album will sound, we will probably get a couple of gems on this album.
  3. thtadthtshldntbe

    Ausdom M05 Microphone issues

    So I finally replaced my 7 year old logitech headset. I decided to go wireless and this one had good reviews. The problem that I am having is with the microphone. On Vent (or other communications programs) people tell me they can't hear me half the time. When I hit "listen to" on my own PC...
  4. thtadthtshldntbe

    Mike Tyson vs Bruce Lee

    Neither Lee nor Tyson are getting sucker punch in at the start of a fight. Both are trained fighters. The odds of sucker punching anyone who trains regularly in fighting are extremely small.
  5. thtadthtshldntbe

    Mike Tyson vs Bruce Lee

    what training does Tyson have to know how to do that?
  6. thtadthtshldntbe

    Mike Tyson vs Bruce Lee

    Mike Tyson is not a MMA fighter. Pretty much any UFC fighter and I mean any of them, even bantam weights would beat him in a MMA or streetfight. When did Mike Tyson learn how to defend against kicks and take downs? I'll keep answering ...he didn't... Mike Tyson is on record (I believe its in...
  7. thtadthtshldntbe

    Mike Tyson vs Bruce Lee

    you don't need superhuman kicking speed to kick out Mike Tyson's knee. Any blackbelt level practitioner of muay thai or most karate variants or many kung fu variants will be able to do so. Boxers/boxing exists with the presumption that one will never get kicked and that things like knees will...
  8. thtadthtshldntbe

    Mike Tyson vs Bruce Lee

    I'm going to keep asking this question... what is Mike Tyson going to do when Lee destroys his knee 3 seconds into the fight?
  9. thtadthtshldntbe

    Mike Tyson vs Bruce Lee

    Chuck vs Bruce is irrelevant. Chuck would wreck Tyson for the same reason that Bruce would....Tyson has no training to defend against kicks, takedowns and attacks below the waist. Or things like getting chain kneed in a clinch or elbowed in the temple, etc.
  10. thtadthtshldntbe

    Mike Tyson vs Bruce Lee

    The issue here is that Tyson has 0 training against defending his lower body against kicks or preventing take downs. Even Mike Tyson has said that boxer could only win against a MMA fighter if the boxer trains MMA. Boxers fighting style is predicated on not getting kicked in the legs, the...
  11. thtadthtshldntbe

    nuke it from orbit!

    god made Australia to train the faithful
  12. thtadthtshldntbe

    Hot to upgrade 7 bay NAS to larger discs while keeping the data

    buy a new 7disc NAS enclosure for your new hdds. Transfer material after new array is built sell old enclosure and possibly hdds in it, after cleaning your data out, on ebay or donate it to charity for possible write off. -----------
  13. thtadthtshldntbe

    Remote Desktop Connection Issue

    that's what we thought originally, so we tried remote rebooting the machine as well. The sleep thing seemed to have solved it though.
  14. thtadthtshldntbe

    Remote Desktop Connection Issue

    this seems to have been the issue. ty.
  15. thtadthtshldntbe

    Remote Desktop Connection Issue

    log out causes the samething issue. I will try the reboot option though.
  16. thtadthtshldntbe

    Remote Desktop Connection Issue

    well. its instantaneous. Like as soon as I log off or disconnect, I cannot reconnect. And I did not have this issue with the older XP machine. I will check on the power settings though.
  17. thtadthtshldntbe

    Remote Desktop Connection Issue

    So corporate IT finally upgrades my work desktop to a modern machine with Win 7. However I seem to have one problem. When I remote in, the first time it goes ok. However when I disconnect or log out, in either case I can no longer connect to my work desktop remotely again. Usually I...
  18. thtadthtshldntbe

    Access Chart in a Report with 2 series

    thanks. Yeah, I am stuck doing this in 2007 at work. Hopefully with the merger we will get the rest of the companies 2010. Anyway, I figured out how to get the dataset that I want, I can do either monthly or overall (the whole range of data queried) averages. I went with an overall and will...
  19. thtadthtshldntbe

    Access Chart in a Report with 2 series

    unfortunately due to my corporate merger I cannot post a sample database. Yeah, I can effortlessly break the security and better than 95% they would never know it. But I am not breaking my ethically obligations in that regard. Let me try to explain it a bit more clearly. I need to add a couple...
  20. thtadthtshldntbe

    Access Chart in a Report with 2 series

    Hello, Background - The access database referenced in here contains aggregate data from the EMR that we use in our OB/GYN division. I can't post a blank with sample data any more due to more restrictive policies and practices at my company since our recent merger. The main table in this...
  21. thtadthtshldntbe

    96GB of writes, 8 hours use of new SSD.

    dont do all the updates at once
  22. thtadthtshldntbe

    Math question - plotting a line

    to plot (5,5) to (100,100) you have all you need. Just fill in those points on a piece of graph paper, get a straight edge and draw a line through points. mathematically, you see the y=mx+b? well with those two coordinates you have (5,5) to (100,100) (X1,Y1) and (X2,Y2) M=...
  23. thtadthtshldntbe

    Burned 4 bulbs in a day. I'm guessing heat? Are LED or CFL better?

    wiggling at best, would make the problem worse. If you are capable of electrical work, then pull it down and look at the actual wiring. Something could be fraying inside the fixture or the walls, or a mouse could have chewed through the wire insulation.
  24. thtadthtshldntbe

    Burned 4 bulbs in a day. I'm guessing heat? Are LED or CFL better?

    you may have developed a short in that fixture or in that circuit (mice chewing on wires for example). Get it checked out.
  25. thtadthtshldntbe

    Al Bundy has black belt in BJJ from Rorion Gracie??

    this is the video where I found this out https://www.youtube.com/watch?v=tSSt5OQ4zHc apparently he has known Rorion and his kids a long time.
  26. thtadthtshldntbe

    access help- query between 2 tables

    well its an access database, i would not be surprised if Gdocs database program were to open it. switch works like Select/Case from say VBA does. Switch (condition,outcome if condition true, condition, outcome if condition ture,etc,etc) the advantage of switch, as opposed to say iif, is that...
  27. thtadthtshldntbe

    access help- query between 2 tables

    well even underlying access reports is a data source query. I usually try to figure out the underlying query by itself first. I am just kind of stumped on this one. here is a scrubbed copy of the database https://drive.google.com/file/d/0B7T2xcfjh34kN0QxVjI5YUE2eUk/view?usp=sharing I have put...
  28. thtadthtshldntbe

    access help- query between 2 tables

    I know that, doing a data comparison was my next step. I just did a quick update before work to this thread. What threw me for a loop is the access report leaving blank spaces for those records that my conditionals excluded
  29. thtadthtshldntbe

    access help- query between 2 tables

    sorry, I am fairly certain that you know more about this than I do. None of those fields are unique in and of themselves. Take tblTriageVisit a patient may come in for 3 or 4 triage visits in one day (sometimes triage visits are less than 30 minutes). So her patient id number will show up...
  30. thtadthtshldntbe

    access help- query between 2 tables

    Procedurally no, meaning from the point of view of patient process, within the maternal childhealth (my division) a patient cannot have another admit date before the discharge date (yes in the whole medical organization a patient can have multiple accounts open, but that is not a case here)...
  31. thtadthtshldntbe

    access help- query between 2 tables

    I was thinking about this some more... What I seem to want to do is Call up a patients visit from tblTriageVisit then look in tblTriageProcedures and find all the procedures done whose date falls between the Admission and Discharge dates for that given patient. What I can do already is fine...
  32. thtadthtshldntbe

    access help- query between 2 tables

    Actually, originally the primary key for each table was tbltriagevisits = patient id + admission date time + unique visit record tblTriageProcedures = patientid + display datetime + uniquevisitrecord but then I realized that broke the mechanism by which I built the database to eliminate...
  33. thtadthtshldntbe

    access help- query between 2 tables

    So I created this new database to import and record records from our triage patients in access. It has 2 tables, based on how the data is stored in the EMR. tblTriageVisits and tblTriageProcedures tblTriageVisits has the following fields -Patient ID -Export Time -Display DateTime -PT Name...
  34. thtadthtshldntbe

    Access Query Issue

    first of all thanks for your help. For now I deleted all the other calculated fields, just to get the point of testing. And then it worked. The only thing I had to change was the results if true and false. You had 0,1 and that returned 0 for those patients to be included. Once I switched...
  35. thtadthtshldntbe

    Access Query Issue

    note as an aside I am trying to work this out in VBA. I kind of remember the basics, declaring procedures, passing values into and out of the functions, etc. What is flumoxxing me is the referencing of the database. I think that I did that correctly Option Compare Database Option Explicit...
  36. thtadthtshldntbe

    Access Query Issue

    I'm getting "the specified field '[csection, primary indication] could refer to more than one table listed in the FROMclause of your SQL statement the SQL statement is SELECT LDExport.[Patient ID], [Delivery Doctor Long].[Delivery Doctor Long], LDExport.[Infant Delivery Date, Baby B...
  37. thtadthtshldntbe

    Access Query Issue

    One would think that MS would just include that in the documentation, but they don't for IIF as well. Its like they are trying to make people guess at the limitations on their crap. So my options are either go to VBA code and create a function or break up the exclusions into 2 separate...
  38. thtadthtshldntbe

    Access Query Issue

    When I copy paste DelwExcl: CInt (Switch ((Not IsNull([Infant Delivery Date, Baby B DateTime])),0, [Gestational Age at Deliv Baby A]<37,0, [CSection Incidence]="Repeat",0, [CSection, Primary Indication]="tvrsCmpl",0, [CSection, Primary Indication]="Macro",0, [CSection, Primary...
  39. thtadthtshldntbe

    Access Query Issue

    The query with the additions like I posted in this thread? I can't actually put them in it because access won't update the property due to the "too complex to evaluate error". Hmm, I have 2013 at home here and there is no patient data. (I can't bring the patient data home. Maybe I'll bring my...
  40. thtadthtshldntbe

    Access Query Issue

    I have commented out most of the statements in the startup procedure, the only thing it will do automatically is load the canned reports form, just exit it. https://drive.google.com/file/d/0B7T2xcfjh34kbk5qa0RIM2RDYUE/view?usp=sharing Caveat 1 - I am not a database engineer perse, just someone...