Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / April 2008

Tip: Looking for answers? Try searching our database.

Problem with Access 2007

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
FKlassen - 21 Apr 2008 22:14 GMT
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 - 22 Apr 2008 00:31 GMT
I would start by making sure you have the latest updates to Access 2007.
Office update will check it for you.

>Hi,
>
[quoted text clipped - 35 lines]
>
>FK

Signature

RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

FKlassen - 22 Apr 2008 16:17 GMT
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 - 22 Apr 2008 16:31 GMT
You're welcome.  Thanks for posting back with your success.

>It worked!
>
[quoted text clipped - 5 lines]
>>>
>>>FK

Signature

RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

FKlassen - 22 Apr 2008 17:31 GMT
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 - 22 Apr 2008 18:01 GMT
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.

>Unfortunately I spoke too soon.
>Problem has come back - and it's worse
[quoted text clipped - 18 lines]
>>>>>
>>>>>FK

Signature

RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

FKlassen - 22 Apr 2008 18:39 GMT
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 - 23 Apr 2008 00:04 GMT
Based on what I've been reading, many things are possible with Vista. ;)

>You are correct about the coffee break...but the strange thing is I still
>have the error messages with 2002.
[quoted text clipped - 15 lines]
>>>>>>>
>>>>>>>FK

Signature

RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.