Recent content by lala

sorry, i forgot to post, it's been solved http://stackoverflow.com/questions/27292792/get-a-number-of-unique-values-without-separating-values-that-belong-to-the-same but to answer lets say there are 30K in the set, today they request 10, i give it to them and mark it as called today in a...

i'm sorry, i get this reaction from everyone i explain this to, i'm not good at explaining here's how this goes in real life. we are faxing doctors that can practice at multiple offices. we do campaigns by state, so lets'say they say, give me 10K from CA. CA has 30K, so i pick out the 10K based...

i want 10000 unique people while making sure that every person picked also includes all people attached to any fax numbers they're attached to. almost a circular reference. we are trying to make sure not to fax any fax number twice but the fax center can only proccess batches of 10K (sometimes...

nope, won't work, any number of OtherIDs i plug in your query will at best (but will never happen) return the same number of OtherIDs but usually much more. because any OtherID you end up picking will always bring other OtherIDs with the same fax this question has been up on StackOverflow (not...

it's not about duplicates. my task is to pick out a certain number of unique OtherIDs. you gave me a query that picks all OtherIDs for all faxes, thank you for that. so now i need to get my number (10K, let's say). so the loop will need to run your query for the first 10K providers and see how...

interesting. i will need to write a loop that will test every combination to see how many unique OtherIDs i have and then keep tweaking up or down but i think it can be done. i will post if it works, thank you very much

This is a very tough problem to explain. Please ask any questions and i will do my best to answer them clearly. I have the following dataset in a table called NR_PVO_120. How do i pick out a number (which can change but let's say, 6) of UNIQUE OtherIDs without excluding any OtherIDs under any...

Hi, i'm running a module from an access db. how do i import a table from oracle into a closed access db, not the one where the code is running from? thank you

I did check, besides this was copied over from other dbs that work. It's a glitch of some sort, if the password was the problem it'd give me some kind of an access denied error. Instead it tells me that it can't find the table I want to import to. It's not supposed to be able to find it...

the table does exist, i'm the one that created it and i'm able to query it in Oracle. i'm also able to import it by hand. i just get this problem when i use VBA to import. i know there are other ways i can get orale data into access, it's just that importing is the fastest. any ideas? and...

hi, i get the attached error message when i try to import an oracle table using VBA. in some database i'm able to go ahead if i compact and repair but in this current one - nothing helps. which table can't it find? can anyone help? i can upload my db but you guys don't have access to our...

in case anyone needs it, here's amazing code written by HansUp at StackOverflow http://stackoverflow.com/questions/11728717/search-and-replace-whole-words-only/11729848#comment15565679_11729848 Public Function RegExpReplaceWord(ByVal strSource As String, ByVal strFind As String, ByVal...

ok, my main problem is how to do something like this. replace([address], --list of separators, like .,;:/?-- & [replacewhat] & --list of separators, like .,;:/?-- ," " & [replacewith] & " ") i don't know how to pass a list of characters that are separators at once instead running a replace...

i'm not sure why i didn't reply to this 2 years ago, sorry. i'm now again looking for a solution and will try to ply with your code and post back. thank you!!

oh i don't underestimate access and vba at all. i'm in love with it, it's almost an obsession of mine for 10 years. i self learned it because it interested me so much that i had no problem staying up nights messing with it. but it seems like access is perceived as something not serious, not...