R
RealGomer
I'm now understanding why Microsoft intends to kill ACCESS by 2010.
I have a database orginally written in Access95. As each new version of
Access was installed in our office, I used the database utilities to "port"
the database to the new version. I also ran Repair and Compact regularly. Now
that we've installed Access 2003, I've had nothing but problems.
To navigate through the several forms, reports, and tables, I used
Switchboard Manager to create the links. I ran the database earleir and
realised I hadn't updated one table with new data for 2007. I added the
proper field and data to the table and everything seemed fine. Until I opened
the related form which would pull in the data. But that's a story for another
post. I closed Access when I went to lunch and when I tried to use the
Switchboard after restarting Access, I received the following error message
box:
The expression On Click you entered as the event property setting produced
the following error:
The expression you entered has a function name that can't be found.
* The expression may not result in the name of a user defined function, or
[Event Procedure].
* There may have been an error evluating the function, event, or macro.
The Show Help button gives this advice:
Visual Basic for Applications (VBA) encountered a problem while attempting
to access a property or method. The problem may be one of the following:
• A reference is missing.
For help restoring missing references, see the Microsoft Knowledge Base
article 283806.
• An Expression is misspelled.
Check all expressions used in event properties for correct spelling.
• A user-defined function is declared as a sub or as a private function in a
module.
Expressions can resolve a user-defined function only if the function is
declared as one of the following:
- A public function in a module
- A public or private function in a code module of the current form or report
• Security in Access is set to Medium or High and the Microsoft Jet 4.0 SP8
update is not installed.
A more recent verion of Jet 4.0 must be installed for Access to function
properly when security is set to Medium or High. To obtain the latest version
of Microsoft Jet, go to Windows Update.
I've done nothing to the table or form names, nor to the security settings,
nor to the Swithcboard. What gives?
I have a database orginally written in Access95. As each new version of
Access was installed in our office, I used the database utilities to "port"
the database to the new version. I also ran Repair and Compact regularly. Now
that we've installed Access 2003, I've had nothing but problems.
To navigate through the several forms, reports, and tables, I used
Switchboard Manager to create the links. I ran the database earleir and
realised I hadn't updated one table with new data for 2007. I added the
proper field and data to the table and everything seemed fine. Until I opened
the related form which would pull in the data. But that's a story for another
post. I closed Access when I went to lunch and when I tried to use the
Switchboard after restarting Access, I received the following error message
box:
The expression On Click you entered as the event property setting produced
the following error:
The expression you entered has a function name that can't be found.
* The expression may not result in the name of a user defined function, or
[Event Procedure].
* There may have been an error evluating the function, event, or macro.
The Show Help button gives this advice:
Visual Basic for Applications (VBA) encountered a problem while attempting
to access a property or method. The problem may be one of the following:
• A reference is missing.
For help restoring missing references, see the Microsoft Knowledge Base
article 283806.
• An Expression is misspelled.
Check all expressions used in event properties for correct spelling.
• A user-defined function is declared as a sub or as a private function in a
module.
Expressions can resolve a user-defined function only if the function is
declared as one of the following:
- A public function in a module
- A public or private function in a code module of the current form or report
• Security in Access is set to Medium or High and the Microsoft Jet 4.0 SP8
update is not installed.
A more recent verion of Jet 4.0 must be installed for Access to function
properly when security is set to Medium or High. To obtain the latest version
of Microsoft Jet, go to Windows Update.
I've done nothing to the table or form names, nor to the security settings,
nor to the Swithcboard. What gives?