Hi there,
I recently updated to Access 2007, and I'm getting a couple of errors that i'm not sure how to deal with.
I worked with a lot of databases in Access 2003 (.mdb), and for some reason some of these databases will not open in access 2007.
The errors I get say:
"An error occured while loading 'Form_frm_tabst rip'. do you want to continue loading the project?" I can choose yes, no or help.
On choosing yes, another message box pops up that says:
"The expression On Open you entered as the event property setting produced the following error: Invalid procedure call or argument.
*The expression may not result in the name of the macro, the name of a used defined function, or [event procedure].
*There may have been an error evaluating the function, event or macro.
I'm given the option to show help, and when I click on this it says:
"This error occurs when an event has failed to run because Microsoft Office Access cannot evaluate the location of the logic for the event. For example, if the OnOpen property of a form is set to =[Field], this error occurs because Access expects a macro or event name to run when the event is fired."
On choosing no after the first error, a message box popos up and says:
"The data cannot be opened becasue the VBA project contained in it cannot be read. The database can only be opened if the VBA project is first deleted. Deleting the VBA project removes all cose from modules, forms and reports. You should back up the database before attempting to open the database and delete the VBA project.
To create a backup copy, click cancel and then make a backup copy of your database. To open the database and delete the VBA project without creating a backup copy, click OK" and I'm given the chooise of choosing OK or cancel, and I choose cancel.
Why won't my VBA code load for this database? I have different versions of this database with identical code, and these databases load perfectly fine.
I recently updated to Access 2007, and I'm getting a couple of errors that i'm not sure how to deal with.
I worked with a lot of databases in Access 2003 (.mdb), and for some reason some of these databases will not open in access 2007.
The errors I get say:
"An error occured while loading 'Form_frm_tabst rip'. do you want to continue loading the project?" I can choose yes, no or help.
On choosing yes, another message box pops up that says:
"The expression On Open you entered as the event property setting produced the following error: Invalid procedure call or argument.
*The expression may not result in the name of the macro, the name of a used defined function, or [event procedure].
*There may have been an error evaluating the function, event or macro.
I'm given the option to show help, and when I click on this it says:
"This error occurs when an event has failed to run because Microsoft Office Access cannot evaluate the location of the logic for the event. For example, if the OnOpen property of a form is set to =[Field], this error occurs because Access expects a macro or event name to run when the event is fired."
On choosing no after the first error, a message box popos up and says:
"The data cannot be opened becasue the VBA project contained in it cannot be read. The database can only be opened if the VBA project is first deleted. Deleting the VBA project removes all cose from modules, forms and reports. You should back up the database before attempting to open the database and delete the VBA project.
To create a backup copy, click cancel and then make a backup copy of your database. To open the database and delete the VBA project without creating a backup copy, click OK" and I'm given the chooise of choosing OK or cancel, and I choose cancel.
Why won't my VBA code load for this database? I have different versions of this database with identical code, and these databases load perfectly fine.
Comment