Recent content by Stretchwickster

I don't know of any existing classes for this purpose, so I think you'll need to build it yourself. Perhaps this will give you a starting point. Clive ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "To err is human, but to really foul things up you need a computer." (Paul Ehrlich)...

Perfect - thank you very much. I've never used UNION until now. Clive ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "To err is human, but to really foul things up you need a computer." (Paul Ehrlich) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ To get the best answers from this...

What I'm trying to do is create a SQL query that internally generates the following result set without querying an actual table/view... DESC ABBR CALENDAR_YEAR Next Year N 2013 This Year C 2012 Last Year L 2011 Older Year O 2010 The respective values...

Thanks for the info Skip. Clive ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "To err is human, but to really foul things up you need a computer." (Paul Ehrlich) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ To get the best answers from this forum see: faq102-5096

Many thanks for your suggestions - they appear to be the only way of achieving what I want. Clive ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "To err is human, but to really foul things up you need a computer." (Paul Ehrlich) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ To get...

I've had a good search for the answer to this, but I'm struggling to find anything. In Excel 2007, I've created a chart consisting of two clustered column series. Series 1 is plotted on the primary (left) y-axis, whilst Series 2 is plotted on the secondary (right) y-axis. Both series share the...

I guess I'm going to have to go with shorter sheet names due to Microsoft imposing this arbitrary 30 character constraint in Excel 2007 - very annoying. I wish they would ensure backwards compatibility, as I noticed they removed some additional chart properties which threw up errors in Excel...

Thanks for the suggestion - but unfortunately it made no difference. It appears that, in Excel 2007, when a string is returned in Application.Caller it is limited to 30 characters. Does anyone know why this limit has been imposed? Or if it's documented anywhere? Any other ideas for...

Hi there, On running a macro (originally written in Excel 2003) in Excel 2007 I get a "Run-time error '9': Subscript out of range" error which arises from the following code: Public Sub GoToChart() ' check which text box button called the macro and activate appropriate sheet If...

Many thanks for posting this code Griffyn, I haven't had much time to visit Tek-Tips lately, let alone update any of my out-dated 2005 FAQs! I've updated my FAQ to point to this thread. However, I'm happy to remove my FAQ on this topic, if you're willing to replace it with the finalised...

Thanks for the tip. My understanding of how it works is a bit clearer now, thanks to your input. Mine did have a single localhost entry until I added my entries. Clive ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "To err is human, but to really foul things up you need a computer."...

Now you mention it, this time I did reboot after making the change to the hosts file, last time I don't believe I did. So I think you're spot on there. I think I confused myself into thinking that the hosts file only impacted IIS, and therefore the problems I was running into were related to...

Many thanks to you both for your input. I'm sure I tried donb01's suggestion before, but after uncommenting the "127.0.0.3 apache" line in my hosts file, typing http://apache/ in my browser now finds the XAMPP welcome page - hooray! Better still, if I start XAMPP first, then start IIS, I can...

Hi there, Throughout today I've been trying to setup Apache 2.2.12 (installed as part of XAMPP 1.7.2) in a local development environment such that http://apache/ maps to http://127.0.0.3. I have forced Apache to listen on 127.0.0.3:80 so that I can run IIS concurrently on 127.0.0.2:80 (I have...

Any decent host should have some kind of uptime guarantee and will provide financial compensation according to the duration of downtime. For example: http://www.site5.com/hosting/guarantees/ Clive ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "To err is human, but to really foul things...