Search results

I'm very new to VBA in access, i've only played with excel.. But now my precious excel is overloaded, and i've started an database in access. to keep all the informations. I have 30 sheets with 20.000 lines in each(and it will keep increasing).. Now it take my excel sheet 20 min to open...

Thanks.. Works perfect.. Og det skal jeg have i baghovedet.. Men problemer er jeg jo er stædig og selv ville kunne. ;-)

I'm pretty new to access, and i'm selftought.. with what i've been able to find on the internet. So maybe it's just a stupid mistake i have.. But i've made this database, because excel has gotten to "small". there are over 2 mio. Array formulas, pivot etc. and it takes over 4 min. just opening...