Recent content by jrickards

  1. J

    Intro

    Yup, Ontarian is a word (now it is, anyway, LoL). Hope you had a Merry Christmas and will have a Happy New Year!
  2. J

    Compile stops at db.OpenRecordset

    I used to do a bit of basic SQL 15yrs ago but INNER JOINs were always my stumbling block: I understood what they did, but I could never get the coding right. And, of course, anything more than basic functions and my scripting knowledge and experience failed. @theDBGuy, thanks again
  3. J

    Compile stops at db.OpenRecordset

    You're absolutely right, he deserves more than just a thanks. And, sticking to it, me, a newbie (with some basic knowledge, enough to make me dangerous), I couldn't believe that he was still stuck on the scent until the rabbit was found! How do I give his reputation a boost for this?
  4. J

    Compile stops at db.OpenRecordset

    The other script that I tried to make work had an interesting option (that I wasn't going to use) but the last separator was " and " instead of ", " so the results might be "author1, author2 and author3". Like I said, that wasn't an option I needed now but I guess the script author thought that...
  5. J

    Compile stops at db.OpenRecordset

    There was just one minor change I had to make to the script, I don't know if you want to fold it into your web page but I wanted ", " between names, not just the "," so I modified the separator to include the space and tested it, it worked fine.
  6. J

    Compile stops at db.OpenRecordset

    That's it! Wow, that was quite the effort and I'd be amiss if I didn't attribute 99.99% of the effort to you. Many, many thanks.
  7. J

    Compile stops at db.OpenRecordset

    Hah! Absolutely perfect!!
  8. J

    Compile stops at db.OpenRecordset

    Oooops, didn't compact and repair but just zipping it was sufficient to bring it down to the right size.
  9. J

    Compile stops at db.OpenRecordset

    Here's the db The data is public, I'm not concerned about sharing real data.
  10. J

    Compile stops at db.OpenRecordset

    No, there's a syntax error and I'm wondering if there might be a problem with the quotation marks around the text. I dropped the joining of last and first names and got past that error with the following code but still another error. SELECT PUB_PUBLICATION_CONTRIBUTOR.PUBLICATION_ID...
  11. J

    Compile stops at db.OpenRecordset

    Yes, it is. Just a sec
  12. J

    Compile stops at db.OpenRecordset

    No errors in the attempt, per se, but it was asking for a PERSON_ID which, it turns out also is text (why did they create IDs that are text and not numeric? ... anyway)
  13. J

    Compile stops at db.OpenRecordset

    OK, here's the table structure. Ultimately, I want "PERSON_LASTNAME PERSON_FIRSTNAME" (space between them and comma between each person) I'll try that code in just a sec
  14. J

    Compile stops at db.OpenRecordset

    No, not quite. Test should have only 3 values but instead it has all of these...
  15. J

    Compile stops at db.OpenRecordset

    Works! What did we miss in the SQL?
See more
Back
Top Bottom