O
Owl
Please, will somebody help me with this. I have been struggling with this
for over 2 weeks. I posted it under Macros but with no success.
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 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 replies.
for over 2 weeks. I posted it under Macros but with no success.
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 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 replies.