Hey all,
Can anybody point me in the right direction of how to create and call a
function in an add-in from within access?
I've written a vba function that calls a dll to execute a required task.
It essentially processes a field, and returns the processed version of
that field.
ie. in a report, i would put as the control source "=dotask([field])"
and it would show the processed field in the report.
However, given that this is a feature that people are going to use in
their existing access databases, its not much use to have a module that
they have to add to each database they create. The ideal would be the
user installs an addin, and it is accessible to the user without any
need for further action by the user.
Its easy enough to get an add-in working in excel, but I cant for the
life of me work out how (or even if) its possible in access?
Would appreciate any advice.
Cheers.
Steve
|