Weekend Forum

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?

Posted in Uncategorized

22 thoughts on “Weekend Forum

  1. Pink Floyd, Lynyrd Skynyrd (gee – first time I ever tried to spell that), and Boston all enjoy boating and drinking?

  2. Music trivia question for this weekend: What do the popular rock ‘n’ roll ensembles Pink Floyd, Lynyrd Skynyrd, and Boston have in common?

    They are the subject of this weekends discussion. :rolleyes:

    Same lead singer…

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

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

  5. Barry Goudreau, Jim Masdena (Boston), Ronnie Van Zandt (LS) and Syd Barret (PF) formed their bands and they are dead ?

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

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

  8. 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&””))

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

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

Leave a Reply

Your email address will not be published. Required fields are marked *