Search results

Why don't you try creating a pivot in excel which is linked to your table / select query from your access database. This not only provides great flexibility in terms of have different summary views in excel but it also enables you to drill down to see the underlying records that make up the...

Hi, Nanscombe's idea is quite close to what I require. I can add a database file which contains my functions as a library in VBA. No copying and pasting the modules. But again, will need to add the library each time that I create a new database. I could combine this with the template feature...

Hi Husky, I don't want to copy anything in every database. The problem is I need to work with hundreds of databases and every time I think of using a custom function, I need to get it from somewhere it is currently saved. I am looking for something where these custom functions that I have...

Thanks a lot! Judging from the description on the link this is what I am after and think would work. But unfortunately I don't have enough rights to modify anything in the C:\Program Files. But this looks like the solution. I will see if I can find a way around the access. Thank you for your...

Hi, Thanks for your reply. But importing the functions each time is what I am trying to avoid.

Hello All, I have tried to search this all over internet without much success. I have quite a few user defined / custom functions which I would like to be available in any new database that I create without have to copy the VBA codes in a module each time. Basically, some sort of add-in that...