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 Programming / July 2007

Tip: Looking for answers? Try searching our database.

Old event procedure not working in Access 2007

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steve S - 22 Jul 2007 21:02 GMT
Have a db created probably in Access 97, or earlier, that has worked in
access 2000 for 5 years just fine. After installing Office 2007 (left the
2000 versions of   Access, Word, and Excel on the PC)  I have a problem with
it.  Double Click on the file name, Access 2000 opens the db ok and displays
the Main Form which has 4 command buttons.  When I click on 3 of the 4
buttons I get the following error:

The expression On Click 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 evaluation the function, event, or macro

When I switch to design mode and try  to inspect the event procedure I  get
the following error:

“Microsoft access for windows has encountered a problem and needs to close.
Bla, bla,bla”, and Access closes.

The db functions normaly on a networked PC that does not have 2007
installed, both units are running XP home.  On the second unit I was able to
look at the Event Procedure that seems to be causing the error.  See below
---------------------------------------------------------------------------------------------------
Option Compare Database  
Private Sub Button0_Click()
On Error GoTo Err_Button0_Click

   Dim DocName As String
   Dim LinkCriteria As String

   DocName = "Record Expenses"
   DoCmd.OpenForm DocName, , , LinkCriteria

Exit_Button0_Click:
   Exit Sub

Err_Button0_Click:
   MsgBox Error$
   Resume Exit_Button0_Click
   
End Sub

What is going on here.  When will I ever learn to NEVER, NEVER, NEVER
install version 1.0 of ANY software.

Signature

Steve S

missinglinq - 22 Jul 2007 21:32 GMT
Apparently not soon enough! Sorry ;0(>

My personal standard is to never install any Micro$oft software until at
least 3 years post-premier!

You say you left Access 2000 on your machine, but are you running the
database thru AC2000 or thru AC2007? As I understand it, there are several
things that need to be done in order to run VBA code under AC2007. I forget
the ends and outs, but I think it involves placing things in a "trusted"
folder and some other things. I'd try Help and put in *VBA* or maybe someone
will pass by here and be able to give you more specific advice.

Out of curiosity, what was behind door (button) #4, the button that didn't
threw an error?

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

 
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.