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
|
|||
|
|||
Problem with Access 2007
Hi,
I downloaded a trial version of Access 2007 and it's causing me a lot of grief. If I open an application created with Access 2000 - with Access 2007 it opens and runs fine. Forms load and all controls work as intended. Then if I try to open it with Access 2000 I get an error message: The expression On Open you entered as the event property setting produced the following error: Object or class does not support the set of events. * The expression may not result in the name of a macro, the name of a user defined function, or [Event Procedure] * There may have been an error evaluating the function, event, or macro If I then hit the OK Button it asks me to input a parameter that normally gets entered from the main screen once its opened - after I choose to add a new record or edit an existing one. Its like the query that fills in the data wants to run before its intended to run. If I hit OK or CANCEL then I get another error message saying the same thing about the On Load event. If it hit OK the form will actually open and focus will go to a control other than its supposed to. It's a text box and anything I do at this point causes the On Exit event to cause another similar message. Now here's the goofy part: If I use Access 2000 to open an "archived" version of the application - one that has never been opened by Access 2007 it operates as it supposed to. So it would appear that Access 2007 has somehow altered the code or is doing something different than Access 2000. I have tried using the SAVE AS ACCESS 2000...but no luck. Does anyone have any idea how to overcome this? FK |
#2
|
|||
|
|||
Problem with Access 2007
I would start by making sure you have the latest updates to Access 2007.
Office update will check it for you. FKlassen wrote: Hi, I downloaded a trial version of Access 2007 and it's causing me a lot of grief. If I open an application created with Access 2000 - with Access 2007 it opens and runs fine. Forms load and all controls work as intended. Then if I try to open it with Access 2000 I get an error message: The expression On Open you entered as the event property setting produced the following error: Object or class does not support the set of events. * The expression may not result in the name of a macro, the name of a user defined function, or [Event Procedure] * There may have been an error evaluating the function, event, or macro If I then hit the OK Button it asks me to input a parameter that normally gets entered from the main screen once its opened - after I choose to add a new record or edit an existing one. Its like the query that fills in the data wants to run before its intended to run. If I hit OK or CANCEL then I get another error message saying the same thing about the On Load event. If it hit OK the form will actually open and focus will go to a control other than its supposed to. It's a text box and anything I do at this point causes the On Exit event to cause another similar message. Now here's the goofy part: If I use Access 2000 to open an "archived" version of the application - one that has never been opened by Access 2007 it operates as it supposed to. So it would appear that Access 2007 has somehow altered the code or is doing something different than Access 2000. I have tried using the SAVE AS ACCESS 2000...but no luck. Does anyone have any idea how to overcome this? FK -- RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200804/1 |
#3
|
|||
|
|||
Problem with Access 2007
It worked!
Thanks alot. "ruralguy via AccessMonster.com" u12102@uwe wrote in message news:830820d86a7da@uwe... I would start by making sure you have the latest updates to Access 2007. Office update will check it for you. FKlassen wrote: Hi, I downloaded a trial version of Access 2007 and it's causing me a lot of grief. If I open an application created with Access 2000 - with Access 2007 it opens and runs fine. Forms load and all controls work as intended. Then if I try to open it with Access 2000 I get an error message: The expression On Open you entered as the event property setting produced the following error: Object or class does not support the set of events. * The expression may not result in the name of a macro, the name of a user defined function, or [Event Procedure] * There may have been an error evaluating the function, event, or macro If I then hit the OK Button it asks me to input a parameter that normally gets entered from the main screen once its opened - after I choose to add a new record or edit an existing one. Its like the query that fills in the data wants to run before its intended to run. If I hit OK or CANCEL then I get another error message saying the same thing about the On Load event. If it hit OK the form will actually open and focus will go to a control other than its supposed to. It's a text box and anything I do at this point causes the On Exit event to cause another similar message. Now here's the goofy part: If I use Access 2000 to open an "archived" version of the application - one that has never been opened by Access 2007 it operates as it supposed to. So it would appear that Access 2007 has somehow altered the code or is doing something different than Access 2000. I have tried using the SAVE AS ACCESS 2000...but no luck. Does anyone have any idea how to overcome this? FK -- RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200804/1 |
#4
|
|||
|
|||
Problem with Access 2007
You're welcome. Thanks for posting back with your success.
FKlassen wrote: It worked! Thanks alot. I would start by making sure you have the latest updates to Access 2007. Office update will check it for you. [quoted text clipped - 42 lines] FK -- RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via http://www.accessmonster.com |
#5
|
|||
|
|||
Problem with Access 2007
Unfortunately I spoke too soon.
Problem has come back - and it's worse After I downloaded the updates (both Office 2007 and 2002 - I thought I was running MS Office 2000 but it's really 2002) I opened one of my apps with Access 2002 and it opened perfectly. Then I opened it with 2007 - and ever since dong that the problem is back. And now what happens is every time I open an app Windows says it can't find it and then it re-configures either Office 2007 or 2002 - depending on which version I'm trying to use. Maybe the two versions are not able to co-exist on the same PC. I guess i will ahve to uninstall the tyeh 2007 an see if that fixes things. It is funny though as I have had the rial installed since around the end of February and this issue just started recently. *&&$@$ ^%*&^*&^*^% computers. "ruralguy via AccessMonster.com" u12102@uwe wrote in message news:831081bc04ef1@uwe... You're welcome. Thanks for posting back with your success. FKlassen wrote: It worked! Thanks alot. I would start by making sure you have the latest updates to Access 2007. Office update will check it for you. [quoted text clipped - 42 lines] FK -- RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via http://www.accessmonster.com |
#6
|
|||
|
|||
Problem with Access 2007
What you are describing is the Office 2007 coffee break! The two can coexist
on a PC but each time you run "the other version" there is a reconfiguration that takes place. So after running Access 2002, when you run Access 2007 it needs to "install" again. After running Access 2007, when you run Access 2002 again it will need to "install". The delay is shorter going from 2007 to 2002 and the updates have made the 2002 to 2007 delay shorter that before but it still takes time. Sorry. FKlassen wrote: Unfortunately I spoke too soon. Problem has come back - and it's worse After I downloaded the updates (both Office 2007 and 2002 - I thought I was running MS Office 2000 but it's really 2002) I opened one of my apps with Access 2002 and it opened perfectly. Then I opened it with 2007 - and ever since dong that the problem is back. And now what happens is every time I open an app Windows says it can't find it and then it re-configures either Office 2007 or 2002 - depending on which version I'm trying to use. Maybe the two versions are not able to co-exist on the same PC. I guess i will ahve to uninstall the tyeh 2007 an see if that fixes things. It is funny though as I have had the rial installed since around the end of February and this issue just started recently. *&&$@$ ^%*&^*&^*^% computers. You're welcome. Thanks for posting back with your success. [quoted text clipped - 7 lines] FK -- RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via http://www.accessmonster.com |
#7
|
|||
|
|||
Problem with Access 2007
You are correct about the coffee break...but the strange thing is I still
have the error messages with 2002. Every event - in the order they occur on opening an application - fires and causes the same message. Here's what else I found out: I have another PC in my office that I use for testing stuff. I installed the 2007 trial on it and I installed ONLY Access 2000. The coffee break behaviour still occurs but I do not get the error messages when I run an app with Access 2000. Next I will un-install Access 2000 and install Access 2002 and see what happens. The other difference is my PC is running Vista and my test PC is XP so that complicates things too. "ruralguy via AccessMonster.com" u12102@uwe wrote in message news:83114add69ca3@uwe... What you are describing is the Office 2007 coffee break! The two can coexist on a PC but each time you run "the other version" there is a reconfiguration that takes place. So after running Access 2002, when you run Access 2007 it needs to "install" again. After running Access 2007, when you run Access 2002 again it will need to "install". The delay is shorter going from 2007 to 2002 and the updates have made the 2002 to 2007 delay shorter that before but it still takes time. Sorry. FKlassen wrote: Unfortunately I spoke too soon. Problem has come back - and it's worse After I downloaded the updates (both Office 2007 and 2002 - I thought I was running MS Office 2000 but it's really 2002) I opened one of my apps with Access 2002 and it opened perfectly. Then I opened it with 2007 - and ever since dong that the problem is back. And now what happens is every time I open an app Windows says it can't find it and then it re-configures either Office 2007 or 2002 - depending on which version I'm trying to use. Maybe the two versions are not able to co-exist on the same PC. I guess i will ahve to uninstall the tyeh 2007 an see if that fixes things. It is funny though as I have had the rial installed since around the end of February and this issue just started recently. *&&$@$ ^%*&^*&^*^% computers. You're welcome. Thanks for posting back with your success. [quoted text clipped - 7 lines] FK -- RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via http://www.accessmonster.com |
#8
|
|||
|
|||
Problem with Access 2007
Based on what I've been reading, many things are possible with Vista.
FKlassen wrote: You are correct about the coffee break...but the strange thing is I still have the error messages with 2002. Every event - in the order they occur on opening an application - fires and causes the same message. Here's what else I found out: I have another PC in my office that I use for testing stuff. I installed the 2007 trial on it and I installed ONLY Access 2000. The coffee break behaviour still occurs but I do not get the error messages when I run an app with Access 2000. Next I will un-install Access 2000 and install Access 2002 and see what happens. The other difference is my PC is running Vista and my test PC is XP so that complicates things too. What you are describing is the Office 2007 coffee break! The two can coexist [quoted text clipped - 32 lines] FK -- RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200804/1 |
Thread Tools | |
Display Modes | |
|
|