If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Library references
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. |
#2
|
|||
|
|||
Library references
NotIsLoaded is not a built-in function. You need to include the VBA code for
it in your application. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Owl" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|