Search results for query: *

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.

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

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

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

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

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

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

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

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

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

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

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

Sounds like what I said. ???

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

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

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

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.

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

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

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