AccessNovice said:
The 'trust access to visual basic project' is greyed out. How can I get this
to be activated??
What are you trying to achieve by selecting that option?
The VB function I'm trying to run shows up under my 'module' list.
Um, you don't see the names of functions in the module list. You see
the names of modules. Each module contains function and/or sub
procedures. But you should not name any module the same as any function
or sub. Therefore, none of the function or sub procedure names should
"show up under the 'module' list".
If I'm trying to run my function through an 'update query'
So, you have an SQL UPDATE statement that uses a function that is
defined in a module. Correct?
Is there another way around this problem?
WHAT problem?
Sorry Ben, I'm not trying to be picky, but you really need to explain
your problem more clearly, before someone can help. I have a fair idea
of what it is, but I'd prefer to be told: not to guess. The best
approach is to clearly describe:
(1) What you are currrently doing,
(2) What actually happens when you do that, and
(3) What you expected or wanted to happen instead.
HTH,
TC
