Search results

as far as fibonacci code - i can follow the normal one, as far as the recursive one - you're saying if the term is 1 or 2 then the result will be 1 in both cases, got that, so this is the one line that does all the work fibonacci_recursive = fibonacci_recursive(term - 1) +...

are you saying there's no way in VBA to go through all files and folders in a folder? and this was the example of what happens if you try? or there's a way just not by using recursion?

just making sure i understand what's going on)))))))))) Gemma, i'm about to go to sleep and will study this later, but just wondering, what would this series be used for in real life?

omg, i put Gemma through all this horror and it turns out to be this easy??? got it but in this case it permutes it, right? so 1234 and 4321 will be 2 different combinations. for my purposes i only needed each combination once. but i see how they all work now. i wish i had someone like you...

the reason i said that about languages was because another question was that i see on the net that some languages don't allow recursion and since i couldn't understand what it is that makes the code recursive i couldn't understand what it was that some languages don't allow.

so the fact that you can call the function inside yourself makes it recursive? and some languages don't allow that? is it really that simple?

i think i understand, loop will loop through until you tell it to stop, recursion will keep calling itself until there's more stuff to examine. here's another stupid question, what in your code makes it recursive? is it the fact that you have the if..then..else inside the loop to see if it...

i probably sound like a total idiot, but believe it or not i wrote many programs, it's just, i'm sure you know, in access there are many ways to do one thing. and even though most of my solutions weren't pretty they worked. VBA is new to me, only the last 2 years, and i'm learning by googling...

i thought that any code that repeats itself over and over until you tell it to stop is a loop, no?

Function combine(required As Long, max As Long, combo As String) As String Dim x As Long Dim startfrom As Long Dim newstr As String If Len(combo) = 0 Then startfrom = 0 Else startfrom = CLng(Right(combo, 1)) End If For x = startfrom + 1 To ((max - required) + Len(combo) + 1)...

yes, i just ran it and i see now the order of it, Gemma, thank you so much!! i appreciate it so much, i actually understand how this is done now! thank you for your infinite patience

you mean the only problem is that you won't know how to explain to the loop when to stop? i can't believe that i'm actually understanding everything you're saying)))))))))))))) i'm so hyped because i'm really new to vba, i know almost nothing and i think i understand everything you say

Gemma, what's your background if you don't mind me asking? i've seen a lot of your answers on this forum, you've helped me a few times before too. and the impression i got about you is that there's no question that you can't answer. are you self-taught? what about the math part of it? hope i'm...

Gemma, first of all I can’t find the words to thank you for taking the time and the effort to explain this in so much detail and for making it so clear. i’m really speechless, not only you handed me a solution but you then went out of your way to explain every bit of it. Thank you doesn’t say it...

omg, the website StackOverflow, thats where it cams from?)))))))))

in this case what would i have to do to crash it? too deeply meaning what?

Gemma, i now realize that i will never understand how this works, i forgot factorials back when i was taught them. so i'm just going to copy and paste. few questions though, i only have 9 fields at the max and considering that i'm going down to 3 combinations i'm only using 6 levels, is that...

here are the examples and while i was creating them Gemma posted some code that im about to study. Gemma, before i even try to undeerstand it, thank you for taking the time to explain what it does

you don't owe me anything)))))))) i'd appreciate whatever and whenever you can do i'm going to make something in excel and attach in a few mins and thank you for even trying

this is exactly it with some notes. i won't go down to 1 or 2 numbers, i will stop at 3. if it's not matching on any combinations of 3 fields - i'm done. dying to see what you're going to do, i'm truly stuck. usually i at least have an idea on how to do it if not in the prettiest way, but not...