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 Chriss Miller 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. euskadi

    values not passed (sometimes)

    Thanks! that solved the problem. I didn't think that would do it since I'm not submitting a form using 'post' to link to the page, but it works.
  2. euskadi

    values not passed (sometimes)

    I am doing this with mixed results: mydomain.com/dir/action.php?mode=new ---- I have two domains with the same hosting company, on one this works ($mode == 'new') and on the other it doesn't (isset($mode) == false). The pages are otherwise identical! Any clue as to why this is so???
    • euskadi
    • Thread
    • Replies: 2
    • Forum: PHP
  3. euskadi

    PHP or JSP for intensive processing

    Thanks to all who have posted so far -- stars for you all for taking the time to comment. As DRJ478 guessed, I'm using hosting, so I'm limited on what I can choose // it's PHP or JSP or nothing. I'll have to check my processing limit, thanks for the clue!! Oh, and any solution which requires...
  4. euskadi

    PHP or JSP for intensive processing

    I'm planning on building an application that does some problem solving using an iterative process to determine the best solution -- it will use some arrays, do an occasional write/read on a database, and then when all avenues are exhasted it will write the final result to the database and say...
    • euskadi
    • Thread
    • Replies: 6
    • Forum: PHP
  5. euskadi

    Script to change IE proxy settings?

    I have a laptop that I use at work and at home. At work I have to use advanced proxy settings (different ports for different protocols), at home I'm not on the proxy. Rather than manually switch on and off the proxy, I'd like to write a script that I can run to switch my settings. Can anyone...
  6. euskadi

    Just a little gap 'tween columns please

    You probably won't like this solution any better than the "insert blank columns" idea, but you could just set the row above your totals to single underline, and set your total row to double underline. If it were me, I would do the blank column thing, and set the width to something...
  7. euskadi

    sort an array

    if you search the internet for "vba sort array" you'll come up with a million good answers to this one.... several different methods (including those suggested by mscallisto).
  8. euskadi

    How to write to a word document?

    Here's a star for Nikki... for a good answer _and_ for cleaning up the objects. :-)
  9. euskadi

    Excel: Sorting columns A to I - Is it possible?

    This function will give you a string 12 characters long with the rank of each item in your range, using 4 columns. Add this as your sort column, with the appropriate ranges, filldown, and sort by this column. You can extend this out to 14 columns I'm sure, and if you think you'll have more than...
  10. euskadi

    Finding centre of activesheet

    Rather than put an image on the center of the screen, why not create one sheet as your splash screen, name the range you want to use as your splash with the image in the center and zoom the window when you open up the workbook... something like: Application.ScreenUpdating = False...
  11. euskadi

    Excel function returning color of another cell

    MrCorner, You need to tell Excel that you want the range, not the value. Try this: Function background(ByRef data As Range) Application.Volatile background = data.Cells.Interior.ColorIndex End Function Note that this will update anytime the workbook is calculated, but it won't give...
  12. euskadi

    check if query was run

    Two thoughts: 1) If your procedure is running these queries, you don't need to check to see if they run, the sequential nature of the procedure will take care of that. 2) If a user is running these queries, you can create an events table that contains the name of the query and a date/time...
  13. euskadi

    Conditional formatting and charts

    Sounds like what I said. ???
  14. euskadi

    Conditional formatting and charts

    If you want to jump through a few spreadsheet equation hoops, you could create a range to capture any items which were <8, and a second contiguous range that contained items which were >=8. Then format any data in the <8 range to be blue, and have it only appear in the pie when the data was not...
  15. euskadi

    Conditional formatting and charts

    HappySmiler, Before we say &quot;no&quot;... what exactly do you want to conditionally happen in your pie chart??
  16. euskadi

    How do I... (COUNTIF Function question)

    That's odd. I get similarly odd results, it's counting anything if I enter numbers >0 or text. Maybe tweak the formula and try this: =SUM(IF(arange=brange,IF(krange<=0,0,1),0))
  17. euskadi

    Top 10 Spreadsheet Danger Signs

    a couple more signs of danger: -The person who mails you the file calls it a &quot;database&quot;. -Multiple links to workbooks that exist on a LAN somewhere, and no one can tell you what the links are for. -VBA modules, but no code.
  18. euskadi

    on open

    Since you're in the workbook module, you can use this: if me.name = &quot;bla bla bla.xls&quot;
  19. euskadi

    buttons that asks the user questions...

    When I need to do that. I create the query, then record a macro and make some modification to the query... (helps me get the details right). Then I add a couple input questions, or pull the dates from a spreadsheet, and use VBA to change the SQL as needed. Works pretty slick. Another way to do...
  20. euskadi

    Top 10 Spreadsheet Danger Signs

    Code with no comments No record of who built the thing and why Appalling use (abuse) of color =If(..(If..(If...(If..(If..)))))

Part and Inventory Search

Back
Top