Search results

i meant all of you, i told you i didn't know how to count))))))))))))))

the one you gave me allows repeats, so then what does the other one do? and yes, i saw that it's using a fomula of some sort, i was going to go pick my father's brain today, he was in a math major. i suck at math))))))))) i thought my father can explain what the formula does and i was hoping...

but you're right, i'm going to study this code and try to see what it is thats making it give me all the possible combinations and see if i can change it. will post back if i do thank you both of you!!

i just saw this, thank you, that's what i'm trying to say))))))))) i tried googling and no luck, permutations are everywhere, but ot what i need. i will keep trying this myself, just thought maybe someone already has something here

thank you for the example. i am able to get this in access, that's why i specified in the beginning that i don't need ALL combinations in the math sense of it, to me 1234 and 4321 is the same things and they shouldn't be repeated. i don't know how to explain it any better, i need all...

1. they're empty. i get files to match and with each project there are different fields available. so i still have those fields in the master table, they're just blank 2. any time one line matches - it gets marked, but i will keep trying all combinations anyway for all the lines not matched...

i don't need all possible combination in the math sense, for my purposes 1234 and 4321 is the same thing, i'd only want to see a combination of 1,2,3,4 once, no matter which order here's what i'm trying to do. (also, this is not a database, it's an automation tool for a task (to avoid...

Thank you very much But you have to agree that from the standpoint of having to click as little as possible its better not to have buttons I always design my dbs using that as a model, user having to click as little as possible, my personal preference

using a button for each listbox? too complicated and not easy to use. if you have one listbox then selecting and clicking a button might be ok, but doing it after each? damn, so no way?

Hi, i have a form with 10 multiselect extended listboxes where a user can choose his criteria for the form. the idea is that after making selections in one listbox - the others requery and show choices based on what's been selected for example, i have 3 listboxes, city, state and zip. if user...

this is much faster, thank you so much!!!!!!!!!

i got it!!!! as long as there's not an easier way of doing it than appending them one by one - i got it to work

the code above gives me the email addresses as it loops through the string how do i take the first emaill address and append it to the table? bu using an append query? and literally just loop through and do them one by one? if so, then i know what to do, if there's a better way then i need help.

Private Sub SplitTest_Click() Const TestString As String = "1yahoo.com,2yahoo.com,3yahoo.com,4yahoo.com,5yahoo.com,6yahoo.com,7yahoo.com,8yahoo.com" Dim strText As String Dim strParts() As String Dim intCounter As Integer strParts = Split(TestString, ",") For intCounter = LBound(strParts())...

i have a string that i need broken up into rows ID EMAIL 33455 1@yahoo.com,2@yahoo.com,3@yahoo.com,4@yahoo.com,5@yahoo.com,6@yahoo.com,7@yahoo.com,8@yahoo.com is that possible? i know how to split it and get each value, but don't know how to insert it into a table...

Private Sub Test_Click() Dim fnGetAccounts As String Dim TheSSN As Long Dim Temp As String Dim rst As DAO.Recordset Temp = "" Set rst = CurrentDb.OpenRecordset("Select * From YOURTABLE") While Not rst.EOF And Not rst.BOF Temp = Temp & rst!YOURFIELDTOCONCAT & "," rst.MoveNext Wend...

VarChar is text, right? then the ids are stored as text in Oracle. anyhow, the 's are not the problem anymore, everything is working perfect. I'm going to try automating the conversion part, but it's not a big deal I thought of writing to another cell after a certain number of characters, but i...

)))))))))))))))))))))))) i like MS, i know i'm about to have rotten tomatoes thrown at me MS Office is amazing, Access especially and the ability to use VBA with Office. it's very thought out, powerful, Windows too i don't have anything to compare with, that's all i ever used, but that's mostly...

this is amazing, one small problem. Excell's cell only holds a certain amoung of characters. any ideas to get around that?

i don't know)))))))))))) but I will definitely do it from now on, didn't realize it's annoying and sorry, i got this to work, didn't post back because noone replied so I thought noone would care, again, my fault and you're right, it was because i wasn't adjusting the start and end character and...