Search results

FAddFILE, the one it opened on

forget it, sometimes it works, sometimes it doesn't. i can't solve this

sorry, the last 4 lines to that code should be MsgBox "Where i am now " & Me.ID MsgBox "Where i started " & CurntRecrd 'Me(CurntField).SetFocus MsgBox "Where i am now " & Me.ID how does this make a difference???

this is driving me crazy, if you replace the AfterUPdate event on RAmount field with the below - it works. how do msgboxes make a difference?? because they provide delays?? CurntRecrd = Me.ID CurntField = "RAmount" If IsNull(Me.Percentage) And Me.RQuantityType = Me.BQuantityType Then...

subform all the way on the bottom, the 2nd nested.

i apologize for the size of the db, i don't know what's making it so huge, i took out all i can. this is driving me crazy, the subform keeps going to the first record no matter what i try. try updating Ttl amount, Rate amount, quantity, Rate quantity, and see what happens. on after update of...

wow!!!!!!!!! i thought this was not possible, just asked for the hell of it thank you so much

Forms!fclients.Visible = True if i want to replace FClients with me.openedfrom or a variable OpenedFrom. how can i do that? thank you

i said i was on my way to look at your db)))))))))))) i saw what you did and still thinking about it, trying to see how to implement it for my purposes. as far as the rates - i'd love to hear what you come up with, this billing is so complicated in terms of unifying it - that i don't know what...

correct me if i'm wrong but you're not changing the rules, you're just changing the values, the billing structure is the same, if more than this and less than this - 5%, if more than this and less than that - %. in my case i can't even unify it down to this level. look at my examples if it's...

i'm designing a database and there's 2 parts that i have issues with everything is working, it's just that it feels wrong, like i repeatedly feel that i'm doing the wrong thing, that no database should be designed in this way it's weird, i can't explain it 1st thing there are services that...

how come you said that the fibonacci recursive code is tricky to understand?

also, i always do that, don't know if it's the right thing to do or not. when i find a function online i don't keep it as a function, i take off the first and last line and put the code inside my code. should i have kept yours the way it was and called it instead?

did exactly that))))))))) i learned a few things here. yours beats mine any time, that's why i said right away that my solution was ugly. thank you very much!!

also, it's not always 9 records, that's why i had some other code in there but yours looks neater anyway, so i'm editing yours instead

using yours of course))))))))))) thank you!!

never mind about autonumbers, solved that, i have another question about how deep is too deep for the combinations. for example, is 2 combinations out of 9 too deep? that's my worse case scenario, will i crash the program?

i found an ugly solution but it works Dim CountOfNulls As String Dim UpdateTo As Long UpdateTo = 1 CountOfNulls = DCount("MatchingField", "mtmatching", "matchid is null") Do Until CountOfNulls = 0 Dim UpdateID As String UpdateID = "UPDATE mtMatching SET mtMatching.MatchID = " &...

How do i do that? i have 9 fields that i need to be able to number everytime i run a function and they MUST not skip and they MUST start at 1 i've been looking at autonumber function all day and i haven't found one that does it, maybe i'm looking for the wrong thing? it's not autonumber but...

also, to use Gemma's code my fields have to have numbers from 1 through 9. how do i assign autonumbers everytime and make sure that they start with 1 and don't skip?