It’s the weekend again, and this time I’m future-posting the Weekend Forum post. I left town yesterday and Internet access will be in doubt where I’m headed. “Where is that?”, you ask? Back to the Lake of the Ozarks. Except this time I’m not going for boating and drinking. This time I’m going for golfing and drinking (with a little boating thrown in).
I just had a golf lesson on Monday with Ryan Nietfeldt, but I haven’t had a lot of time to practice, so it should be interesting. Ryan is a former CPA turned golf pro.
I flew to the Ozarks last time on my dad’s Piper Saratoga, which takes about 2 hours. This time I’m driving, which takes about 5 hours longer than that. I’m looking forward to getting some work done on the ride down there. By the time you read this, however, I will have already rationalized not working in the car and drinking beer instead.
Music trivia question for this weekend: What do the popular rock ‘n’ roll ensembles Pink Floyd, Lynyrd Skynyrd, and Boston have in common?
What do you want to talk about this weekend?
Boating and drinking sounds good to me
Pink Floyd, Lynyrd Skynyrd (gee – first time I ever tried to spell that), and Boston all enjoy boating and drinking?
All I can find is Rock Opera – is that the link?
All died in a plane crash?
They’re all Bob Umlas’ age.
What do the popular rock ‘n’ roll ensembles Pink Floyd, Lynyrd Skynyrd, and Boston have in common.
The best bands to form in the 70s to beat out the brits and they were from boston
They are the subject of this weekends discussion. :rolleyes:
Same lead singer…
I can’t think of a single common factor among Pink Floyd, Lynyrd Skynyrd and Boston other than they all did their best work during the 70’s. I’ll be interested to hear Dick’s answer.
Best band from the 70’s was AC/DC (I am a biased Aussie)
Q. What did Pink Floyd, Lynyrd Skynyrd, and Boston have in common ?
A. None used Excel to prepare tour schedules
A. Did they all come out of the same school/uni ?
Hui…
Barry Goudreau, Jim Masdena (Boston), Ronnie Van Zandt (LS) and Syd Barret (PF) formed their bands and they are dead ?
Goudreau & Masdea aren’t dead, and there’s no connection between either of them, Van Zandt, or Barrett. They come from vastly different backgrounds (Florida, Boston, and the UK).
Maybe Dick has them all on his iPod?
The all played on Les Paul’s Classic guitar from 1962 ;)
Kind ZZ Top’s regards,
Dennis
what happened to ZZ Top ?
They got a shave and haircut… :-D
http://www.zztop.com/
Doco – that saved my day – ROFL!
Kind regards,
Dennis
Hi ,
Something about “Sumproduct”……….! Would be of great help!
Regards
Kanwaljit
So I asked this question last week at the MS-Newgroups and haven’t gotten an answer I know someone here knows what is going on – Any ideas?
I am trying to access a lotus notes database through ADO and when I do a few
of the fields are having their information truncated, so I am only getting the first 254 characters. How through VBA can I select those fields and get ALL the data in them?
Here is the test code I am playing with…
Function ReadLotusECNExport()
Dim oConn As ADODB.Connection
Dim rs As ADODB.Recordset
myServerName = “A_Database_Name” ‘removed name here…
myDbName = “BBGCorAct.nsf” ‘Actual Lotus Database Name
‘Connect to a Database
Set oConn = CreateObject(“ADODB.Connection”)
oConn.ConnectionString = “DRIVER={Lotus NotesSQL Driver (*.nsf)};SERVER=” &
myServerName & “;DATABASE=” & myDbName
oConn.Open
‘Create a recordset object
Set rs = CreateObject(“ADODB.RecordSet”)
rs.ActiveConnection = oConn
rs.CursorLocation = adUseClient
rs.CursorType = adOpenDynamic
rs.LockType = adLockPessimistic
strSQL = “SELECT Main.Description FROM Main WHERE ((Main.Status)’Closed’);”
rs.Open strSQL
Do
Debug.Print rs2!Description ‘This will only give me the 1st 254 character’s?
rs.MoveNext
Loop Until rs.EOF
set rs = nothing
rs.Close
End Function
007-kanwal Says:
August 28th, 2006 at 1:56 am
Hi ,
Something about “Sumproduct”……….! Would be of great help!
Regards
Kanwaljit
Here is something I’ve kept around…
To count only distinct numbers in Rng,
=SUMPRODUCT(ISNUMBER(Rng)/COUNTIF(Rng,Rng&””))
To count only distinct text including “” in Rng,
=SUMPRODUCT(ISTEXT(Rng)/COUNTIF(Rng,Rng&””))
To count only distinct text excluding “” in Rng,
=SUMPRODUCT(ISTEXT(Rng)*ISNUMBER(1/(Rng””))/COUNTIF(Rng,Rng&””))
To count distinct error values in Rng,
=SUMPRODUCT(ISERROR(Rng)/COUNTIF(Rng,Rng&””))
To count distinct logical values in Rng,
=SUMPRODUCT(ISLOGICAL(Rng)/COUNTIF(Rng,Rng&””))
To count distinct positive numbers in range,
=SUMPRODUCT(ISNUMBER(Rng)*ISNUMBER(1/(Rng>0))/COUNTIF(Rng,Rng&””))
To count distinct numbers or text in Rng,
=SUMPRODUCT((ISNUMBER(Rng)+ISTEXT(Rng))/COUNTIF(Rng,Rng&””))
Hi Steven,
Thanks for the details………! I would love to make a library of such functions. “Sumproduct” seems to be one of your favourites. Would be interesting to communicate more on the subject with you.
Regards
Kanwaljit
All of those bands had hit songs whose lyrics contain dialog from a record executive:
Pink Floyd – Have a Cigar – “By the way, which one’s Pink” (actually, the whole song)
Boston – Rock ‘n’ Roll Band – “Boys. I think this band’s outta-sight”
Lynyrd Skynyrd – Workin’ for MCA – “…maybe you’re what I want”
In other news, I got in yet another car accident. I must have a target on my car or something. Some guy was doing a little illegal passing and whacked my front fender. It barely scratched the paint, but there’s stuff broken underneath. I’m driving a rental (Mazda 6) and I missed a whole day of work dealing with insurance companies and auto body repair folk. No injuries, but thanks for asking.
All of those bands had hit songs whose lyrics contain dialog from a record executive
That’s the answer? I was thinking the solution was something less obvious.
I agree with John. I thought xlDennis had the best answer!