Search results for query: *

Hi, Default worksheet tabs have a bevel/curved appearance to them - is there a way to remove this curve and just have old style "flat" tabs? Or, it is possible to set worksheet tab FONT colour. Reason for posting is that tab name hard to read on certain colours - and before you say it, no we...

Ok, well at least that confirms that a flash ad may be to blame, it would also go some way to explaining why the sportlinglife url did work on random occasions. Something new in flash perhaps that web queries just can't handle. May I wask which version of Excel you're using? I'm on 2007 and I...

yes, I do realise that QT are objects.... and I already delete as nec. in a separate sub. The workbook runs without problem - except for the two urls mentioned above. Have you tried to load and import www.telegraph.co.uk via the New Web Query dialog in Excel at all? Perhaps that would be a...

Hi, trying to write some SQL to pull data - can't get it to work so I'm hoping someone can explain what's wrong. Most interested in the explanation that just having a solution - thanks. Two tables, linked on field code. table - T1 code area 1 n 2 n 3 s 4 s 5 w table - T2 code part value...

Thanks for all your help - it's working. if I wanted to pull another piece of info for the most recent order - say orderNum as well as orderCost - do I really need another, separate subquery for that? Finding this SQL such a headache. Can't help but feel it would be so much quicker to knock...

not even sure if this is a subquery but I can't even come close to finding another way of solving it. Table of orders ===================================== order cust order order num code date cost ===================================== 456 cust1 1/3/2011...

finally... Ok, so even though r_date is held in dd/mm/yy format, that is automatically converted to the required MM/dd/yy format... only that same conversion isn't applied to the startDate var. WHY!? If I do the conversion - as below - then all is fine. "(r_date > #" & Month(startdate) & "/"...

yessss I know there's no month 19. I'm British, my time zones are set British, my dates are set to British - that's why when I run isDate() against startDate it doesn't return an error because the format is dd/mm/yy. Ditto if I run day(startDate), or month(STartDate) - it returns the correct...

ok, I've got a straightforward SQL statment with a where clause The where clause is as follows: "(r_date > #" & Startdate & "#) and " & _ "(r_date < #" & db_valid.Fields("r_date") & "#) and " & _ StartDate contains 12/09/2010 and db_valid.Fields("r_date") contains 19/09/2010 the statement...

Hi, I can create queries using the grid in Access, but I'm trying to get used to writing SQL and understand Group By queries. When a group by is very simple I can (just about) manage it, but the following problem has me beat - any help would be great. In the following small table I can write a...