Search results

OK, I had that part right. End of my day here, will continue tomorrow (same time zone as NYC).

So, to start off with, where do I put this so that it is available to the SQL? I'm wondering if that might be part of the problem.

Hah! That looks much more concise! Let me try it in place of what I've got.

Nope, nothing, compile error at the "Set rs = " line Maybe something is wrong with how I'm using the downloaded script. Maybe I should ask where it goes so that it can be accessed by Access. I have some subroutines that I created years ago and I put it with them, maybe that's the problem?

How do I print debug.print pstrSQL?

No difference, the Debug stops at the same place "Set rs = db.OpenRecordset (pstrSQL)"

No space in the code, must have been a copy/paste inaccuracy.

If you have a look at the opening post, you'll see that I downloaded the code (url given but not in url format as I didn't have enough posts here to format it properly as a url). The solution I'm looking for is to take a publication with multiple authors and convert it to a comma separated list...

LOL Just a different kind of confusion! LOL

OK, I've determined one thing. As the code in the URL above indicates in the comments, if the ID (PUBLICATION_ID) is string and not numeric, apply the changes indicated. I applied the suggested changes, no difference. I then decided to change the PUBLICATION_ID from text to numeric (not an...

Run-time error 3075 Syntax error (missing operator) in query expression 'PUB_PERSON.PERSON_LASTNAME WHERE PUB_PUBLICATION_CONTRIBUTOR.PUBLICATION_ID=00001620'

What this function is intended to do is list the authors for each publication. For the sake of testing, I've limited the query to just one publication with multiple authors. PublicationID 00001620 has three authors and I'm wanting to get a list of them in a single field. OK, the SQL is: SELECT...

HI: Not much more than a beginner here, just trying to use a downloaded VBscript but it is throwing an error. Code is from: tek-tips.com/faqs.cfm?fid=4233 Using Access 365, the yellow debug line is stopped at Set rs = db.OpenRecordset(pstrSQL) How do I get past this? Thanks

Julian here, a cartographer with the Ontario Geological Survey from Sudbury, Ontario, Canada Trying to make sense of Access, LOL. I've taken some courses, done a bit of SQL in MySQL but basically a beginner. Enjoy cycling and photography, live 59yrs, married 32yrs, sons 24 and 26yr old, 2 dogs...