Search results

thank you so much for this one, i put the 's around numbers in Access, but everything else I had no idea how to start on. I thought of writing a macro in Word because that's what i use to do it by hand (replace) thank you, i do this a lot, this is perfect!!!!!!!!!!!!

ok, another problem, do you see what it's doing? CREATE TABLE TMP_IDs AS SELECT DISTINCT p.OTHERID, p.PROVIDERID, o.LOCATIONID, o.OFFICEID, c.MPICONTRACTID GROUPNUMBER FROM mpi_provider.officecontract@ARCHIVE oc, mpi_provider.mpilocation@ARCHIVE l, mpi_provider.office@ARCHIVE o...

oh my, i think i got it If StartAt = RepeatTimes-1 Then EndingChar = InStrRev(NewString, ",") Else EndingChar = CharPos(NewString, ",", Sets) - 1 End If

one more thing, before i start my program i convert the Excel row to look like this 2435,3554,6665,7776. i do that by hand while testing, but i might write the code to do it if i get everything else to work

ok, i'm ready, please no laughing too loud here's my code, i'm not creating the query here, just testing, meaning, there's no ODBC connection, just the query code in the debug window ok, i get a request, it's an excel file with a row of IDs 24352 24353 25546 26354 288857 here's what i have...

Yes, that's what I'm trying to do. I need to be able to pull results for IDs that people give me and it can be any number of entries, 10000, 5000. I couldn't think of anything but to break it up by 1000.

you, guys, are amazing, I feel so dumb every time I come here)))))))))))))))) in a good way

here's what i'm trying to do, i'm almost sure that i'm not doing this in the best way possible. i'm creating a pass-through query in VBA and my criteria is more than 1000 entries (Oracle only takes 1000 at a time like this p.otherid in (1,2,3,4...999,1000). Since i need to have 7000 (in this...

so what would you have done? and to further answer your question, i'm almost sure this function was written for Excel, but i tested it in Access and it worked.

Access and thank you, i'm using yours now

and one more reatrted thing i did, when posting this guy's function i deleted all the comments, trying to make it shorter for you, guys, to read. He explains why that line is there, here's the original version Public Function CharPos(SearchString As String, Char As String, Instance As Long)...

yeap, that's what i was trying to say, Bob. once I added AS LONG, as you suggested, then it started breaking and highlighting this line CharPos = CVErr(xlErrValue)

sorry, i mean to say that once you add AS LONG to the end of the declarations it doesn't work it works with the X as long instead of integer and now processes huge strings

nope, it's not working with the last long

thank you and it's working now!!!! Bob, i will put that in as well, even though i think i understand why it has to be there, i'm not sure why it worked without it

Hi, i need to be able to search a very long string (about 50,000 chars) and determine a position of the 1000th comma, then the 2000th and so on i found a function that does exactly what i need but with shorter strings, it overflows with 50K chars Public Function CharPos(SearchString As String...

that was the part i needed to move on))))))))) i was looking on the net for a way to copy a variable on the clipboard and, believe it or not, couldn't find anything that'd work in access (at least for me) never knew about debug.print, so cool, so easy

got it!!!!!!!! thank you, thank you, thankyou!!!!!!!!!!!

i still need your help. if it is the ('s im missing, i'm not sure how to code them. the first set has to be wrapped starting from ((AllMkts LEFT JOIN 42010 ON (AllMkts.State = [42010].State) AND (AllMkts.Mkt = [42010].Mkt)) and the second and all the rest from (AllMkts.State = [52010].State)...

found it, it's the (, right? missing a few, i have to take each set of joins and wrap them, right? i'm not smarter than you, i created a query by hand and compared will try coding now and see what happens thank you for the idea!!!