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!

  • Congratulations TouchToneTommy 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. mbasimon

    Can MS Excel SOLVER use the LOOKUP function?

    Not sure I understand the question, but $L$3 is the "Set Target Cell" and $K$3 is the "By Changing Cells". Is that what you were looking for?
  2. mbasimon

    Can MS Excel SOLVER use the LOOKUP function?

    Yes, the value in L3 changes when I enter a different value in K3.
  3. mbasimon

    Can MS Excel SOLVER use the LOOKUP function?

    Hopefully this answers your question: I'm trying to maximize the value of L3 by changing the value in K3. L3 takes K3, looks that up in A6-A12 and retrieves the value from L6-L12. Columns B-K (rows 6-12)contains various values (non-linear), Cell L6 contains K6*E6, cells L7-12 is the same...
  4. mbasimon

    Can MS Excel SOLVER use the LOOKUP function?

    Hi, I'm having trouble getting SOLVER to work with a LOOKUP function. My Target cell is L3, which contains "=LOOKUP(K3,A6:A12,L6:L12)" My Changing cell is K3 There are no contraints Cells A6-A12 contain the digits 1 through 7 Cells L6-L12 contain some calculated values, but it fails even if...
  5. mbasimon

    How do you call an Oracle stored procedure that returns parameters?

    I've been trying ADODB but I can't get it to work. Do you have a working sample/snippet that you could paste? Thanks.
  6. mbasimon

    How do you call an Oracle stored procedure that returns parameters?

    I'm using VBScript. I need to call an Oracle stored procedure which accepts parameters and also returns parameters. I can't find anything useful when I search on the web, just wondering if anyone here knows how to do that and if they can give me a sample snippet that would be fantastic. For...
  7. mbasimon

    crystal 8.5 numbervar overflow???

    There's a variable reset in the group #1 header. The summation takes place in the group #2 footer. It adds the value of a database field to that variable.
  8. mbasimon

    crystal 8.5 numbervar overflow???

    I have a running total using a shared numbervar variable. However, once this number gets to about 1,000,000, it stops acting normal. For example, in this one report, the first 20 or so additions are fine. The number will get to 978,664. If I add 63,327, it now shows 1,041,991. So far so...
  9. mbasimon

    Any heard of something called bulk_netwhiz?

    Actually I did - when I thought it was called "bulk_netwhiz"! And then not till AFTER I posted my correction, my apologies.
  10. mbasimon

    Any heard of something called bulk_netwhiz?

    sorry, my mistake. it's Bonk nestea, not bulk netwhiz.
  11. mbasimon

    Any heard of something called bulk_netwhiz?

    Our security folk have found that bulk_netwhiz has infected one of our servers. Anyone know what this is?
  12. mbasimon

    No Power At ALL?

    I figured out the Power problem. I disconnected all the devices from the power, and it powered up fine. So I started plugging in devices one by one, and it failed once I plugged in the floppy drive. I guess something is either wrong with the connector or the plug or something. I still get...
  13. mbasimon

    No Power At ALL??

    I figured out the Power problem. I disconnected all the devices from the power, and it powered up fine. So I started plugging in devices one by one, and it failed once I plugged in the floppy drive. I guess something is either wrong with the connector or the plug or something. I still get...
  14. mbasimon

    No Power At ALL??

    Old machine, 3 yrs old. Was working perfectly for a long time, then it started intermittently re-booting itself. I removed a bunch of spyware etc., but it still rebooted itself periodically. So I tried to reinstall XP, but it wouldn't install properly (kept on failing on copying p3.sys, the...
  15. mbasimon

    No Power At ALL??

    I'm pretty sure I've got everything plugged in right, but no power is being supplied at all to my PC. I've tried replacing the power supply (with a 480W), but nothing, not even the fan on the power supply is turning. I've even plugged it into different outlets. I've also replaced the video...
  16. mbasimon

    No Power At ALL?

    I'm pretty sure I've got everything plugged in right, but no power is being supplied at all to my PC. I've tried replacing the power supply (with a 480W), but nothing, not even the fan on the power supply is turning. I've even plugged it into different outlets. Actually, correction, I guess...
  17. mbasimon

    Is this a Virus or just a corrupted registry?

    My registry was ok, it had the proper entry in it. I did copy the userinit file to wsaupdater though, but to no avail. To clarify, my symptoms are: I can NOT login with a certain administrator account I CAN login with a normal user account I then created another administrator account (I...
  18. mbasimon

    Is this a VIRUS or just a corrupted registry?

    When I log on to my XP Pro machine, the machine restarts whenever I use a certain userid (the one I normally use). However, if I use any of the other accounts that I've set up, I can log in just fine. I've been have some trouble with this machine, and was about to wipe it clean anyway, but...
  19. mbasimon

    Is this a Virus or just a corrupted registry?

    When I log on to my XP Pro machine, the machine restarts whenever I use a certain userid (the one I normally use). If I use any of the other accounts that I've set up, I can log in just fine. I've been have some trouble with this machine, and was about to wipe it clean anyway, but just...

Part and Inventory Search

Back
Top