Search results

thank you, i didn't think of doing that, i was so stuck on looking for a function that creates combinations that i didn't realize that for the purposes of this project the above would work. by the way, i found it, if anyone ever needs it. Option Compare Database Public intNumNames As...

i only need half of the combinations, for my purposes 1 - 2 and 2 - 1 is the same thing. and also, i need either vba code or a function that creates the combinations so i can do things with them thank you though!!

hi, i need to get all possible 2 digit combinations (order doesn't matter) or numbers from 1-70 gemma, you did this for me before but it was a little different because i needed all digit combinations and the range was froom 0-9. i could've went back and tried adjusting that code but i remember...

updates Amounts DoCmd.RunSQL "UPDATE CLIENTFILESERVICES SET CLIENTFILESERVICES.TtlChargesAmount = IIf(IsNull(DSum('BAmount','CLIENTFILESERVICEITEMS','ClientFileServiceID=' & [CLIENTFILESERVICES].[ID])),0,DSum('BAmount','CLIENTFILESERVICEITEMS','ClientFileServiceID=' &...

i will tell you in 5 mins which line makes my subform requery, i thought it was requerying the controls, but i might be wrong. i found it last night, give me a fes

thank you, i definitely didn't know this. what about recalculating some fields?

in case it didn't come through, i understand that this is retarted, but that's why i did it so i wrote it))))

i had it and delete it, i like the code as short as possible. this was a nip from the internet, i didn't understand what benefit it gives me so i deleted it i know, there's so much wrong with my code, i learn what i can as i go but the more i learn the more i realize there's so much more

i never turn them back on, i turn them off for everything always, i like it that way for some reason, but as i work on the db i need them so i manually turn them on, then go back in the form and they're on and it's annoying. so i put it in every form to turn it off on load so that i can turn...

i know about switching from record to record, was thinking on close it probably does but i'm oc, so i did it in case. will take it out now))))

thank you for even trying. i know this is neither interesting or easy

sure, give me like 5 mins, i will take it all out

and it is global in my version but i tried both ways. i mad it global when i tried running the bookmark on the afterupdate of the form, not the field. can be either way

you're right, will make it a habit

oh, i have this))))) my favorite thing, whoever wrote this is amazing in the way they compiled it and i go to it when things don't work but somehow it works like this as well forms!form!subform1!subform2!fff

thank you, reading now

this is the line that makes it go to first record. DoCmd.RunCommand acCmdSaveRecord as soon as i comment it - all is well. why?

maybe it wasn't even you)))))))) i don't like a lot of it so i was expecting criticism and i read something you didn't write i will try putting calculations in the query behind the form. but can you try taking out the requery lines and see what happens?

really? i haven't thought of that, it would requery on it's own? the thing it thought, even if i take out the requery lines and just leave the SaveRecord part, it still doesnt work

i'm not defending my code, there's so much i don't like in this database, but i can't find better soluitions. how else can i requery though? i'm requerying because there's no other way for me to recalc those numbers. those can't be calculated totals, they have to be fields because in some cases...