The expression you used has a function name Access can't find

O

Owl

Please, will somebody help me with this. I have been struggling with this
for over 2 weeks.

I have recently updated from Microsoft 2003 to 2007.

"The expression you used has a function name that Microsoft Access can't
find" is the message when I try to run a macrogroup that has the following
simple macros.

MACRO
FIRST LINE
Macro name: Open Dialog
Condition: (Blank)
Action: OpenForm
Arguments: FD_ParameterCollector, Form

SECOND LINE
Macro name: (Blank)
Condition: NotIsLoaded(“FD_ParameterCollectorâ€)
Action: CancelEvent
Arguments: (Blank)

THIRD LINE
Macro name: Close Dialog
Condition: (Blank)
Action: Close
Arguments: FD_ParameterCollector, Form

FOURTH LINE
Macro name: OK
Condition: (Blank)
Action: SetValue
Arguments: [Visible], No

FIFTH LINE
Macro name: Cancel
Condition:
Action: Close
Arguments: FD_ParameterCollector, Form


(I think it may have something to do with LIBRARIES. I came across these
somewhere in my struggles, but I can’t find them now.)

Thank you for any help.
 
S

Steve Schapel

Owl,

I do not know what NotIsLoaded refers to, but it is not a native Access
function. Which would imply it is a user-defined function within your
database. So it may be good to try and track down that and check that it is
present and working properly.

In any case, I can't quite make sense of that macro... The first action
opens the form, and then - what event are you trying to Cancel with the
second action?
 
O

Owl

I found the libraries on:

VBA - View - Object Browser. I believe the 3 libraries I need for 2007 are
1. VBA
2. Access
3. DAO

but I don't know how to "select" them or "add" them or whatever I have to do
to them.

Thank you for any replis.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top