So here i am with another issue that has popped up with this dam project im working on. Here is the idea:
I have created queries in an access database that compare 2 sets of data, previous and current, and compares them using a function that i wrote in VBA (fComp()). Instead of writing a HUGE iif statement in access, i wrote this function to make it nice and clean. It works very well.
Now comes the second part of my project, Excel pivot tables. Because everyone that will be using the data found in the Access database wants pivot tables, i must give them pivot tables. So i create a spreadsheet for each comparison query that i have written in Access and start setting up a pivot table using the Access database as the datasource. As simple as that sounds, i get this error "Undefined function 'fComp' in expression." I know what it's telling me, but i dont know WHY it's telling me this. Since Access would be runnign the query to populate the data for the pivot table, i cannot understand why it's pooping out on me. Is there a way to pass that function from Access VBA to Excel VBA?
help.
Emanuele
I have created queries in an access database that compare 2 sets of data, previous and current, and compares them using a function that i wrote in VBA (fComp()). Instead of writing a HUGE iif statement in access, i wrote this function to make it nice and clean. It works very well.
Now comes the second part of my project, Excel pivot tables. Because everyone that will be using the data found in the Access database wants pivot tables, i must give them pivot tables. So i create a spreadsheet for each comparison query that i have written in Access and start setting up a pivot table using the Access database as the datasource. As simple as that sounds, i get this error "Undefined function 'fComp' in expression." I know what it's telling me, but i dont know WHY it's telling me this. Since Access would be runnign the query to populate the data for the pivot table, i cannot understand why it's pooping out on me. Is there a way to pass that function from Access VBA to Excel VBA?
help.
Emanuele